@LearningTree: SQL Server High Availability
Learning Tree are offering their 3 day SQL Server High Availability course this April in London. Running between 17th and...
2013-03-28
1,482 reads
Blog Posts
Day 31 of 31 Days of Disaster Recovery: Backup and Restore of the Resource Database
It has been a long journey to the final day my 31 Days of Disaster Recovery series, but we have...
2013-03-28 (first published: 2013-03-25)
2,437 reads
Disk Space Checker
One method my company deploys our software is in a dedicated hosted environment. In this situation, we partner with a...
2013-03-28
1,196 reads
Exploring Excel 2013 for BI Tip #4: Adding a Slicer
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2013-03-28
1,983 reads
SQL Server 2012 Business Intelligence Enhancements
My first article in SQL Server Pro magazine has been published. It is entitled “SQL Server 2012 Business Intelligence Enhancements”...
2013-03-28
1,590 reads
SQLTreeo – Migration of extended properties to local storage
New SQLTreeo version introduced local storage option when your folders are stored to file system as structure of files and...
2013-03-28
1,698 reads
SSPI error and Incorrect timing.
TweetG’day,
Recently, quite out of the blue I started seeing this error when I tried to log into my SQL instance...
2013-03-28
1,686 reads
Execution Plans in Azure SQL Database
Microsoft has stated pretty clearly that they’re putting code on Azure first, ahead of the desktop. Which makes one wonder...
2013-03-27 (first published: 2013-03-25)
3,650 reads
Network Packet Size: to Fiddle With or Not to Fiddle With
A network pipeline isn’t nearly as pleasant to look at as the oil pipeline (or anything) in Alaska, but it’s...
2013-03-27
3,296 reads
PowerShell Usage in DBA Work – Case Study 6/7
SQL Server SMO is a great resource for DBAs, unfortunately, before PowerShell, it is a pretty deep learning curve to...
2013-03-27 (first published: 2013-03-23)
2,730 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