Do you check to see if an SSIS package has been modified?
Andy Leonard (blog | twitter) and I are putting together a presentation on protecting the entire ETL (Extract, Transform, Load) pipeline, specifically...
2013-05-22
2,601 reads
Databases – Infrastructure – Security
Speaking in Columbia and Charlotte Next Week
I'm speaking at two user groups next week.
Tuesday - Midlands PASS - May 14
I'll be giving a presentation on PowerShell to help...
2013-05-10
1,028 reads
I'm Giving a SQL Server Security Webinar on May 9, 2013
On May 9, 2013, at 3 PM EDT I will be presenting on 5 Steps Every DBA Should Take to...
2013-05-07
1,192 reads
2013 Carolina Code Camp Presentations
As promised, here are the presentations and sample code I used at the 2013 Carolina Code Camp. If you attended...
2013-05-06
1,010 reads
Speaking at the 2013 Carolina Code Camp
On Saturday, May 4, the Enterprise Developers Guild in Charlotte will hold their annual Carolina Code Camp. There's a number...
2013-04-23
875 reads
Troubleshooting SQL Server Error 15517
Last week I had the following error message repeating over and over again in the SQL Server log of one of...
2018-03-21 (first published: 2013-04-22)
58,957 reads
T-SQL Tuesday #41: How I Got My Start in Presenting
For this month's T-SQL Tuesday, Bob challenges us to discuss how we came to love presenting. Here's my story.
I developed a...
2013-04-19 (first published: 2013-04-09)
1,950 reads
Don't Alienate Your Customer
This should go without saying, because most of us have been on the receiving end of poor customer support. However,...
2013-04-05
1,027 reads
Free SQL Server Training for the Week of April 1, 2013
Here are some training events you might be interested in for the coming week:
Tuesday, April 2
11:00-12:00 EDT, Introduction to SQL...
2013-03-29
1,594 reads
Security: People Are the Weakest Link
There was an interesting conversation on Twitter today about security awareness and why the training so often fails. From my perspective, here's...
2013-04-05 (first published: 2013-03-28)
3,320 reads
Blogs
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Episode 11 of Simple Talks: Oracle
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
A New Word: Mornden
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Forums
What is the best index strategy for a table that gets truncated?
Hi everyone My SSIS package does a bulk insert of csv files into a...
Blob Storage automated downloads
Dipping my toes into the waters of Azure and of course before I get...
Question of the Day
Running Steve's Code
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;
GO See possible answers