Using Backup-DbaDatabase for a Quick Backup
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
2017-10-16
629 reads
Blog Posts
More Notes on Non Profit Status
Following up on my post about forming a non profit here in Orlando, here are some notes that might help...
2017-10-14
453 reads
This Made Me Laugh: SQL v NoSQL
It’s a humorous history lesson on SQL (and product promotion), but it opens like this:
SQL awakens to fight the dark...
2017-10-13 (first published: 2017-09-29)
5,247 reads
What is DBCC CLONEDATABASE ?
DBCC CLONEDATABASE is new feature comes up with SQL Server 2014 Service Pack 2 and above. DBCC CLONEDATABASE is used...
2017-10-13 (first published: 2017-10-09)
2,449 reads
Your Name is Your Brand
Building your brand is not an overnight sensation. It does take a while and possibly a bit of luck here or there along the way. The one thing it...
2017-10-13
11 reads
Your Name is Your Brand
This topic is one that has been stewing for a while and finally this week it decided to boil over.
My...
2017-10-13
483 reads
Extracting Deadlock information using SYSTEM_HEALTH Extended Events
Extended Events is a powerful feature that was introduced into SQL Server 2008 and onwards. It keeps historical system health...
2017-10-12 (first published: 2017-10-07)
13,788 reads
Getting the Random Module in SQL Data Generator
This is a series on SQL Data Generator, covering some interesting scenarios I’ve run into. If you’ve never tried it,...
2017-10-12
596 reads
When Things Go Wrong in Azure
Things go wrong in IT, it is no different with the cloud. When I say cloud I am thinking quite...
2017-10-12
477 reads
Automate Parameterising SSIS Connection Managers
Hello!
Back when SQL Server 2012 was known as Denali, one of the new and exciting features released was that all...
2017-10-11 (first published: 2017-10-06)
2,444 reads
Blogs
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
Question of the Day
Switching Schemas I
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 one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers