SQL Server Engineering Using Free Tools
You can master engineering for your SQL Server databases, on premises or in the cloud, with a FREE toolkit!
2022-10-28
4,859 reads
You can master engineering for your SQL Server databases, on premises or in the cloud, with a FREE toolkit!
2022-10-28
4,859 reads
Spaces are still available for next month's PASS Data Community Summit pre-conference sessions - but they’re booking up fast! Choose from 18 deep-dive full day pre-cons, featuring some of the best minds in the data industry, covering everything from technical processes to personal growth. Register now.
2022-10-28
In this article, we look at various aspects of creating SQL Server stored procedures along with several examples of how to build a stored procedure.
2022-10-28
This wizard migrates SSIS Catalog from one server to another in just a few clicks.
2022-10-27 (first published: 2021-08-17)
16,932 reads
This article includes 10 things that you should consider when migrating to the cloud, with an example using RDS that explains how these are applied to an actual database being created.
2022-10-26
3,721 reads
Are these challenges heading your way?
Join us on Nov 15th at PASS Data Summit to discuss key trends that impact Database DevOps, such as Containerization, and Cloud Build/CI systems. Reserve your place now.
2022-10-26
Learn how and why you should be using Melissa's data quality components that fully integrate into SSIS packages to fix data problems and save your company money.
2022-10-26
As you embark on your own Database DevOps journey you are going to hear many new concepts and phrases, but what do they mean and why are they important to consider? Join Grant Fritchey live as he breaks down the key concepts and terminologies around Database DevOps.
2022-10-24
Learn how and why to use THROW in your SQL Server code to be able to better handle errors that may occur during code execution.
2022-10-24
This article tracks down a problem with Availability Groups due to network bandwidth.
2022-10-21 (first published: 2022-08-09)
5,410 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
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 two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers