Learning to Give Presentations Well (Part 1)
I’ve given technical presentations for years. I’ve also taught in churches and youth groups years before that. For me, speaking...
2017-11-17 (first published: 2017-11-06)
1,504 reads
Databases – Infrastructure – Security
If You’re Stuck at Home for the PASS Summit
Conferences are a great place to network, to see new technologies or to see existing technologies being used in new...
2017-10-30
669 reads
Don’t “Test” Against Production
A few months ago, I was participating in a threat hunting exercise on the security side. The gentleman leading the...
2017-10-30 (first published: 2017-10-18)
2,057 reads
Automating Everything with PowerShell – Getting Started #tsql2sday
I try to automate everything I can with PowerShell. Whether we’re talking SQL Server, WSUS, Active Directory, or any other...
2017-10-17
897 reads
Randomness in Security Configuration
We were deploying a new web service. Because of the nature of the service, we wanted it to listen on...
2017-08-24 (first published: 2017-08-14)
1,407 reads
Just Say No to Social Engineering Memes
These memes, from a security and privacy perspective, are nothing but trouble. Here’s an example I just saw a friend...
2017-08-11
1,386 reads
#TSQL2sday: Interviewing Patterns
This T-SQL Tuesday is hosted by Kendra Little.
I’ve been told interviewing is an art. Perhaps it is. I view it...
2017-08-08
312 reads
Geek Sync on Wednesday: Taking Control of Your Organization’s SQL Server Sprawl
This Wednesday, July 26th, at 12 PM EDT, I’ll be giving a presentation through Idera’s Geek Sync series. You will...
2017-07-24
285 reads
Remember What It’s Like to Be a Rookie
File this under “soft skills.” Let me start with a recent experience.
Last week I was leading a team of youth...
2017-08-08 (first published: 2017-07-20)
1,687 reads
Security Basics: The Principle of Least Privilege
Whenever I’m asked about creating a security model for an application or database, I tell folks to follow the Principle...
2017-07-17 (first published: 2017-06-30)
2,912 reads
Blogs
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...
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
Forums
Blob Storage automated downloads
Dipping my toes into the waters of Azure and of course before I get...
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
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