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 ...
Next week at the PASS Summit, I'm presenting a session called "Yes, I'm Actually Using The Cloud." I'll be talking about what's out there, why I use it, and why you might want to use it too. Brendan Cournoyer of SearchSQLServer.com interviewed me recently about the topic and asked questions like: For those who are ...
Oracle is buying Sun, the owner of Java, MySQL and Solaris. Oracle is now the enterprise equivalent of Apple: a single vendor with a start-to-finish closed loop from the hardware to the OS to the applications. Another way to look at it: they now own a top-to-bottom development stack like Microsoft's: OS (Solaris, and no, I don't ...
SQL Server Links Find Missing Indexes in Stored Procedures - Michelle Ufford, aka SQLFool on Twitter, shows how to set up a T-SQL script that will regularly monitor your server for any query plans in the cache that are missing indexes, and store that data in a table for later retrieval. See, the dynamic ...
I recently wrote a column touting the merits of Twitter for database administrators. The very next day, their site starting having database problems. You can't make this stuff up. From Twitter's official blog: Q: Is it true that you only have a single master MySQL server running replication to two slaves, and ...
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 »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 »