Aggregated Feeds

Show all index and heap access operators in the plan cache

rusanu.com — Sat, 28 Jan 2012 01:42:44 GMT

with xmlnamespaces (default 'http://schemas.microsoft.com/sqlserver/2004/07/showplan') select x.value(N'@NodeId',N'int') as NodeId , x.value(N'@PhysicalOp', N'sysname') as PhysicalOp , x.value(N'@LogicalOp', N'sysname') as LogicalOp , ox.value(N'@Database',N'sysname')...(read more)

XEvents in SQL Server 2012: No more "lazy XML" in event harvesting scripts

Bob Beauchemin's Blog — Mon, 23 Jan 2012 06:49:00 GMT

I've said before how thrilled I am will the new extended event UI in SSMS for SQL Server 2012. However, you might be one of the early adopters who made up their own scripts to define extended event sessions, and use hardcoded scripts to harvest the...(read more)

What is an LSN: Log Sequence Number

rusanu.com — Wed, 18 Jan 2012 05:33:28 GMT

LSNs, or Log Sequence Numbers, are explained on MSDN at Introduction to Log Sequence Numbers: Every record in the SQL Server transaction log is uniquely identified by a log sequence number (LSN). LSNs are ordered such that if LSN2 is greater than LSN1,...(read more)

SQL Server 2012 FileTable and T-SQL on AlwaysOn secondary replicas

Bob Beauchemin's Blog — Tue, 17 Jan 2012 06:01:00 GMT

OK, back to PathName() with AlwaysOn, which I started on in the previous blog post . PathName() in SQL Server 2012 doesn't return the computer name by default ("AlwaysOn1" or "AlwaysOn2" in my example) but returns the VNN name...(read more)

SQL Server 2012 FileTables - AlwaysOn support and PathName()

Bob Beauchemin's Blog — Tue, 17 Jan 2012 04:03:00 GMT

When I was covering the FileTable-specific functions and methods, I didn't mention PathName(), a filestream-related function, that (naturally) can be used with FileTables. This posting is about PathName(), but, mostly about what happens with FileTable...(read more)

SQL Server 2012 FileTables in T-SQL part 3: hierarchyid methods

Bob Beauchemin's Blog — Mon, 16 Jan 2012 07:06:00 GMT

So finally, we get to using FileTable's path_locator column with the methods of hierarchyid. To pick up where we left off , remember that hierarchyid has a method named GetLevel(). Given the following directory structure in the FileTable's share:...(read more)

SQL Server 2012 FileTables in T-SQL part 2: new rows

Bob Beauchemin's Blog — Mon, 16 Jan 2012 02:00:00 GMT

So the functions/methods that I wrote about in previous post are needed because FileTables don't store the UNC path name of the file, they store the path_locator as a hierarchyid data type. Wonder what encoding scheme they're using. Let's...(read more)

SQL Server 2012 FileTables in T-SQL part 1: functions and methods

Bob Beauchemin's Blog — Sun, 15 Jan 2012 16:17:00 GMT

I've been working with the SQL Server 2012 FileTable feature lately. Besides learning to appreciate the esoteric features of the NTFS file system and SMB protocol, only some of which are supported by FileTables, I've been trying to work with FileTables...(read more)

At Tech Days in The Netherlands next month

Bob Beauchemin's Blog — Wed, 11 Jan 2012 17:17:00 GMT

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 it. I'll be doing some talks on SQL Server 2012 and SQL Azure Database features including T-SQL...(read more)

Expertseminarium in April: Performance for Developers in SQL Server 2012

Bob Beauchemin's Blog — Sun, 08 Jan 2012 17:10:00 GMT

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 and Performance in SQL Server 2012, will be two days of studying performance, diagnostic...(read more)

SQLskills Developer Immersion Events this year

Bob Beauchemin's Blog — Wed, 04 Jan 2012 05:01:00 GMT

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 is the two public SQLskills Immersion Events for developers. These are week-long events taught specifically for...(read more)

SQL Azure Federations are here. At least on my server...

Bob Beauchemin's Blog — Mon, 12 Dec 2011 01:20:00 GMT

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 Azure (RTM) - 11.0.1814.30 Nov 21 2011 16:46:09 Copyright (c) Microsoft Corporation)....(read more)

Back to my personal blog

Raul Garcia's blog — Tue, 06 Dec 2011 03:01:20 GMT

I am no longer part of the SQL Server team, but I still have a lot of passion for security and SQL Server, so I am reviving this blog. I cannot promise to write articles on a regular basis anymore, but if you are interested in any topic for SQL Server...(read more)

Speaking at Portland SQL Server User Group this Thursday

Bob Beauchemin's Blog — Mon, 05 Dec 2011 09:43:00 GMT

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, but I've volenteered to speak again. This time, it's about parameterization and autoparameterization...(read more)

Four SQLskills Immersion Events coming to Chicago in April 2012

Bob Beauchemin's Blog — Fri, 02 Dec 2011 08:06:00 GMT

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 Spring of 2012 in Chicago. They'll be 4 (count 'em) immersion-level class for...(read more)