SQL In The City: London 2012, Recap
Wow!
How’s that for a recap?
The concept for the SQL in the City events is pretty simple. Put on a free...
2012-07-17 (first published: 2012-07-16)
2,088 reads
The Scary DBA
Querying Information from the Plan Cache, Simplified
One of the great things about the Dynamic Management Objects (DMOs) that expose the information in plan cache is that,...
2012-07-02
1,501 reads
The New Phone Book Is Here!
I can’t help it. I get really terribly excited when I publish a book. Maybe it should be old hat....
2012-06-27
1,600 reads
Problems with my new book
First off, I apologize. As if writing a book wasn’t hard enough, now we get new problems because of on-demand...
2012-06-26
834 reads
Does Encryption Affect Seeing Statements in Deadlock Graphs?
Good question. I don’t have a clue. So let’s set up a test. I’ll create this stored procedure:
CREATE PROCEDURE DL2e
...
2012-07-03 (first published: 2012-06-25)
2,256 reads
PASS Summit 2012
I sure hope you’re planning on attending the PASS Summit this year. If you’re not, you might want to reconsider....
2012-06-19
787 reads
PASS Nomination Committee
For some reason, which isn’t completely clear to me, we’re voting for part of the members of the Nomination Committee...
2012-06-13
808 reads
Guest Blog
I was given the opportunity to put together a guest blog post for the MVP blog. I did a little...
2012-06-05
941 reads
How to Drop One Plan from Cache
While presenting this weekend at SQL Saturday #117 in Columbus, OH (great event, if you missed it, you missed it),...
2012-06-07 (first published: 2012-06-04)
3,325 reads
Never, Ever Use Clustered Indexes
This whole concept of the clustered index as a foundational structure within SQL Server is just plain nuts. Sure, I...
2012-05-31
2,363 reads
Blogs
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers