Tag Archives: sql server

Does the SQL Server Database Filename Matter?

Posted on January 17, 2013 by way0utwest

Do you know the basics of how to create a database? Hopefully you do and can do so without the GUI. However do you know the extensions are for database files? As of SQL Server 2012, these are the extensions: … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Regression Testing before CUs and Service Packs

Posted on January 15, 2013 by way0utwest

Someone asked me on Twitter recently if I ran full regression tests before applying Cumulative Updates (CUs). I decided it wasn’t worth discussing in 140 character chunks, so I decided to jot a few notes down. I’ll also expand this … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Regression Testing before CUs and Service Packs

sp_Blitz, v16, on SQLServerCentral

Posted on January 10, 2013 by way0utwest

Brent Ozar Unlimited released v16 of this sp_blitz script, which is designed to run on a SQL Server instance and give you a quick, comprehensive report of the state of the instnace. It’s a great script, and if you have … Continue reading →

Posted in Blog | Tagged , , | Comments Off on sp_Blitz, v16, on SQLServerCentral

Is Big Data Good for Data Professionals?

Posted on January 9, 2013 by way0utwest

There’s a lot of hype around “big data”, a term being thrown around so much in the media that I’m not really sure what it means anymore. Is 1TB “big data”? Is 10,000 transactions/sec big data? Or does it mean … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Is Big Data Good for Data Professionals?