SQL Server security precon at TechEd 2010.
This blog posting is meant to bring attention to the fact that I'm doing a preconference talk, "A Day of SQL Server Security" at TechEd
Menu
This blog posting is meant to bring attention to the fact that I'm doing a preconference talk, "A Day of SQL Server Security" at TechEd
Last week I did a talk at SQLConnections on SQL Azure Database and Data-Tier Applications (DAC). At the time (it was the day of Visual Studio
I did a few demos in the spatial visualization talk at SQLConnections using the AdventureWorks 2008 data. The Person.Address table is all geocoded and so
I had a great time at SQLConnections last week, and got to talk to a lot of the attendees and speakers during lunches and breaks. It was
In just over a week, I'm headed out to Las Vegas for SQLConnections. I'm really looking forward to presenting on the topics I'm doing there,
Michael J Swart posted a SQL query on his blog that produced a rendition of Botticelli’s Birth of Venus, in the spatial results tab of
I was trundling through my SQL Azure database today, looking for interesting behaviors. Found one. A "select * from sys.databases" reveals that both "snapshot_isolation_state" and
There's another change to the SQL Server database engine in SQL Server 2008 R2. This concerns poison-message handling behavior in Service Broker applications. Service broker's
As long as I'm blogging about filestreams… Folks always want to know if the filestream information can be stored on a remote share. They look
I was under the impression that the database engine/programming model changes in SQL Server 2008 R2 were minimal and could be counted on one hand.
In the last installment about the object model, let's the at the third development style, using .NET's IObservable/IObserver. IObservable/IObserver is a new interface in .NET
Now that you know the StreamInsight metadata (see inside the metadata), its fairly easy to take apart the implicit model because you already know which
The StreamInsight object model seems fairly complex at first. There's a series of choices as you progress down the development path which make things appear
I thought it was curious that in a DACPAC you can specify required version and edition of SQL Server as a deployment option. But DAC (Data-Tier
Folks that are on early betas of products (especially private betas) are not surprised when projects are not updatable between beta versions. These limits are
SQL Server Management Studio in 2008 R2 (and there's a standalone upgrade for SSMS) supports connecting to SQL Azure. And there were some tools on
Yesterday I signed up for my account to the official, live, RTM cloud. Of course it was all for the SQL Server, that is, SQL
Everyone is still recovering from the November conference weeks (reminds me of sweeps week on TV). As a "SQL guy" the conferences in the last
No, the secret word for tonight is not "mudshark", although it does begin with the letter M. It's modeling. SQL Server data can be modeled
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
My latest MSDN magazine column on Visualizing Spatial Data is out in the Novemeber issue. It covers three ways to visualize SQL Server 2008 spatial
I had a great time at TechEd Europe in Berlin last week. Spent a lot of time in the SQL Server booth, meeting, greeting, and
Last night (here in Europe) I started to receive notices about SQL Server 2008 R2 CTP3 being available for MSDN/Technet customers. Among the list of
I've been remiss, October 2009 was the first month with no blog entries in a long while. I'm been heads down, working on some projects
There are two slightly different ways of representing non-existing spatial data, the "empty geometry" concept and database NULL. You can read about the subtle differences
I've found out that a few of my talks have been accepted for TechEd 2009 Europe, which will take place this year in Berlin, Germany,
I'm speaking at the Portland SQL Server User Group meeting this month about What's New in the SQL Server World. I'll be talking about upcoming
People are sometimes concerned with the lifetime of temporary tables they create in CLR code. As an example, if I use a parameterized statement in
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
I'm always thought that what makes or breaks any ORM layer for use in any but the simplest of applications is the underlying SQL code
Today I posted the code to a projcect I've been working on, a library that creates KML documents from SQL Server 2008 geography instances or
Last week, Microsoft released the MapPoint 2009 Add-In for SQL Server 2008 Spatial. You can get it here. This add in allows you to add layers
My latest MSDN column is available in the August issue and called "How Data Access Affects Database Performance". It was inspired by a problem that
I really enjoyed speaking at the Portland SQL Server User Group meeting last night about SQL Server security…and I have an update. We were talking about
During a talk about spatial indexes and performance last week, I was surprised by a question about using ANSI-92 JOIN – ON syntax in spatial
Went through 2 years worth of blog entries looking for comments to approve. Sorry that I've been remiss in doing that. I have to approve
Last week I attended my first-ever ESRI conference in San Diego. Although the "star of the show" was version 9.3.1 and the upcoming version 9.4
This month I'll be presenting a session for the Portland SQL Server User Group. I'll be discussing and demonstrating the new security features in SQL Server
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
For those of you who's blog readers don't always get updated (rather than brand new) blog entries, there's a happy ending to my last "fixed-almost"
One of the first things that I did after installing VS2010 beta this week was to check on a parameterization problem with string parameters, and
I finally got around to install .NET 4.0 CTP today on a SQL Server box to test a long-held theory. Didn't quite work out the
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
The latest "chain letter" type topic to wend it's way through the blogsphere is "things you now know" and I've been tagged. Here's some things
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.