The docker kill command
When running demos and experimenting with containers I always clear down my environment. It’s good practice to leave a clean...
2017-10-06 (first published: 2017-09-28)
1,600 reads
Compañero Conference and SQL Modernization Roadshow
October is a busy month for me. I am flying all over the US and Canada for speaking engagements to...
2017-09-27
562 reads
Getting a New R Package–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-10-06 (first published: 2017-09-27)
1,814 reads
Error – Unable to retrieve child resources in Azure Storage Explorer
Hello friends, Please find the link of this article here – https://social.technet.microsoft.com/wiki/contents/articles/40188.error-unable-to-retrieve-child-resources-in-azure-storage-explorer.aspx
2017-09-27
907 reads
Just Check ALL the Boxes
Today I ran into something on a client server I unfortunately see too often. The DBA goes through the trouble...
2017-10-05 (first published: 2017-09-27)
1,675 reads
SQL Puzzle – Prime Numbers
My goal here is to have something fun (and hopefully educational/thinky) (and yes, I did just make up the word...
2017-09-27
465 reads
Concatenation Truncation – Are your strings being truncated?
It wasn’t until recently that i paid attention to truncation during concatenation, but that’s because whenever I used concatenation before...
2017-09-27
1,249 reads
Auditing Data Access in SQL Server for GDPR Compliance
In relation to the GDPR, I’ve recently been looking at the tools available within SQL Server to support auditing our...
2017-10-05 (first published: 2017-09-26)
5,854 reads
SQL Clone, Redgate Licensing, and Cookies
SQL Clone is amazing, and it can really save time and disk space for many organizations. I’ve got a series...
2017-09-26
659 reads
Clustered vs Nonclustered: Index Fundamentals You Need To Know
Photo by Patrick Tomasso on UnsplashHow many times have you known that adding an index would improve query performance but you weren’t exactly sure which type of...
2017-09-26
2,005 reads
Blogs
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
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