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 an invitation [...]
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 your [...]
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 and UStream | [...]
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 [...]
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 »Erika’s friends call her “Fancy Feast” because she only likes the best things in life. She’s got champagne tastes, but we can’t afford to buy the best of everything. I recently picked up a coffee table from Ikea, and it got me thinking about SQL Azure.
In a perfect world, I’d have on-premise SQL Server for every database. I’d use cutting-edge storage and cluster everything. But this isn’t a perfect world…
Read More »I get a lot of questions from people who want to get a better job. They want to know if certification, training, or branching out will help them get the job of their dreams. These things just aren’t the real answer.
The answer is simple: the Buddy System. Learn why.
Read More »In high school, I threw a huge party in Grandma’s house. It had long-lasting implications – among other things, I got disinherited.
Learn why SQL Server data compression has a lot in common with me after that Jungle Juice bash.
Read More »When my Grandpa Ozar wanted to find out if his 10 megabyte 5.25″ hard drive was responding fast enough to handle his database loads, he monitored the Perfmon counter Physical Disk: Disk Queue Length.
Things have changed since Grandpa’s time, though, and now it’s time to learn a new performance tuning trick – SQL Server waits.
Read More »