Auditing Needs Reporting
No matter the mechanism used to capture the data to fulfill the "investigation" phase of the audit, if the data is not analyzed and reports generated, then the audit...
2015-10-13
12 reads
No matter the mechanism used to capture the data to fulfill the "investigation" phase of the audit, if the data is not analyzed and reports generated, then the audit...
2015-10-13
12 reads
Welcome to the second Tuesday of the month. And in the database world of SQL Server and the SQL Server...
2015-10-13
696 reads
Thank you to everyone that attended my Power BI webinar last month, September 29th. Sorry its taken me a while...
2015-10-13
292 reads
Thank you to everyone that attended my Power BI webinar last month, September 29th. Sorry its taken me a while...
2015-10-13
564 reads
Have you ever wondered if that black box in your datacenter called the network is performing as well as it...
2015-10-13
933 reads
To All-
I am truly grateful I have been selected for this unique contest: http://www.dcac.co/your-pass-speaker-idol-2015-top-12-are
Good luck to all of my fellow...
2015-10-13
380 reads
For many years I didn’t really think about the implications of how I was retrieving data from my SQL Servers...
2015-10-13
16,141 reads
My enthusiasm for analyzing stock market data using Power BI – even after publishing two posts recently (this and this) – is at...
2015-10-13
588 reads
The event_file target is an asynchronous consumer for Extended Events. This target stores the received payload in a proprietary binary format. Because of this, one needs to use the...
2015-10-13
53 reads
Having covered the metadata for a deployed session from just about every angle (yes there is more on metadata that could...
2015-10-13
972 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