At Tech Days in The Netherlands next month
Just confirmed that I'll be speaking at TechDays 2012 NL in Den Haag. I'll be speaking on Feb 16th and 17th, and I'm really looking forward to
Menu
Just confirmed that I'll be speaking at TechDays 2012 NL in Den Haag. I'll be speaking on Feb 16th and 17th, and I'm really looking forward to
I've had the good fortune to be invited back to Stockholm as part of Addskills Expertseminarium Series. This seminar, An In-Depth Look at Developer Features
Just back from a small hiatus and getting my schedule together for the first half of the year. One thing I'm really looking forward to
Late tonight I tried something that I didn't think would work because @@version on SQL Azure didn't report anything different from last week. (Microsoft SQL
It's gotten around to the week of the Portland, Oregon, SQL Server User Group meeting. And there's not only going to be a holiday dinner,
Got to take some time out from research and writing because yesterday Paul Randal announced SQLskills' first series of SQL Server Immersion training classes for
… Continued from previous blog entry … The point of using a Server Audit Specification with database events in SQL Server 2012 is this. In
I've always been pretty "standard" in my approach to SQL Server's auditing feature. That is, Server Audit Specifications are for auditing server-level objects and Database
When I installed CTP3 of SQL Server 2012 (on Windows Server 2008 R2 OS), I noticed that the "Service SID account" (known as the Managed
As I mentioned in a few previous blog entries, SQL Server 2012 runs the .NET 4 version inside of SQL Server. Your SQLCLR code may be
In SQL Server 2012, SQLCLR now loads .NET 4.0 code rather than .NET 2.0 as in previous versions of SQL Server. Note that the "main
Just had the occasion to look at SSIS Sources and Destinations in SQL Server 2012 RC0. After reading about the stated direction to use ODBC
Last week, while teaching a class based around SQL Server 2008 R2, I happened to "brag up" the new tools in SQL Server 2012, mainly
Speaking at a user group is a bit different from speaking at a conference or other event. Because you know the folks there personally (hi
This post is about the changes in the client stack for SQL Server 2012. It's a very short post. The last two major releases of
A short while ago, I wrote a blog entry about SQL Server 2012 features that are currently available in SQL Azure. In that post, I
Since SQL Server Denali adds support for index compression of spatial indexes, using the same options as data and index compression in SQL Server 2008 and
After the last post on new warnings in SQL Server Denali Showplan, just for the fun of it, I had a look at the XML
Sort and hash warnings can be found using SQL Server profiler, but they don't appear in query plans like "Columns With No Statstics" warnings in
Earlier this month I noticed that SQL Azure, with the latest upgrade has a version of 11…something (actually 11.0.1467.26, to be exact). And I wondered,
With the release of SQL Server Denali approaching, (some Denali features are already available in SQL Azure Database), I've decided its time to sift a
The new Semantic Search feature of SQL Server Denali enhances full-text search by letting you do a search on the meaning of documents. To use
I've been looking at full-text query plans in Denali lately, and looking at the SQL query plan for the full-text part, there isn't much to see
Saw a request on the SQL Server spatial forum this morning for routines that would decompose a geography type to a set of Lat/Longs. A
I've been working lately with SQL Server Denali's Semantic Search feature. There's a more complete description of this feature (as well as how to set
SQL Server Denali's new Filetable feature and full-text search are made for each other. Set up database for non-transactional filestream access with a directory name,
I've been trying this out every day or so since I'd heard about the update (originally named the July 2011 Service Release), but I'd forgotten
The writing has been on the wall for some time, but a few days ago Microsoft made it official. OLE DB will no longer be
I’ve always been interested in SQLCLR, and wondered about the potential for producing libraries of useful functions for a variety of specialist purposes. With the
Once upon a time (well, now, currently), there were two memory allocators in SQL Server, the single-page allocator and the multi-page allocator. The single-page allocator
I'm not usually one for repeating stuff you can find in BOL. Usually, a waste of your time and mine. But this feature, for SQL
In the previous post, I insinuated that allowing LAG/LEAD to be sensitive to value RANGEs might help with series of data with missing values. It
You've heard my rant before "measure what you think you are measuring". If not, follow the link. Here's an example using the LAG function, new
A (couple of days late) thanks to all the folks that attended my "What's New in Denali" demo fest at Portland SQL Server User Group
So, quickly on the heels of the first window clause and last_value() question, came a followup: OK smartie, why does last_value work fine here? I
I've been working with the new Denali T-SQL windowing functionality and ran into someone who asked about this "problem". It's almost sure to become an
I've been trying out the windowing extensions (the OVER clause extensions and friends) with different kinds of functions (aggregate functions, first_value, last_value() etc), and thought
Two of the security features that folks have asked me about, especially since around 2002, is row-level and label security. Row-level security was present in
I'm always leery when I hear people say "statistics show that…" followed by whatever their opinion is. Scientists do it. And your users probably do it
After talking with folks about the SQLskills DBA Immersion training, one thing that always comes up is the fact that database developers feel left out.
After downloading CTP3, I immediately (well, almost immediately) went to set the options to view Books Online from local storage. You'all do know how to
So I was awake late last night and, lo and behold, there was a web link for Denali CTP3 posted on Twitter. Downloaded and installed
Just to let you know… I'll be speaking at the Portland, OR, SQL Server User Group meeting this month on July 28. The topic will
The next version of Data-Tier Applications is version 2.0. You can get a CTP of it today; where the CTP is located really gives away
So DAC 1.1 has been out for a while (since March 2, 2011) now. The big change is that the DAC "upgrade" process is now
About a week or so ago, I read a request for information about a SQL Server database management feature known as Data-Tier Applications, abbreviated as
In looking at the what's new for SQL Azure (May 2011) page, I came across the following: "Upcoming Increased Precision of Spatial Types: For the
A variation of the following question came up in a mail list that I’m on. Can you see currently executing SQLCLR code statements (i.e. the
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.