Why do I contribute to the SQL Server Community?
As an active speaker and volunteer in the SQL Server community I am often asked why do I do it? ...
2010-10-12
544 reads
Blog Posts
Forgotten T-SQL Cheat Sheet
You’ve seen the blog, you’ve downloaded the code…you even watched the 24HOP session recording…now own the Forgotten T-SQL Cheat Sheet!
Yessir,...
2010-10-11
1,428 reads
Listing members of a group in SQL Server.
In SQL we are used to the GROUP BY and the type of result it produces. In real life, we...
2010-10-11
1,562 reads
PASS Update #44 (Budget)
I had a question recently about how budgets work at PASS, and I think that’s something worth sharing, so I’m...
2010-10-11
521 reads
Return Values from XP_CMDSHELL
Let’s be clear: I don’t recommend the use of xp_cmdshell as a general tool. It ought to be used when...
2010-10-11
17,399 reads
Running Totals for Each Group
A while ago, I posted a blog on how one could perform running totals using Reporting Services and a user...
2010-10-11
4,394 reads
S–3–X Talk Week: This Totally Won’t be Awkward
We’re conducting S–E–X Talk Week here at the MidnightDBA #Awesomesauce blog, in honor of everyone’s favorite subject. In deference to the...
2010-10-11
537 reads
SSMS Tip – Tab Groups
A few months ago as I came across tab groups in SSMS and once I found them I was very...
2010-10-11
1,097 reads
Updates on SQLSaturday#59.....6 Weeks to go!
I just wanted to update everyone on our event happening in NYC, November 20, 2010. We have just six weeks...
2010-10-11
547 reads
Getting ready for the third “Industrial Revolution”: Database 2010-2015
I searched the internet for “connect and forget”. Wonderbox.net offer is described as a...
2010-10-10
10 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