SSIS – Adding Connections
Sometimes you get reminded that you don’t know everything about SQL Server and it’s various products Every time I run...
2017-04-27
559 reads
Sometimes you get reminded that you don’t know everything about SQL Server and it’s various products Every time I run...
2017-04-27
559 reads
I like scripts. Scripts that help me do things.
Working in the financial industry, there are always things that you have...
2017-05-04 (first published: 2017-04-25)
1,451 reads
This summer I’m going to try something a little different. I’ll be speaking at a technology conference that is not...
2017-04-18
359 reads
T-SQL Tuesday is a monthly blog gathering for the SQL Server/Data Professional community It is the brainchild of Adam Machanic (B|T)...
2017-04-11
322 reads
Sometimes things just don’t make sense.
One of our production servers has 4×8 (4 sockets, 8 core) processors with hyper threading enabled. This...
2017-03-17
772 reads
Whoa. I’m way behind in my blogging.
For the month of May, my MVP choice is Bob Pusateri (B|T).
Bob is a...
2016-10-06
438 reads
This weekend I’ll be traveling to Kansas City, Missouri for their annual SQL Saturday. This particular event is like going home...
2016-09-22
449 reads
Recently I have had to restore a number of databases into our training environment. Looking up each backup individually would...
2016-09-27 (first published: 2016-09-19)
1,314 reads
The April MVP nomination is Chris Yates (B|T).
Chris is one of those individuals that always have a positive outlook on...
2016-04-28
872 reads
As many of you know, I stay very active within the PASS community. In late 2007 I got my start,...
2016-04-14
486 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