PCI Compliance Presentation on July 17, 2013
Next week I’ll be doing a new presentation about PCI compliance – aka dealing with credit cards – online (follow this link...
2013-07-09
536 reads
Next week I’ll be doing a new presentation about PCI compliance – aka dealing with credit cards – online (follow this link...
2013-07-09
536 reads
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-07-09
756 reads
I have gone through and made some minor updates and bug fixes for all of my SQL Server Diagnostic Information...
2013-07-09
1,163 reads
Announced at Microsoft’s Worldwide Partner Conference 2013 is Power BI for Office 365:
Power BI for Office 365 is a cloud-based business intelligence...
2013-07-09
1,523 reads
It’s T-SQL Tuesday time again. This is the monthly blog party, started by Adam Machanic. If you’d like to participate,...
2013-07-09
1,084 reads
Hello Dear Reader! Welcome to my blog on T-SQL Tuesday #44 Second Chances. I’m hosting this month, and we are...
2013-07-09
1,708 reads
So, it’s Tuesday and its that time again for T-SQL Tuesday. We’re at the 44th entry which means it’s been...
2013-07-09
1,859 reads
This month’s T-SQL Tuesday is hosted by Bradly Ball (blog | twitter) and the topic is second chances. The idea is...
2013-07-09
665 reads
Power BI: a new suite of Business Intelligence tools Over the past few months, teams at Microsoft have made several...
2013-07-09
731 reads
In the last post, we have discussed about the auto update statistics threshold and concluded that auto updated statistics threshold are good enough to get optimal performance in some workload. In...
2013-07-09
50 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