In doing research for the Service SID posting, I encountered some odd things about service names, service user group names and services. I said I'd
A couple of weeks ago at DevDays Netherlands, I struggled a bit with a demo that was relatively straightforward in SQL Server 2008 running under Windows
I've been looking at the Extended Event library and PowerShell provider "directory" in Denali and decided that I like it. It's a traditional SMO set
I've been going through the XEvents in Denali CTP1 in a fairly rigorous amount of detail, looking for what's changed and specifically for breaking changes.
You may have wondered what happened to the technical blog entries lately. Since January (and actually including January) its been constant traveling. In the month
A few months ago, I published a blog entry entitled "The interesting case of TVPs and plan compilation" about the fact that a plan compile
Just realized that there's less than a week until my precon on SQL Server stored procedure and application performance at DevWeek 2011 in London. It's been
Next week I'm heading to Stockholm, Sweden to present a two-day seminar next Thursday and Friday (March 10-11) on "Writing High Performance SQL Server Database
I'd been fretting over the lack of a true visualizer for the new circularstring and compoundcurve spatial types in SQL Server Denali. I'd installed SSMS
One of the interesting spatial features in SQL Server Denali is the inclusion of spatial aggregates, namely CollectionAggregate, ConvexHullAggregate, EnvelopeAggregate, and UnionAggregate. Here's an example
When I originally wrote the SQL Server Denali full-text search on properties cheap demo, I used property sets with properties (GUIDs) that I got from
I was telling students this week about the story of the semicolon and SQL Server. And, when going over some Denali demos, it came up
I'll be speaking at the New York City SQL Server user group next Thursday (Jan 27) on "What's New in the SQL Server Denali Database
I'm getting my plane tickets and plans together for DevWeek 2011 in London, coming up in March. I'll be doing a preconference workshop on "Writing SQL
I've recently completed an update to the SQL Server 2005 Security Best Practices whitepaper. It's available on the security and compliance website under whitepapers or the
I'll be making my first trip to sunny Stockholm, Sweden in March, to do a two-day seminar on 10-11 March, as part of Addskills' Expertseminarium
At SQLPASS a couple of months ago, Microsoft announced SQL Server Denali and, at during the conference, handed out CTP1. Nice. But, the conference keynotes and
The nearest neighbor query is one of the most common queries against spatial data. How many people haven't gone to a mapping app, typed in
Now about that "other" feature that could be called fullglobe in Denali that I mentioned. I don't know which feature will retain the moniker or
Once upon a time, I wrote a blog entry about CircularString, CompoundCurve, and CurvePolygon (the new geometric types supported in Denali). And mentioned that they
So what's the area of the earth? Well…depends on who's measurement you want to use. There an interesting SQL Server Denali spatial feature known as
I've been trying out the new Denali "AUTO_GRID" spatial index (that is …USING GEOGRAPHY_AUTO_GRID or GEOMETRY_AUTO_GRID in the CREATE SPATIAL INDEX DDL) on some of
A couple of people reported problems with SQL Server 2008's table-valued parameters and it eventually got back to me. Had to try it out. The
So here's a cheap demo of FTS property search in Denali. For the motivation for this feature, see the previous blog entry. I'm a minimalist
Years after its inception, I think I've figured out what WinFS was supposed to do. It sometime takes me a while. I got a new
Safe Software, the premier spatial data transformation and loading vendor for SQL Server, has long been known for it flagship FME Desktop and FME Server
Some intersting things happened in the SQL Server certification space while I was away. Joe Sack announced A New Path to Microsoft Certified Master: SQL Server
TechEd Europe 2010 ended yesterday. I thought I'd write about it when I got home, but now I'm unsure if that will happen in a
Quick correction to my PowerShell Denali CTP1 post here. Max Trinidad did the obvious get-command call and found some new PowerShell cmdlets related to the new HADR feature. Knew
OK, last one for the evening, its getting late in Berlin. And BTW, we might have some Denali goodness here at TechEd. Search for "futures",
Only because I've been waiting for it since I first saw try-catch back in 2005 beta 2 or something. In dirt-simple code: begin try delete jobs end
Once upon a time, there was to be a SQL Server-based file system for Windows. This file system would not only let you search on
SQL Server Denali CTP1 was released today. I don’t want to be the fiftieth person to post the link to the download; reference Ed's blog
Just having a look at PowerShell support in SQL Server Denali CTP1. In Denali you must install PowerShell V2 or it will be installed as
Last week I wrote about presenting at SQLConnections, but forgot that the week immediately afterwards is TechEd Europe in Berlin. So…another chance for shameless self-promotion
It's just about another month until this fall's SQL Server Connections conference on Nov 1-4 in Las Vegas. I thought I'd give some background as
This happened about a month ago. I'd meant to post earlier, but got busy… My old friends (well, the friendships are old, I'm actually the
After a fairly quiet first half of the summer, I've done quite a bit of traveling lately. But, as Joe Celko or someone once said,
I've been back at work on StreamInsight lately, and looking at using the Windows service-based host rather than run a self-contained .exe. Since I'd also
I received an interesting question today that I started to answer in email, then realized it would make a good blog post. It went something
In my blog entry from about a month and a half ago, I summarized my finding on using Visual Studio 2010 with SQLCLR, and the
Last week I was at TechEd in New Orleans, presenting, manning the SQL Server Security and Managability station, meeting with friends and business associates, and,
I usually have a number of different versions of SQL Server around, installed on Virtual PCs. Usually works fine. So I was a bit surprised
This posting is a journey through StreamInsight 1.0 APIs, undertaking by porting the CTP3 samples. Part 3. In the StreamInsight CTPs, there existed three methods to code
This posting is a journey through StreamInsight 1.0 APIs, undertaking by porting the CTP3 samples. Part 2. So let's update the SimulatedDataInputFactory provider, now. The
This posting is a journey through StreamInsight 1.0 APIs, undertaking by porting the CTP3 samples. The first look at the errors produced by recompiling the
StreamInsight V1.0 RTM'd a few weeks ago. Although I worked with it, looking especially at the infrastructure and programming models, I just installed the RTM
There's a special kind of project for SQLCLR development in Visual Studio. It's been around since Visual Studio 2005, when SQLCLR was introduced in SQL
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.