Tale of detaching a database which was enabled for replication!
In development environments I prefer to use ‘detach’ database option to move around databases. It’s simple, fast and easy.
Almost all...
2012-10-04
1,292 reads
In development environments I prefer to use ‘detach’ database option to move around databases. It’s simple, fast and easy.
Almost all...
2012-10-04
1,292 reads
Idera will be re-broadcasting that I recorded earlier in the year on meeting audits with SQL Server. It's scheduled for...
2012-10-04
1,059 reads
It's time once again to vote for the 3 candidates we feel will best represent the SQL Server community with...
2012-10-03
1,199 reads
I have made a few changes to the blog over the past couple weeks The changes have come about as...
2012-10-03
648 reads
The Scenario:
You just restored a production database on a development server. You’ve told the developers that it’s restored, and you...
2012-10-03
2,717 reads
What would you say if I offered you the best indexing book on the market for SQL Server 2012?
Wow, right?...
2012-10-03
709 reads
One thing to add for the 5-week countdown… are you an alumni to the PASS Summit? If so, why don’t...
2012-10-03
512 reads
Hi there ho there everybody! It’s less than five (FIVE!) three (THREE!)one (ONE!!) week until the 2012 PASS Summit in Seattle,...
2012-10-03
1,222 reads
Q) Why is it named ReFS?
ReFS stands for Resilient File System. Although it is designed to be better in many...
2012-10-03
612 reads
This past weekend I attended SQL Saturday #149 in Minneapolis with my husband Adam, my brother Chris and another member...
2012-10-03
821 reads
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Comments posted to this topic are about the item Pro SQL Server Internals
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Comments posted to this topic are about the item 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