Managing Critical Server Lists with Remote Desktop Connection Manager
Most Server Administrators, whether Database Administrators or not, are quite familiar with the Remote Desktop Connection (a.k.a. RDP) tool, which...
2013-02-25
2,648 reads
Day 29 of 31 Days of Disaster Recovery: Using Database Snapshots to Restore Replicated Databases in Test
For day 29 of my 31 Days of Disaster Recover series, I want to talk about restoring replicated databases from...
2013-02-25
1,373 reads
PerformancePoint ‘Named Set’ Filter
PerformancePoint provides several options to create filters. One of the options available is ‘Named Set’. Within SSAS cubes we can...
2013-03-01 (first published: 2013-02-25)
2,130 reads
SQL BLOG: Calculating number of week along the days completed in that week for a given input date
Below code will display the week started along with the number of days completed in that week. For deriving this...
2013-02-24
589 reads
PASS Data Arch VC presents: Neil Hambly’s Think You Have The Right Data-Type?
Please join this Thursday Feb 24th 2013 at noon central for Confio SQL Server expert Neil Hambly talking SQL Server...
2013-02-24
743 reads
A Month of PowerShell – Day 24 (JobServer: Jobs)
Welcome to Day 24 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-24
2,201 reads
SQL BLOG: Playing with Date Time
Below code returns remaining days in the month based on the input date. We can have this inside a function...
2013-02-24
460 reads
A Month of PowerShell – Day 23 (JobServer: Alerts)
Welcome to Day 23 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-23
2,131 reads
SQL Server Encryption
Today, I am very happy because my first article (SQL Server Encryption) was published in SQL Server Pro. In this...
2013-02-23
1,101 reads
The pros and cons of virtualizing SQL Server environments
Virtualization is a hot trend in the computing world, offering businesses substantial cost and performance benefits that include server consolidation,...
2013-02-23
1,610 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