MCM on Life Support
Good news everybody. October 1st is no longer the day that the MCM was prescribed to die. The Microsoft Certified Master is now on life support until December 31st,...
2013-09-11
10 reads
MCM on Life Support
Good news everybody. October 1st is no longer the day that the MCM was prescribed to die. The Microsoft Certified...
2013-09-11
720 reads
SQL PASS Virtualization VC Presentation Wrapup
Everyone, thank you for attending the SQL PASS Virtualization Virtual Chapter presentation entitled “SQL Server High Availability Options After Virtualization”...
2013-09-11
693 reads
Execution Plan Cost Estimates
It’s been emphasized over and over that the costs of operations within an execution plan, and the estimated costs of...
2013-09-11
1,743 reads
Encryption Decryption Routine
In this post we will look at a complete end to end routine for encrypting, storing, decrypting data in SQL...
2013-09-17 (first published: 2013-09-11)
3,937 reads
Certifications: What are they good for?
Since Microsoft decided to drop the MCM/MCA program there has been an enormous amount of discussion about the program and...
2013-09-11
558 reads
NJ SQL UG presents Hilary Cotter - Next Tues. 9/17
Next Meeting: Tue, Sep 17 2013
Take note, the New Jersey SQL Server User Group, led by John Dempsey, will be...
2013-09-11
893 reads
SQL Saturday Cambridge #228 September 27-28th September
Snazzy title eh, I bet you can’t guess what this post is about. That’s right, it’s all about Monty Python!
A...
2013-09-11
783 reads
Why Government Required Backdoors Are a Bad Idea
I've heard the argument, "I've got nothing to hide. If it helps them catch the next guy, I'm all for...
2013-09-17 (first published: 2013-09-11)
3,993 reads
Database DoS Whitepaper from Securosis
Securosis has released a whitepaper on their research with regards to database denial-of-service attacks. This whitepaper is platform agnostic. It...
2013-09-11
2,043 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