Loading ShapeFiles into SQL Server 2008 and 2012
Since I find myself "in a spatial mood", I thought I'd write one more today. About importing data from shapefiles. According to Wikipedia "The Esri
Menu
Since I find myself "in a spatial mood", I thought I'd write one more today. About importing data from shapefiles. According to Wikipedia "The Esri
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
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
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
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
I've been busy for the last few weeks putting together a "manifesto" whitepaper about the .NET-based data access stacks and also the possibilities for .NET
When I downloaded SQL Server 2008 R2 CTP2 last week, I went right by (for now) the cool Gemini features and even Multi Server Management
And a CTP is available now. I first heard of the .NET Complex Event Processing engine at this year's TechEd. Until lately, all we had
Just got a mail message from an old friend who asked why I'd dropped out of sight in the past month of so. I've been
About a month ago, I received a copy of "Beginning Spatial with SQL Server 2008" by Alastair Aitchison. I've become acquainted with Alastair through his
My interview with the folks at RunAs Radio is out. I'm discussing one of my favorite topics, spatial data and spatial in SQL Server 2008,
My latest article on out. It's in the May issue of MSDN magazine, and can be found here. It this article I explore the internals of
I've answered quite a few questions lately about how to make sure that your spatial index is being used. Use of a spatial index with
On experimenting with the CTP of SQL Server 2008 SP1, I found that there were some changes made to the costing algorithm, vis-a-vis spatial indexes.
I've become a columnist for MSDN magazine and my first column is available in the online edition, Feb 2009 issue today. I'm doing a column
Today I came across the new SQL Server 2008 Compliance Portal. This portal has information and links to the new Compliance whitepaper and compliance scripts
When SQL Server's spatial data types were introduced, people asked "Why does every standard method begin with ST" (e.g. STIsEmpty). SQL Server docs always cite
Yesterday a friend asked me if it was better to always use a value of GEOMETRYCOLLECTION EMPTY as an alternative to making a geometry/geography column nullable. OGC
I've devoted the last few blog entries to describing what's in that spatial index analysis proc output and how to use it and interpret the
A little more about the query sample that gets fed into the spatial index procs. Query sample is a singleton geometry or geography. It's not
Last post discussed the filters. The procs report some raw numbers and some derived numbers. Here's a cheat sheet, although the info is all in
The spatial index diagnostic procs' most enlightening pieces of information have to do with the filter counts and efficiencies reported at the end of the
I've been looking at the spatial index stored procedures (sp_help_spatial_geography_index_xml and friends) a little harder recently, in an attempt to help answer two questions. 1.
I've been doing talks and demos on SQL Server 2008 Extended Events for a while now, it's one of my favorite parts of the product.
I remember hearing during the SQL Server 2008 beta that there would be diagnostic stored procedures that would produce information about spatial indexes and help
I'm not usually one to post product announcements, but I had to point out that the Service Broker External Activator shipped with the latest (Oct
It's almost November and I'm in the final phase of getting ready for a road trip. In the next three weeks I'll be speaking on
In the past year or so, a few installations had begun to experience problems with the SQL Server 2005 security cache (aka TokenAndPermUserStore) growing too
A friend of mine was asking about the affect of multi-targeting in Visual Studio 2008 on SQLCLR. For an explanation of how multi-targeting works, reference
Although being able to use a GUI tool like SQL Server Management Studio is a nice feature by itself, it's unusual that fixing something in
Extended Events is one of my favorite SQL Server 2008 features and I’ll be speaking about how to use them for problem diagnosis, at the Portland
After reading Isaac's recent blog posting about spatial queries and index hinting, I thought I might add some information based on a query I was working
When SQL Server 2008 shipped, Visual Studio 2008 SP1 and .NET 3.5 SP1 shipped a few days later. Visual Studio SP1 contains some neat enhancements
One of my favorite new features of SQL Server 2008 is extended events. I've written a bunch of blog entries on 'em (use the search,
Folks have always had trouble with the fact that ring orientation is required with spatial instances if you're using SQL Server 2008's geography data type, but not
I came across the following interesting behavior while testing a SQLCLR table-valued function that did work in SQL Server 2005 SP2 but doesn't work at
For attendees of last Thursday’s talk on SQL Server Spatial for the masses, the demo code is located here. Thanks for coming and for your
.NET (and therefore SQLCLR) divides up running its code (even within the same process like the sqlserver.exe process) into appdomains. The appdomain is like a
I’ve been able to coordinate being home and the Portland (Oregon) SQL Server user group’s meeting schedule, so next week I’ll be speaking “at home”
I've noticed that some folks have written PowerShell scripts that execute against a list of servers. In the scripts, they read the names of the
I received a question today about whether I'd converted my Policy-Based Management examples using SMO (see the multi-part "Programming Policy-Based Management with SMO" series, starting here)
Last week at TechEd Developers, I gave a talk on PowerShell and SQL Server. I mentioned some upcoming changes in RC0, and have just had
SQL Server 2008 RC0 comes with a Readme file and a Release Notes file. It’s always good to read both. In this RC, the readme
There's a newer version of SQL Server 2008 (Release Candidate 0) available on MSDN and Technet. Another performance-related feature (actually its additional information) allows you
There's a newer version of SQL Server 2008 (Release Candidate 0) available on MSDN and Technet. There's a couple of features that show up in
In a blog posting about a few weeks ago, I'd written about noticing a DataSet being created in an Entity Framework program by using the
I’m getting ready to head out to TechEd in Orlando. I’ll be doing a full day of SQL Server 2008 for Developers on Monday, a
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.