Latest Blog Posts

• 0 Comments 86 Views

  Configure your Red Gate SQL Backup log folder I stumbled across an interesting problem today. One of our production clusters was starting to run out of space on the C:\. I went in and expected to find the usual suspects: $kbuninstall$ folders in C:\Windows\, crap in C:\Temp\, people downloading huge... 5 hours, 42 minutes ago by AaronBertrand to Aaron Bertrand Filed under: disk space, Red Gate, SQL Backup

• 9 Comments 207 Views

  SQL Teaser: Missing FROM Take a look at this code, will the select return anything or not? Look at the subquery and notice that there is no FROM there. USE tempdb GO CREATE TABLE TestQuery ( TestID int ) GO SELECT * FROM information_schema.columns WHERE column_name =( SELECT... 8 hours, 30 minutes ago by Denis Gobo to Denis Gobo Filed under: Teaser

• 1 Comments 156 Views

  The first pillar – A Coherent Design One of the definitions on wiktionary.org for coherence is “a logical arrangements of parts ”. In my initial post, I defined “coherent” for database designs in the following manner: cohesive, comprehendible, standards based, names/datatypes all make sense,... 01-08-2009, 21:05 by drsql to Louis Davidson

• 0 Comments 173 Views

  Welcome to 2009 and 4 Years of Blogging It's hard for me to believe it, but I've been blogging about SQL Server for over four years now. For those of you who've been reading my blog all of these years, thank you. And if you've commented or added a few thoughts over the years, I thank you even... 01-08-2009, 7:35 by KKline to Kevin Kline Filed under: People

• 2 Comments 169 Views

  Book Reviews… When I wrote the 2005 book, I promised that I would take the time to respond to reviews as much as possible. From the good ones if I didn’t really believe that the person read the book (there were a few I have seen, but not too many people tend to write... 01-08-2009, 0:59 by drsql to Louis Davidson

• 4 Comments 252 Views

  [New England] New England Data Camp v1.0 - January 24 If you live in the greater Boston area you might be interested in knowing that the New England SQL Server Users Group and Southern New England SQL Server Users Group have been quietly working for the past several weeks to create a SQL Server oriented... 01-07-2009, 11:32 by Adam Machanic to Adam Machanic Filed under: code camp, New England

• 22 Comments 519 Views

  Will we need many DBAs or no DBAs at all in the future? This is a very exciting/confusing/glooming period for SQLServer Developers/DBAs On one hand there is the ‘cloud’ which will take our precious boxes away from us and we won’t be needed to manage it anymore. On the other hand is an avalanche of technologies... 01-07-2009, 10:53 by Denis Gobo to Denis Gobo Filed under: Challenges

• 0 Comments 387 Views

  Check out another Erland Sommarskog's utility: ABAPERLS Now public on Erland Sommarskog's website. Enjoy! Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!... 01-05-2009, 14:06 by Alexander Kuznetsov to Alexander Kuznetsov

• 0 Comments 389 Views

  2009 SQL Resolutions Every year I put out resolutions, but this year is a little different.  I will post my SQL only blog resolutions here, and my personal ones here . Every year I find my ability to put out stuff is limited by my desire for sleep and fun, and this year... 01-04-2009, 21:55 by drsql to Louis Davidson

• 7 Comments 406 Views

  5 Reasons why I think MDX is the Devil First, an up front apology to Mosha - this is half in jest, half real. MDX is a powerful and useful language, but I find that its very existence has made my life very difficult when it comes to developing a solid Analysis Services solution. That's not... 01-04-2009, 12:24 by James Luetkehoelter to James Luetkehoelter Filed under: MDX

• 1 Comments 932 Views

  Reproducing deadlocks involving only one table Although the best known deadlock scenario involves two connections modifying two tables in different order, there are also other deadlock scenarios involving only one table. Besides, in some scenarios each connection needs to issue only one statement,... 01-01-2009, 18:12 by Alexander Kuznetsov to Alexander Kuznetsov

• 6 Comments 512 Views

  Deep dive to MDX presentation - slides During SQL PASS 2008 summit , I gave full day preconference seminar “ Deep Dive to MDX ”. The evaluation forms now have arrived, and the scores for the content, relevance and depth portion of the seminar are very good. The scores are not as high, however,... 12-31-2008, 14:54 by mosha to Microsoft OLAP by Mosha Pasumansky

• 5 Comments 765 Views

  A year in review, The 31 best blog posts on SQLBlog for 2008 Wow, it has been already a year since I wrote A year in review, The 21 + 1 best blog posts on SQLBlog last year Here we are with another fascinating collection of links, some of them are chosen for their content and some of them for the great comments.... 12-31-2008, 10:36 by Denis Gobo to Denis Gobo Filed under: list, SQL Server 2008

• 6 Comments 1008 Views

  A Gift of Script for 2009: Who is Active, Redux Last year on December 31 I posted part of a larger monitoring script that I had been working on for a few months . I received lots of great feedback on the little script in both the comments and from people I was working with, and over the course of the... 12-31-2008, 9:49 by Adam Machanic to Adam Machanic Filed under: activity, blocking, DMVs, monitoring, Performance, Scripts, who is active

• 5 Comments 992 Views

  Did You Know? You, too, can be a Geek! Danny Gould has a new (beta) version of his Internals Viewer, that you can download from Codeplex at http://www.codeplex.com/InternalsViewer I've just started playing around with it, and the coolest thing is that it integrates right with your Management... 12-30-2008, 22:33 by Kalen Delaney to Kalen Delaney Filed under: internals

• 3 Comments 771 Views

  Performance impact: file fragmentation and SAN - Part VI A script to fragment a test file Well, this post won't cover any actual test results and is not specific to SAN. But in the spirit of full disclosure, I've attached the script I used to control the fragmentation level of the test files mentioned in this... 12-30-2008, 16:19 by Linchi Shea to Linchi Shea Filed under: Disk I/O, Perl, Scripts, Storage, Tools

• 14 Comments 606 Views

  Restoring master database Disclaimer: I'm not an infrastructure DBA.Probably everything below is just bullshit. Recently our talented IT guys destroyed disk on a virtual machine. They chose the disk carefully - it was the one with master database. How do you restore master db... 12-30-2008, 12:03 by Michael Zilberstein to Michael Zilberstein Filed under: Internals, Misc

• 1 Comments 315 Views

  A response to Linchi Shea's excellent posts on fragmentation In case this is your first visit to SQLBlog.com, Linchi Shea does very methodical analysis of the performance and behaviour of disk arrays. His most recent listings specifically explore file fragmentation and its affects on performance on storage. The... 12-29-2008, 18:08 by James Luetkehoelter to James Luetkehoelter

• 4 Comments 468 Views

  Performance impact: file fragmentation and SAN – Part V SQL Server workloads So far, the discussions in all the previous posts ( 1 , 2 , 3 , and 4 ) on the performance impact of file fragmentation on a drive presented from a high-end enterprise-class disk array are related to disk I/O workloads. Ultimately,... 12-29-2008, 16:36 by Linchi Shea to Linchi Shea Filed under: Disk I/O, Performance, SAN, Storage

• 3 Comments 460 Views

  Season's Greetings! I was catching up on my blog reading and came across a very nice post on Ward Pond's blog ; he gives us some TSQL code that produces a holiday message. It's a few days late, but it's the thought that counts, right? I did have a few problems with the code... 12-29-2008, 13:50 by Kalen Delaney to Kalen Delaney