SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: July 2012

Bad business practices damage your company, KRG Technology

I just composed and sent this message to eleven members of a single California-based recruitment company. I’ll let the email speak for itself, but you, dear reader, should also know that the positions they reference range from Business Objects to Android programming, with nary a DB job in sight. Read more

6 comments, 1,703 reads

Posted in SQL Awesomesauce on 31 July 2012

A Quick Guide to Expanding Database Files and IFI

This is a topic that’s been well covered, but in the interest of spreading good database practices, here’s a very quick note on instant file initialization (IFI) and database files. (As always, you should read the fine print – meaning Microsoft’s documentation – before you do anything on a production… Read more

3 comments, 1,035 reads

Posted in SQL Awesomesauce on 26 July 2012

Puzzling TVFunctions

I had the opportunity to tune a highly-used function the other day, and was most puzzled by the difference between the old and the new function.  This was on SQL Server 2005, and I was able to repro the issue on-server, but not on my SQL Server 2012 instance.

The… Read more

6 comments, 891 reads

Posted in SQL Awesomesauce on 17 July 2012

MidnightDBA tutorials and webshow now on iTunes!

We’ve been slacking for way too long, but as of this week our video RSS feed is up to date! Now you can subscribe to conveniently get ALL of our videos – tutorials and the DBAS@Midnight webshow (warning: the webshow is explicit for language).

We do have this… Read more

1 comments, 680 reads

Posted in SQL Awesomesauce on 16 July 2012

SQL Cruise! SQL Saturdays! Summit! SQL-SQL-SQL!

We’re drawing to the end of our third season of DBAs@Midnight (our weekly webshow by DBAs, for DBAs), and to the middle of the summer. What on earth shall we do for the next few months? We considered taking a break from all things SQL*, then thought…naaaah. So far we’ve… Read more

0 comments, 731 reads

Posted in SQL Awesomesauce on 13 July 2012

Want a Sean-made Precon? You got it!

Sean’s giving a precon at SQL Satrurday 163 this October! Oh yeah, and so are Tim Mitchell and David Stein. Here’s the word from the fearless leaders:

In addition to our Special Bi Edition of SQLSaturday #163 Dallas
<http://sqlsaturday.com/163/eventhome.aspx> , let
<http://northtexas.sqlpass.org/> NTSSUG help you immerse…

Read more

1 comments, 752 reads

Posted in SQL Awesomesauce on 2 July 2012