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 results. So, you may run into this problem if […]
Bob Beauchemin
SQL Server Blog
XEvents in SQL Server 2012: No more “lazy XML” in event harvesting scripts
Posted on: January 23, 2012 12:49 pm
SQL Server 2012 FileTable and T-SQL on AlwaysOn secondary replicas
Posted on: January 17, 2012 12:01 pm
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 (virtual network name). That is, it returns the availability group "listener share" name. In my case, the […]
SQL Server 2012 FileTables – AlwaysOn support and PathName()
Posted on: January 17, 2012 10:03 am
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 in an AlwaysOn availability group configuration. There were some surprises there. None of the FileTable-specific functions and methods mention AlwaysOn, […]
SQL Server 2012 FileTables in T-SQL part 3: hierarchyid methods
Posted on: January 16, 2012 1:06 pm
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: File1.txt File2.txt SQLFiles SubdirFile1.txt SubdirFile2.txt I have a few more levels of subdirectory here, but […]
SQL Server 2012 FileTables in T-SQL part 2: new rows
Posted on: January 16, 2012 8:00 am
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 see, by doing SELECT path_locator.ToString(), Name FROM dbo.Documents We get hierarchyid strings that look like this: […]
SQL Server 2012 FileTables in T-SQL part 1: functions and methods
Posted on: January 15, 2012 10:17 pm
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 in SQL Server using T-SQL. This turns out to be an interesting exercise, especially […]
At Tech Days in The Netherlands next month
Posted on: January 11, 2012 11:17 pm
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 improvements, filetable/filestream, SQL Azure Federations, and others. It will be nice to catch […]
Expertseminarium in April: Performance for Developers in SQL Server 2012
Posted on: January 8, 2012 11:10 pm
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 tools and other features on Microsoft's latest release of SQL Server. We'll look at T-SQL coding improvements, […]
SQLskills Developer Immersion Events this year
Posted on: January 4, 2012 11:01 am
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 developers, but that doesn't mean I'm doing shallow coverage by any means. One of […]
