5:20 PM on Saturday night, looking for the correct size air filter at the local superstore. My phone dings and chirps, as I receive almost simultaneous email and twitter alerts; our production application can’t talk to it’s database. As a SaaS company, it rolls downhill. An unexpected outage with our application means an unexpected service outage for our customers. Time to head home and start troubleshooting. 5:45 PM. After logging into the service provider dashboard, I find that the database services tab is completely non-functional.

One of my bucket list items has always been “publish a book”. Little did I know that I would get to cross that off my list in 2012. I’m excited to announce that I have co-authored a book, Pro SQL Server 2012 Practices, and it will be available on October 31, 2012! "Pro SQL Server Practices 2012 Edition is an anthology of high-end wisdom from a group of accomplished database administrators who are quietly but relentlessly pushing the performance and feature envelope of Microsoft SQL Server 2012.

Tech on Tap v1.3 PowerShell was held on October 13. This was our third and final event for the year, and it was every bit as great as the first two. PowerShell The focus of this event was PowerShell. What is it? How can I use it? What do I need to know to get started? We got an overview of Powershell from Brian Lewis of Microsoft. Then Steve Murawski, PowerShell MVP, gave us practical everyday examples and scripts.

In my previous post I did a few performance tests with piglet. And with all performance related things, I was doing it wrong. I was mainly doing it wrong because I don’t really know how Piglet works. But the person who knows Piglet best came to the rescue. You shouldn’t really construct the parser anew for each parse. The parser is reusable, so build the parser from the grammar only once and you can then call Parse repeatedly.

Yesterday I showed you how we made the first two tests pass. And I also told you that Per Dervall helped to solve the rest. I asked the question on StackOverflow. And I also pinged him about this on twitter. And the poor man made an effort to respond in VB.Net. And in short, this is the result. ```vbnet Public Class ParseLatinPlantName Public Function Parse(ByVal name As String) As Plant Dim config = ParserFactory.

It’s almost here! It’s almost here! The world’s largest SQL Server conference kicks off in a few days. I’ll be in Seattle with thousands of other database professionals, soaking up knowledge, meeting new people, and spending time with my #sqlfamily. I realized this morning that I’ll have to start packing in a few days. Yes, I try to do this a few days in advance, instead of the night before, just in case I forget something.

Introduction Yesterday RandomPunter mentioned Piglet on Twitter. According to the site Piglet is: Piglet, the little friendly parser and lexer tool Piglet is a library for lexing and parsing text, in the spirit of those big parser and lexer genererators such as bison, antlr and flex. While not as feature packed as those, it is also a whole lot leaner and much easier to understand. Today I had some time and set out to see what this is all about.

It’s bookworm time again! Since I’m back in the throes of half marathon training, there’s been less time for me to grab a cup of coffee and read a book each morning, but I’m making time for it when I can. My latest geek read was SQL Server Hardware by Glenn Berry (blog | twitter). []1 This book is designed to help anyone who needs to build or troubleshoot a SQL Server system understand different processors and storage available, how to benchmark the hardware, and the differences in versions and editions of SQL Server.

Introduction In my previous post I examined what the Using code does. And why the 2005 version of the MSDN article might have been wrong. But why is it important to know that Using is not using a catch? The catch Here is the code that we saw in the article. Dim s2 = New FileStream("test2", FileMode.Create) Try Console.WriteLine("before exception") Throw New Exception() Console.WriteLine("after exception") Catch ex As Exception Finally s2.

Introduction Yesterday there was a question on the VBIB forum on what the Using statement does and I answered it. But before going on I checked if I was right by looking at this MSDN article about Using. And it states. ' THE FOLLOWING TRY CONSTRUCTION IS EQUIVALENT TO THE USING BLOCK Dim resource As New resourceType Try ' Insert code to work with resource. Catch ex As Exception ' Insert code to process exception.