The one and only – Dr. SQL – Louis Davidson (b|t|t|t) stopped by for a chat! Relational Algebra, Disney, Dollywood and a SQL Dump Truck ??
The post Data Bits...
2020-04-17 (first published: 2020-04-08)
295 reads
SQL Server DBA Jules joins us on the show to talk DBA work, Chickens, Charity work, Mentoring and Shepherding (actual sheep!) See more at Jules’ site Edit: Honorable mentions: Minionware,...
2020-04-02
29 reads
Trainer and Consultant extraordinaire Ginger Grant stops by to talk Machine Learning, Data Bricks, Certifications, Norwegian pastries and proper chocolate frosting Find Ginger at Desert Isle SQL or on Twitter
The post Data BIts...
2020-04-01 (first published: 2020-03-26)
225 reads
My Pluralsight course for new SQL Server DBAs Image credit to Jeff (t) Back in June of 2019, I published this YouTube video covering the highlights of the various...
2020-03-25
80 reads
My Pluralsight course for new SQL Server DBAs SQL Server may skip 1000 numbers on an Identity column if the server crashes. Here’s why: Too long, didn’t watch version:...
2020-02-04
42 reads
By James Serra
(This is the third post in a three-part series on how AI is changing...
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Comments posted to this topic are about the item Pay for Performance, which is...
I wrote about this several years ago but will contribute again a life hack...
Hi I have this query that is slow during the 'not in' part of...
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