Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: September 2013

MidnightSQL Server Evaluation script, version 1.0

Server evaluations are a major part of my consulting business. I need to get up to speed very quickly on a server when I first start a project, and uncover the big potential issues. So, I started developing a set of scripts to help me gather and summarize that information…

Read more

3 comments, 339 reads

Posted in SQL Awesomesauce on 30 September 2013

Interviews with Great SQL People – Authors, MVPs, many more

I’m trying really hard to write a blog that goes over all the great #sqlpass interviews we’ve done, but work keeps happening. Pfft. If you didn’t know, we interview great folk at #sqlpass: @ItzikBenGan, @SQLRunr, @brianknight, @billramo, @GFritchey & more in 2009… Interviewed @mrdenny, @sirsql, @gfritchey, @way0utwest, @mark_AzureCAT at #sqlpass…

Read more

0 comments, 301 reads

Posted in SQL Awesomesauce on 27 September 2013

SQL Tip: Get Log Space with DBCC SQLPERF(LOGSPACE)

Every so often I’m reminded that the “basics” aren’t really basics. None of us go to take “How to be a Microsoft SQL Server DBA 101″ before our first gig. So for your perusal, use and enjoyment: here is the easiest way to get a report on log space usage:…

Read more

1 comments, 367 reads

Posted in SQL Awesomesauce on 19 September 2013

Hit Fast Forward: Converting and deploying DTS packages

This one is just a quick shout-out to Pragmatic Works, and to Sean. Pragmatic Works made DTS xChange, which I used to convert about 40 SQL Server 2000 DTS packages to SSIS. Seriously, I just had to run the thing, and update a few data connections.  YMMV, of course, but…

Read more

0 comments, 238 reads

Posted in SQL Awesomesauce on 19 September 2013

#TribalSQL: A new book by new voices in SQL Server

Two years ago, we were talking about how cool it would be to get a bunch of unpublished authors to write about what they thought was important about databases. You know, tribal knowledge. So we sent out a call for abstracts and got the ball rolling on one of the…

Read more

2 comments, 262 reads

Posted in SQL Awesomesauce on 17 September 2013

PASS Summit 2013 Schedule

Each year, I like to compile my own shortcut, cheat sheet version of the PASS Summit schedule. I’m not talking about the actual session schedule – we (will) have a perfectly good schedule builder on sqlpass.org, so that’s covered. I’m talking about social events, luncheons, keynotes, parties, special days…pretty much…

Read more

1 comments, 410 reads

Posted in SQL Awesomesauce on 10 September 2013

A Short Treatise on Studying (#mcmstudy)

So I’m studying a lot these days, and I find myself evaluating and reconsidering the theories of “study” that I’ve been picking up all the way back since grade school. Here is what seems to work best for me, whether I’m learning something new, or reviewing something I “know”: Develop/revise…

Read more

0 comments, 262 reads

Posted in SQL Awesomesauce on 9 September 2013

A Better Braindump (#mcm #mcmstudy)

I’m studying my butt off for the soon-to-be-deprecated Microsoft Certified Master cert’s lab – and the three unfinished prerequisite certs I’ve been putting off since 2008* – and I’m not using braindumps. I just wanted to brain dump HERE a bit. (And btw, you can follow my mid-study ramblings on…

Read more

0 comments, 323 reads

Posted in SQL Awesomesauce on 5 September 2013