Virtualization for SQL Server DBAs – New SQL Saturday Pre-Con Session
Today I am officially announcing the launch of my first all-day SQL Saturday Pre-Conference training session entitled “Virtualization for SQL...
2013-10-30
1,224 reads
Blog Posts
Winner – Conference Pass to SQL Server Live! in Orlando
This is a quick post to announce the winner of our competition for a FREE conference pass to SQL Server Live! in Orlando. Those rather nice folks at SQL Server Live are also offering SQL Brit...
2013-10-30
22 reads
Winner – Conference Pass to SQL Server Live! in Orlando
This is a quick post to announce the winner of our competition for a FREE conference pass to SQL Server Live! in Orlando.
Those rather nice...
2013-10-30
1,378 reads
A look at comments
Everyone knows that we should include comments in our code right? On the other hand the vast majority of us...
2013-10-29 (first published: 2013-10-21)
1,771 reads
Interview FAQ on Interface in C#
What is Interface?
An interface is collection of methods, properties, indexers and events with only signatures. Means In interface Methods, properties,...
2013-10-29
1,594 reads
My First Book: SQL Server 2012 Reporting Services Blueprints
Packt Publishing has published SQL Server 2012 Reporting Services Blueprints – the book that Mickey Stuewe (b | t) and I have...
2013-10-29
1,310 reads
PASS Summit 2013
Not much news came out of the PASS Summit 2013 from last week, but boy did I have a blast! I...
2013-10-29
1,135 reads
Query Tuning in Dallas
Let’s have some fun.
This Friday, November 1, 2013, I’m putting on an all day seminar on query tuning. It’s set...
2013-10-29
681 reads
sp_BackupDatabases v1.2
I just posted a new version of sp_BackupDatabases. The biggest change is that the procedure now creates one-time SQL Agent...
2013-10-29
1,629 reads
SQL Server Training Events–November and December 2013
I’m in New York City this week delivering a SQL Server Virtualization and Consolidation 3 days course for Learning Tree....
2013-10-29
723 reads
Blogs
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Life hack that has worked well for me
I wrote about this several years ago but will contribute again a life hack...
Trying to make this faster using not exists
Hi I have this query that is slow during the 'not in' part of...
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers