Don't Rush When It Comes to Privacy Data
The Dataloss list sent the following article through yesterday afternoon:
Obamacare Employee Accidentally Sends Out 2,400 Social Security Numbers
This is concerning,...
2013-09-17
2,231 reads
The Dataloss list sent the following article through yesterday afternoon:
Obamacare Employee Accidentally Sends Out 2,400 Social Security Numbers
This is concerning,...
2013-09-17
2,231 reads
Problem. Your database mail suddenly stopped sending out email notifications on completed jobs and tasks. You try to send out...
2013-09-17
1,115 reads
By Steve Bolton
…………Throughout this series of amateur self-tutorials in SQL Server Data Mining (SSDM), I’ve often said that working with...
2013-09-16
1,454 reads
This past weekend I presented a preview of my SQL PASS Summit spotlight session entitled “Squeezing Top Performance From Your...
2013-09-16
588 reads
Have you been putting off running integrity checks on your databases? Are you unsire where to start or what to...
2013-09-16
1,214 reads
This weekend is SQL Saturday #249 in San Diego. I’m looking forward to the trip for a few reasons, but...
2013-09-16
836 reads
This post is to list all the software installed on your local or remote machines. The exclusion list is an...
2013-09-16
1,279 reads
SQL Server Evaluation Edition is available free of cost. It’s a trial version & valid for limited time of period. The...
2013-09-16
27,183 reads
Monday morning and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...
2013-09-16
930 reads
First thing, there are no bad operators, just bad parents, uh, I mean query writers, or database designers, or ORM...
2013-09-24 (first published: 2013-09-16)
3,589 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