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 2010… And so on. Find ALL […]
Category: sqlserverpedia-syndication
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
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 […]