Automate Migrations–T-SQL Tuesday #94
It’s T-SQL Tuesday time again, and I’m slightly pressed for time, which is sad. This is a great topic.
Rob Sewell...
2017-09-12
417 reads
Blog Posts
Creating Hyper-V VMs with Powershell
This month’s T-SQL Tuesday is hosted by Rob Sewell (b|t) and surprise, surprise, it focuses on Powershell so I thought...
2017-09-12
415 reads
Database Fundamentals #10: Modifying Tables
Invariably, either while building a new database, or while maintaining old ones, you will find that the business needs change...
2017-09-12
450 reads
Do I Need to Master PowerShell?
As a SQL Server DBA, do you need to be a master of PowerShell scripts? In this 9 minute episode, I talk about how much you need to know...
2017-09-12
37 reads
Elect The Next PASS Board Members
The PASS board elections are coming up and there is a twitter chat event to ask questions to the candidates...
2017-09-12
516 reads
Power BI Report Server (On-Premises) for All Data Sources is Available!
Power BI Report Server August 2017 Preview is now available. Think of this a “v.Next” of Power BI Report Server...
2017-09-12 (first published: 2017-08-28)
3,821 reads
Remove an Active Lease on a Blob in Azure
I was creating and dropping VMs in Azure, and found myself charged money for disks that I thought I’d deleted....
2017-09-12
509 reads
Setting the Sample Rate for Auto Stats updates
SQL Server functionality can move on pretty quickly sometimes, and it’s not always all about the big features but the...
2017-09-12
2,376 reads
Someone is not following the best practices – dbatools and Pester don’t lie!
This month’s T-SQL Tuesday is brought to us by my good friend Rob Sewell (b | t) and we will "Let’s...
2017-09-12
730 reads
SQL Server: SARGability part 2
In case you missed the first post on this topic, you can read it here: SQL Server: SARGability. This post...
2017-09-12 (first published: 2017-09-07)
1,780 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