You Need a New Hobby
Not sure who this is that is attempting to hack into my blog so desperately, but seriously, time for a...
2018-01-23
293 reads
Not sure who this is that is attempting to hack into my blog so desperately, but seriously, time for a...
2018-01-23
293 reads
I read a lot of history (as you no doubt notice from my other editorials). I’m currently reading an excellent book on the air war in World War One, Marked for Death: The First War in the Air. One of the fascinating aspects of the war is just how fast the technology shifted. At the […]
2018-01-22
27 reads
Query tuning ain’t easy.
Figuring out which index is getting used is one step, and generally simple, look at the execution...
2018-01-17 (first published: 2018-01-08)
2,239 reads
Hello all,
I’ve recently updated my YouTube channel. I’m going to be posting a lot more videos up there. If you...
2018-01-16
320 reads
I recently flew from Boston to the UK through the Heathrow airport. It just happened to be on the day...
2018-01-02
689 reads
Have you ever looked at the properties inside an execution plan and wondered what the units of measure were? I...
2017-12-26 (first published: 2017-12-11)
1,419 reads
In Azure SQL Database for quite some time and now available in SQL Server 2017, Microsoft has put a lot...
2017-12-26
732 reads
The second best thing to questions that people ask is when I sit down to write a book. It’s so...
2017-12-18
523 reads
With all the options available within T-SQL these days, it’s more and more imperative that our code be clear and...
2017-12-11 (first published: 2017-11-28)
2,241 reads
The preferred method for modifying your data within a database is T-SQL. While the last Fundamentals post showed how to...
2017-12-11 (first published: 2017-11-27)
1,781 reads
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Hi everyone My SSIS package does a bulk insert of csv files into a...
Dipping my toes into the waters of Azure and of course before I get...
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers