24 Hours of PASS videos online
All the videos for the sessions at 24 Hours of PASS (Fall 2012) are available for free. Check the session schedule for...
2012-10-12
743 reads
Blog Posts
Ask the Unicorn: How to become a DBA?
Every now and then I get a question in e-mail and I usually just reply and leave it at that. ...
2012-10-12
686 reads
Dallas, TX to Pittsburgh, PA A #sqlsat171 Story!
First SQL Saturday in Pittsburgh
It was an honor to speak at the first SQL Saturday in Pittsburgh. The company I
We...
2012-10-12
634 reads
How to move the FullText catalog with SQL Server 2005 ?
4 simple steps to move FullText catalog with SQL Server 2005 :-
1. Detach the database which contains the FullText Catalog....
2012-10-12
1,065 reads
I’m Not Attending #sqlpass Summit 2012 and I’m Sorry For Myself
I really wanted to attent PASS Summit this year, I’ve never attended before. I was preparing myself mentally since the...
2012-10-12
688 reads
Introduction to SQL Server 2008
There are still some seats left on the SQL Server 2008 A Comprehensive Hands-On Introduction that I will be presenting...
2012-10-12
570 reads
Lost in Translation – Deprecated System Tables – sysfiles
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-10-12
1,153 reads
Reblog: October 5 to October 11
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-10-12
488 reads
Reminder to Register for the Monday Night Networking Party
We just crossed the 100 mark for registrants for our Monday Night Networking Party and still room for more. If...
2012-10-12 (first published: 2012-10-09)
1,816 reads
SQL Server – Transaction Log File is Full; How to Shrink the Transaction Log
Here is a typical scenario every SQL Server DBA faces: Transaction Log grows unexpectedly or becomes full!! So, do I need to increase...
2012-10-12
478 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