XML Support and SQL Server (Part 4)
Checkout the fourth part of my XML support and SQL Server article series here.
In this part, I talked about XML...
2013-02-23
852 reads
Partitioning Relational Data – (Part – 3)
This is the third part of the three part article series on partitioning relational data.
In the first part of this...
2013-02-23
578 reads
Search all running SQL Server instances over LAN
Sometimes you need to know how many and what instances of
SQL Server running in your organization over Network. You can...
2013-02-22
2,382 reads
Speaking – Slide Design
I’m not sure I love this advice on slide design, but some of it makes sense. Much too often I...
2013-02-22
809 reads
Reblog: February 15 to February 21
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-02-22
922 reads
A Month of PowerShell – Day 22 (Restores)
Welcome to Day 22 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-03-04 (first published: 2013-02-22)
3,180 reads
Microsoft Azure is faster than Amazon
I just read a great article on NetworkWorld that demonstrates that Microsoft’s Azure outperforms most tests against Amazon’s AWS. That’s great...
2013-02-22
738 reads
Five Virtual Labs for the SQL Server 2012 DBA
Wouldn’t it be nice if you had a chance to try out the features of SQL Server? Maybe give them...
2013-03-01 (first published: 2013-02-21)
4,286 reads
Presentation Materials “What Are You Waiting For?”
Here are the presentation materials for today’s Pragmatic Works Training on the T’s session What Are You Waiting For – Explanation of...
2013-02-21
567 reads
Get Perfmon data with Powershell
Sometimes you just want to have a look at the system performance, or you feel tired with log on the server, open...
2013-02-21
2,153 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