Category: Tech and Learning

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

Post author By Jen McCown
Post date September 19, 2013
Categories In sql server, sqlserverpedia-syndication, SSC, Tech and Learning, Tips, TSQL
1 Comment on 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: DBCC SQLPERF(LOGSPACE); Go ahead, type it […]

Hit Fast Forward: Converting and deploying DTS packages

Post author By Jen McCown
Post date September 18, 2013
Categories In Admin, sqlserverpedia-syndication, SSC, SSIS, Tech and Learning

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 I was really happy not […]

“Unraveling Tangled Code” recording and downloads!

Post author By Jen McCown
Post date August 30, 2013
Categories In Dev, Intermediate, sqlserverpedia-syndication, SSC, Tech and Learning

Last weekend I gave my “Unraveling Tangled Code” talk at SQL Saturday Oklahoma, and they were kind enough to record and post the session over on UserGroup.TV! You can get the slide deck and demo code here. This session stemmed from the recurring nightmare that is undocumented, unsupported code that we SQL folk are supposed to magically […]