The latest build of SQL Server Management Studio for SQL 2008 R2 includes built-in support for SQL Azure. The November CTP is still only a feature-complete preview, not a release candidate, so don't go installing it willy-nilly on your production desktop. To use this, you'll need a SQL Azure account. You can register for ...
Here's my bookmarked links for October 26th through October 30th: SQL Server Links Windows Azure Platform Launch Update - The blog notes that "a number of new features in Windows Azure will be made available for the first time" - but it's at PDC, not the Professional Association for SQL Server Summit. This should be ...
Here's my bookmarked links for September 25th through October 2nd: SQL Server, Cloud, and Tech Links Viva la Famiglia! - Brad Schulz shows how to use T-SQL to determine family relations. This is freakin' awesome. PASS Board 2009 Slate of Candidates - Candidates are Brian Moran, Jeremiah Peschka, Matt Morollo and Thomas LaRock. PASS Elections ...
Good news and bad news - the good news is that everybody's been going wild and crazy for the SQLServerPedia PASS contest. The bad news is that editing the articles & setting up the bloggers has eaten up every moment of my spare time, hahaha. As a result, I had to do the unthinkable this ...
I'm going to show how to use a new feature in SQL Server 2008 Management Studio: the ability to query groups of servers simultaneously. In Registered Servers, right-click on a group of servers and click New Query. What comes up will look like a normal query window, but pay close attention to the very bottom ...
A few months back, Microsoft gave MVPs a few MSDN Ultimate subscriptions to pass on to community members, no strings attached. I quietly gave mine to a few deserving folks who I thought could be future MVPs, but Arnie Rowland (Blog – @ArnieRowland) had a better idea. Arnie’s Project Phoenix encourages developers to propose a [...]
Read More »A few months ago, I had The Idea. I wanted to conduct SQL Server training on a cruise ship. I emailed a few buddies and offered to start a company called SQLCruise with them, and out of three friends, only one could say yes. I don’t have anything against the two who said no. I [...]
Read More »Most SQL Server DBAs don’t even like MySQL, let alone NoSQL. They cringe when they hear people say things like, “I don’t need transactions” or “The data will eventually be consistent” or “Indexes will be supported in the next version.” SQL Server and Oracle people are constantly trying to out-feature each other, and the abject [...]
Read More »In August 2008, Lady Gaga released her premier album The Fame. This 13-track work produced several hit singles including Just Dance, Poker Face, and Paparazzi – but it also produced plenty of controversy. Her exaggerated use of fashion, musical cliches, and sex gave her plenty of media attention – both good and bad. If you’ve [...]
Read More »Pop quiz: should you be worried if your SQL Server’s page life expectancy is averaging 214? There’s only one correct answer: it depends.
Performance tuning is all about finding the RIGHT bottleneck, focusing on it, and fixing it to the application owner’s satisfaction. Learn what happens if you don’t do it right.
Read More »