SQL in the City 2017
Redgate is once again hosting a live, virtual event for SQL in the City. We’re going to give you a...
2017-12-08
315 reads
Redgate is once again hosting a live, virtual event for SQL in the City. We’re going to give you a...
2017-12-08
315 reads
I know that when some people see AdventureWorks, their vision turns all red around the edges, their blood pressure spikes...
2017-12-04
361 reads
I know. You love Profiler. I hear you. You’re wrong, but that’s OK. Kidding… mostly.
Unfortunately though, I think a lot...
2017-11-29 (first published: 2017-11-20)
1,384 reads
Chances are extremely high that I’ll never put down Data Scientist as my job. Considering what you do and what...
2017-11-22
390 reads
I have a real infatuation with Azure. I’m especially interested in the Platform as a Service (PaaS) offerings in and...
2017-11-15
294 reads
March 23rd, 2018, I’ll be teaching an all day class on Query Tuning Tools in Richmond Virginia. I hope to...
2017-11-14
356 reads
Ever heard of the General Data Protection Regulation? If not, go and read the Wiki. I’ll wait.
I can already hear...
2017-11-13
300 reads
There’s a war on in the SQL Server world. On the one side is Profiler (although, really, everyone uses Trace...
2017-11-07
420 reads
As you read this, I’m in Seattle for the PASS Summit 2017. I have four roles that I satisfy at...
2017-10-30
562 reads
I find it extremely easy to sometimes lose sight of the important stuff. The day-to-day grind can seriously get in the way. I think this is a big part of how we find ourselves having so many silly intra-organizational turf wars. The developers don’t like how the DBAs do things. The DBAs are frustrated with […]
2017-10-30
64 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