A Better Braindump (#mcm #mcmstudy)
I’m studying my butt off for the soon-to-be-deprecated Microsoft Certified Master cert’s lab – and the three unfinished prerequisite certs I’ve...
2013-09-05
717 reads
Presentation Slides for Building an Effective Data Warehouse Architecture
Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” for the PASS DBA Fundamentals Virtual Chapter. The abstract is...
2013-09-04
721 reads
Azure Capabilities Expand
But then, the capabilities in Azure are always expanding. Here’s the new stuff that was just released in a blog...
2013-09-04
640 reads
SQL Server events in the UK September 2013
Sorry things are a little later this month…Summer (like the MCM program) may be coming to an end, but we...
2013-09-04
691 reads
How to become a better, well-rounded SQL Server DBA
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
People are sometimes...
2013-09-04
876 reads
Why Blog?
The main reason I started blogging was a community thing. I leeched from the community to get me to where...
2013-09-04
1,015 reads
Is Microsoft's Certification Program Value Microsoft's Fault?
I'd be interested if anyone says, "No," to that question. Gail Shaw raised a few points in this post about...
2013-09-04
2,009 reads
It's not you; it's us
Mirrored from http://www.sqlservercentral.com/articles/Editorial/101894/
By now I expect this news is no longer new: the MCM, MSA, and renamed versions of those...
2013-09-04
2,102 reads
Replicated Stored Procedure Execution
One feature that many of my clients are unaware of is that the batched execution of a stored procedure can be...
2013-09-04
2,134 reads
An Exit Becomes the Next Entrance
If you live life in the manner that I do, life is all about change and self-improvement. To me, life...
2013-09-03
806 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