T-SQL Tuesday#49 - Wait for it...Waits & Queues
As
I was waiting for the next TSQL
Tuesday topic to be announced, we all know that when SQL Server performance is
slow,...
2013-12-10
1,603 reads
Blog Posts
#TribalAwards with RedGate!
You know what? You’re doing a good job. You’re reading blogs, and that’s generally the sign of a person wanting...
2013-12-09
572 reads
Back to iOS from Android
I pre-ordered a Samsung Galaxy S4 last spring, after listening to my wife talk about how much happier she was...
2013-12-09
590 reads
Backups and Giveaways! Day 1
We have 16 days until Christmas. Since I started this blog, I've posted every day Monday through Friday. I am...
2013-12-09
371 reads
Don’t Get Slimed By Bad Parameter Sniffing
Listen! Do you smell something? Are you suffering from random, unexplained slowdowns? Users complaining about queries that sometimes run fast,...
2013-12-09
1,245 reads
Finding active DTS packages
DTS is dead, long live SSIS. Way back when SQL 2005 was announced then released DTS was pronounced DOA. SSIS...
2013-12-09 (first published: 2013-11-27)
3,182 reads
Interviews with Brent Ozar, Adam Machanic and Denny Cherry for SQL Server Radio
While in SQLRally Amsterdam, I had the honor to interview Brent Ozar (blog | twitter), Adam Machanic (blog | twitter) and Denny Cherry (blog | twitter)...
2013-12-09
543 reads
Last Weeks Top “Reading” Links #61
Monday morning and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...
2013-12-09
1,059 reads
Never an Infinite Loop Around When You Need One
You may be thinking, “You’re a DBA. I thought DBAs hated infinite loops.” Well, you’re right, most of the time....
2013-12-09
1,363 reads
SQL Saturday DC Lessons Learned – Humility, Paying it Forward, and Dedication
This past weekend I attended SQL Saturday #233 in Washington DC. I presented a session this year titled “Backup and...
2013-12-09
561 reads
Blogs
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers