Tag Archives: sql server

Full-Text Search – Thesaurus

Posted on January 21, 2013 by way0utwest

I would hope that most of us have used a thesaurus at some point in our careers. These allow us to substitute words for one another, providing for richer and more interesting communication. Full-text search in SQL Server includes a … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Full-Text Search – Thesaurus

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