Speaking at SQLSaturday Sacramento – 650!
Speaking at SQLSaturday Sacramento!
I’m proud to announce that I will be speaking at SQL Saturday Sacramento on July 15th 2017! And wow,...
2017-06-23
409 reads
Blog Posts
T-SQL Tuesday #091 – Round-Up
Thank you to everyone who participated in T-SQL Tuesday #091 which was on databases and DevOps. As I anticipated, this...
2017-06-23 (first published: 2017-06-15)
1,726 reads
1 year of blogging
It’s hard to believe but a full year has now passed as of today. It’s my blogoversery! Can that be...
2017-06-22
437 reads
Blog Series: Azure Cloud “Fear” Busting
I have decided to do a 4-part series on Cloud “Fear Busting” scenarios. Why? Over the past few years working...
2017-06-22
410 reads
Changing default location for docker containers
A question that regularly comes up when I talk about containers is, “can you specify where the containers/images live on...
2017-06-22 (first published: 2017-06-14)
1,388 reads
Have you backed up your SQL Logins today?
Why am I asking?
Have you never have been in a situation where:
the master backup is corruptedyou need to rollback a password...
2017-06-22
433 reads
Move a Stored Procedure to a New Schema–SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-06-22
525 reads
Orchestrating SQL Server with Kubernetes
T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the...
2017-06-22 (first published: 2017-06-13)
6,458 reads
VSCode – PowerShell extension 1.4.0 new command Out-CurrentFile
Yesterday David Wilson announced version 1.4.0 of the PowerShell extension for VSCode
Just released #PowerShell for VS @Code 1.4.0 with new...
2017-06-22
920 reads
9003 is a Scary Number
My last post talked about 9002 errors and how they *might* be corruption.
Recently I moved up to the next consecutive...
2017-06-21
2,036 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...
Life hack that has worked well for me
I wrote about this several years ago but will contribute again a life hack...
Trying to make this faster using not exists
Hi I have this query that is slow during the 'not in' part of...
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