Amazon Partners With Cloud vLab To Teach Developers How To Use AWS
Reblogged from TechCrunch: Nobody has ever accused Amazon Web Services of hiding its complexities. It seems even Amazon acknowledges that...
2013-07-31
1,388 reads
Blog Posts
At the Top of the Rickety Stairway…
by Steve Bolton
…………As expected, I’ve run into quite a few obstacles while trying to deploy and debug my first plug-in...
2013-07-31
1,088 reads
Generic Dynamic SQL Stored Procedure
Recently I came across a post on http://www.StackOverflow.com that basically asked how to write a generic stored procedure to handle...
2013-07-31 (first published: 2013-07-22)
3,669 reads
I'm Presenting Today for 24 Hours of PASS!!
Hello Dear Reader! This is just a very quick blog to let you know that the 24 Hour's of PASS...
2013-07-31
1,368 reads
PASS SQL Saturday Events : August 2013
PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please...
2013-07-31
1,328 reads
PASS Virtual Chapter Events : August 2013
Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters...
2013-07-31
1,351 reads
Sometimes It IS The Network
Over the years when a performance problem comes up there is always some speculation that it’s a network issue and...
2013-07-31
1,190 reads
SQL Server – How to Download and Install the ‘right’ AdventureWorks Sample Database
One of the first things I did when I began my journey with SQL Server was installing a sample database....
2013-07-31
1,610 reads
24 Hours Of PASS: 2013 Summit Preview Starts In Less Than 24 Hours!
If you like free SQL Server training you're in luck – starting at 12:00 PM GMT/8:00 AM EDT, July 31 (that's...
2013-07-30
1,354 reads
24 Hours of PASS: Summit Preview Edition
The latest 24 Hours of PASS (24HOP) event will start at 12:00 GMT on July 31, with 24 back-to-back one...
2013-07-30
1,321 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