SQL Server 2012 Reporting Services Blueprints – Review
Recently Packt Publishing released the book SQL Server 2012 Reporting Services Blueprints authored by Marlon Ribunal (blog|twitter) and Mickey Stuewe...
2013-12-12
775 reads
Blog Posts
Throwback Thursday #3: SQL Server & Disks
I hope everyone is having a good time gearing up for the holidays. Throwback Thursday is a bi-weekly blog series where...
2013-12-12
696 reads
What a DBA wants for Christmas
In the first few years of ITBookworm.com, we made sure to make up holiday lists of the most awesome gadgets...
2013-12-12
666 reads
A Full Backup Includes Everything (with a caveat)
Full database backups in SQL Server include all of the data, objects, tables, rows, functions, stored procedures, etc. If something...
2013-12-11
827 reads
Accidently Kicking a Database into the Restoring State
I learn new things all the time. This was one that actually stunned me. Huge props to Gail Shaw for...
2013-12-11 (first published: 2013-12-02)
2,373 reads
Database Snapshot failed due to disk space issue
Database snapshot is really a useful feature. As we know, Snapshot database file will keep increasing parallel to the DML...
2013-12-11
1,091 reads
DC SQLSat
This past weekend I had the opportunity to go visit Washington DC. It was the first time I got to stay in the Nation’s capitol for more than just...
2013-12-11
6 reads
DC SQLSat
This past weekend I had the opportunity to go visit Washington DC. It was the first time I got to...
2013-12-11
829 reads
First Week As The DBA Whitepaper Published
For those that attended the webcast I did last week for Idera the companion whitepaper is now available for download....
2013-12-11
831 reads
Learn To Code
Today I ran through the first tutorial at Code.org. It has 20 very short lessons that use Angry Birds and...
2013-12-11
629 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