If You Aren’t Measuring It, You Can’t Manage It
It sounds simple and logical doesn’t it. One could say it is common sense right? How many of us are...
2011-08-08
526 reads
Blog Posts
Money, Transparency, and Community Events
I’m going to ramble today. This is a complex topic and I think you’ll see by the end that I...
2011-08-08
911 reads
PowerPivot – Creating KPIs
Probably one of the most anticipated additions to the latest version of PowerPivot is the ability to create KPIs. PowerPivot...
2011-08-08
2,812 reads
Putting a Database into Single User Mode
I was recently discussing with a group of budding DBA’s how you go about performing a restore of database. They...
2011-08-08
1,349 reads
Replication Agent Failure
I recently spent several days investigating a replication failure. Finding the answer specific to my problem was difficult, so I...
2011-08-08
7,974 reads
S3OLV August Meeting II
I recently published a post about the upcoming meeting for S3OLV. This post is to serve as an update to the post. It is quite important that a more...
2011-08-08
7 reads
S3OLV August Meeting II
I recently published a post about the upcoming meeting for S3OLV. This post is to serve as an update to...
2011-08-08
577 reads
Security Is Your Responsibility
My primary responsibility at my organization is no longer to be the security architect and incident response team lead. I...
2011-08-08
958 reads
SQL MCM Training – Day 0
For the next 3 weeks I'm in Bellevue/WA for the SQL MCM training provided by Paul
Randal, Kimberly Tripp, and Bob...
2011-08-08
646 reads
SSRS Export En Masse
Have you ever found yourself in need of exporting all of the reports from a Report Server? I have found myself in need of extracting all RDLs from a...
2011-08-08
38 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