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
Dynamically generate the command line DMA statement for each database
If you are upgrading your instance to 2016 (or 2017 soon) then you probably are going to want to run...
2017-06-21
665 reads
Back at SQL Saturday Louisville and Indy
Two years running, I will be presenting at SQL Saturday Indy and SQL Saturday Louisville this year again! Come see my SQL Server 2017 (Linux and Beyond) and Stretch...
2017-06-21
30 reads
Using OPENROWSET in SQL Server on Linux
I wanted to import the million song dataset in SQL Server on Linux. There’s a github repo that has the...
2017-06-30 (first published: 2017-06-21)
2,956 reads
Persisting data in docker containers – Part One
Normally when I work with SQL instances within containers I treat them as throw-away objects. Any modifications that I make...
2017-06-29 (first published: 2017-06-21)
1,836 reads
Registrant Job Title Data from SQLSaturday Baton Rouge events 2014-2016
In a blog post on the Sparkhound website, I laid out the strong case for a sponsor's Return on Investment...
2017-06-29 (first published: 2017-06-21)
915 reads
dbatools at #SQLSatDublin
This weekend SQL Saturday Dublin occurred. For those that don’t know SQL Saturdays are free conferences with local and international speakers...
2017-06-21
945 reads
How to use Python in SQL Server 2017 to obtain advanced data analytics
On the 19th of April 2017, Microsoft held an online conference called Microsoft Data Amp to showcase how Microsoft’s latest...
2017-06-20
793 reads
SQLpassion Online Trainings in July 2017
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-06-20
186 reads
5 Business Problems You Can Solve With Temporal Tables
Watch this week's video on YouTube
It's 4:30 pm on Friday and Mr. Manager comes along to tell you that he needs you to run some important ad-hoc analysis for...
2017-06-20
37 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