5 MCM Readiness Indexing Videos You Should Watch
Earlier this year, I finally passed the Microsoft Certified Master (MCM) for SQL Server 2008 certification. In the process of...
2013-01-23
1,410 reads
SSRS 101 – Prerequisites
Before I actually start explaining and demonstrating how to build SQL Server Reporting Service (SSRS) reports there are few things...
2013-02-01 (first published: 2013-01-23)
4,284 reads
PASS Business Analytics Conference Presentation
I am fortunate enough to have been selected to give a presentation at the PASS Business Analytics Conference in Chicago...
2013-01-23
1,408 reads
New Year Aspirations – Gavin Payne – MCA
Thanks for agreeing to do this Gavin. It’s great to be able to interview an MCA as there are so...
2013-01-23
957 reads
Saving Execution Plans on Azure SQL Database
In my previous post showing how to get to execution plans in the Database Management Portal, I showed that it’s...
2013-01-23
1,854 reads
IsMSShipped
I just wanted to do a brief highlight of a handy little object property. For those of you who aren’t...
2013-01-23
1,597 reads
Day 18 of 31 Days of Disaster Recovery: How to CHECKDB Like a Boss
Day 18 of my 31 Days of Disaster Recovery series is drawing to a close. It’s 11:22 PM here, and...
2013-01-23
1,198 reads
SQL Server certification path
At the House of BrickSolutions Architect blog, I have a new post up on the path to full SQL Server...
2013-01-23
770 reads
Cumulative Update – 9 for SQL Server 2008 Service Pack 3 Is Now Available !
The 9th cumulative update release for SQL Server 2008 Service Pack 3 is now available. Cumulative Update 9 contains all...
2013-01-23
1,395 reads
SQL Server 2012 for Beginners
I have been working for Microsoft for the past two years. One of the most enjoyable parts of my job...
2013-01-22
995 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...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
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