All about the Change
The use of SQL Audit can be viable to track the changes that may be occurring within your SQL Server - from a settings point of view
Related Posts:
CRM Data...
2016-01-12
16 reads
The use of SQL Audit can be viable to track the changes that may be occurring within your SQL Server - from a settings point of view
Related Posts:
CRM Data...
2016-01-12
16 reads
The second Tuesday of January 2016 is now upon us and you know what that means. Well, I hope you...
2016-01-21 (first published: 2016-01-12)
1,430 reads
Windows PowerShell is all about exploring .NET framework capability through the command line.Announced in 2006 it’s an admins paradise with...
2016-01-20 (first published: 2016-01-12)
2,567 reads
I continue to work on solving the Advent of Code puzzles in both PowerShell and T-SQL after completing them in...
2016-01-12
737 reads
After a very long waiting period, I have finally released the initial version of my Columnstore Maintenance solution for SQL...
2016-01-11
412 reads
While I never really enjoy a cross country flight back home my feet are very happy that I am finally...
2016-01-11
338 reads
[read this post on Mr. Fox SQL blog] Over the years I have presented many times to various clients describing Business Intelligence (BI) solutions using the Microsoft BI solutions stack. In all of...
2016-01-11
27 reads
[read this post on Mr. Fox SQL blog]
Over the years I have presented many times to various clients describing Business Intelligence (BI) solutions...
2016-01-19 (first published: 2016-01-11)
2,781 reads
Greetings of the day!!
I am getting frequent emails with questions why I do not write as often I used to...
2016-01-11
505 reads
One of the many small things you don’t have to worry about any more when working with Azure SQL Database...
2016-01-18 (first published: 2016-01-11)
1,422 reads
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...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
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...
Comments posted to this topic are about the item Data Lost in the Cloud
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