T-SQL Tuesday #65 – Overcoming Variable Limitations in SQLCmd Mode

It’s time again for that T-SQL blog party T-SQL Tuesday, and this month’s host is Mike Donnelly (blog|@SQLMD). If you want to join in the blog party, take a look at Mike’s announcement for an explanation of the topic and rules for participating: T-SQL Tuesday #065 – Teach Something New. My contribution this week is about overcoming the variable limitations of SQLCmd mode. Most people know what SQLCmd is, the command line SQL client utility for running T-SQL, or perhaps
read more

T-SQL Tuesday #50: Doing More With Less

It’s time once again for that monthly geek party again we like to call T-SQL Tuesday. T-SQL Tuesday #50 is hosted this month by Hemanth.D (Blog|@SQLChow). You are invited to visit his blog to join the blog party. You are also welcome to write your own participating blog post for the party or just to read more blogs participating in this month’s theme: Automation! For my part in this month’s blogfest, I want to talk about a tricky data transfer
read more

T-SQL Tuesday #49: Wait For It Roundup

A huge round of applause and my thanks to all of the participants and spectators for this month’s edition of T-SQL Tuesday. I hope I didn’t keep you waiting too long for the roundup. <rimshot> Let’s take a look at this month’s participating blog posts: Fellow Certified Master (MCM) Rob Farley (blog|@rob_farley) led off with Waiting, waiting…. Rob talks about what causes SQL Server (and computers in general) to be slow and how to baseline SQL Server waits to detect
read more

T-SQL Tuesday #49: My Go-To Query For Waiting Tasks

I’m not just hosting T-SQL Tuesday, I’m a customer as well. Err, I mean participant. Topic for this month’s T-SQL Tuesday, hosted by yours truly, is … wait for it … Waits and Queues. For my donation to this little blog party, I’m contributing my favorite go-to query for waiting tasks. Do you ever get complaints that SQL Server is “slow”? Yeah, that’s a helpful report, right? when I get those kinds of reports, I like to take a quick
read more

T-SQL Tuesday #49: Topic is … Wait for It …

Have you been waiting to hear about this month’s T-SQL Tuesday topic? Here’s the announcement, right here and right now. The topic for this month’s T-SQL Tuesday is … wait for it … What? Still waiting? Well, suspend your confusion because that’s it. The topic is (queue the fanfare) Waits. As in “Why is my query waiting?”. As in sys-dot-dee-em-underscore-oh-ess-underscore-waiting-underscore-tasks. Err, I mean sys.dm_os_waiting_tasks. Give us your most interesting post involving waits (wait types, queues, DMV queries, etc) next Tuesday,
read more

T-SQL Tuesday #45 – Who’s Auditing My SSIS Packages?

It’s time once again for that monthly geek party again we like to call T-SQL Tuesday. T-SQL Tuesday #45 is hosted this month by Mickey Stuewe (Blog|@SQLMickey). You are invited to visit her blog to join the blog party. You are also welcome to write your own participating blog post for the party or just to read more blogs participating in this month’s theme: Auditing! Rather than talk about SQL Audit or setting up your own auditing, I want to
read more

T-SQL Tuesday #41 – Presenting Comes Full Circle and I Love It!

It’s time for that monthly geek party again we like to call T-SQL Tuesday. T-SQL Tuesday is one of the greatest assemblage of geeks since the Tri-Lambda and Alpha-Mu mixer … this week. T-SQL Tuesday #41, hosted this month by Bob Pusateri (Blog|@SQLBob). You are invited to visit his blog to join the blog party. You are also welcome to write your own participating blog post for the party or just to read more blogs participating in this month’s theme:
read more

Day 30 of 31 Days of Disaster Recovery (T-SQL Tuesday #40): Using Partial Availability and Initialize from Backup to Replicate a Partial Database

It’s been a tough and long road to 31 Days of Disaster Recovery. It’s been very difficult coming up with quality topic ideas for the series as we near the end. For day 30 of the series, I am combining a post on performing piecemeal restores with a post on filegroups for T-SQL Tuesday #40 and a post on replication. In case you’re not familiar with T-SQL Tuesday, let me enlighten you. This blog entry is participating in T-SQL Tuesday
read more

Day 8 of 31 Days of Disaster Recovery (T-SQL Tuesday #38): Resolutions for All DBAs

This post is not only day 7 of my 31 Days of Disaster Recovery series, it is also participating in T-SQL Tuesday #38 hosted this month by Jason Brimhall (blog|@sqlrnnr). The theme for this month’s T-SQL Tuesday is resolutions or resolving or just being resolute. For my part in this monthly blogfest, I am going to list some disaster recovery resolutions that I think every DBA should make. If you missed any of the earlier posts in my DR series,
read more

T-SQL Tuesday #36 – SQL Community

T-SQL Tuesday #36 – SQL Community This blog entry is participating in T-SQL Tuesday #36, hosted this month by Chris Yates(Blog|@YatesSQL). You are invited to visit his blog to join the blog party. You are welcome to write your own participating blog post for the party or just to read more blogs participating in this month’s theme: SQL Community. The SQL PASS Summit 2012 just came to a close so there’s no surprise that we’re talking about SQL community. Whether
read more