2013-11-22
1,957 reads
Security
2013-10-31
2,191 reads
Loginless Database Users and Dynamic SQL
Implement Loginless Database Users to maintain data security and preserve interface when dynamic SQL is being used within a stored procedure.
2013-09-10
7,324 reads
2013-07-12
2,310 reads
Passively detect attempts to guess passwords
Review the error log for possible brute force or dictionary attacks on your SQL Server instance.
2015-05-08 (first published: 2013-05-22)
2,674 reads
Loginless In Seattle
Identify orphaned Database Users and differentiate them from "Loginless" Database Users.
2013-05-13
3,112 reads
Change DB Owner to sa for multiple DB's
Changes DB owner to sa for Online DB's where owner is not sa
2013-04-26 (first published: 2013-04-12)
2,609 reads
Algorithm Secrecy is not Security
This week Steve Jones talks encryption and why you shouldn't be implementing anything you've invented.
2013-03-18
166 reads
Stored Procedures and SQL Injection
Why do stored procedures help with security? In this piece, MVP Brian Kelley explains why SQL Injection and information gathering are hampered with stored procedures.
2015-06-12 (first published: 2013-02-18)
20,966 reads
2013-02-28 (first published: 2013-02-12)
1,139 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...
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
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