T-SQL Tuesday #028 - I'm a Jack of All Trades, and Proud of It
If I wasn't, would I have proposed the following topic for several speaking chances, including SQLRally?
Being a specialist means you're...
2012-03-06
1,226 reads
Databases – Infrastructure – Security
Speaking at oPASS on March 8th
I will be at oPASS on March 8th (Thursday) in Orlando, Florida. I'll give a preview of the talk I'm giving...
2012-03-01
1,030 reads
Presenting Two Sessions at SQLRally
I just received great news that one of my sessions, Attacking SQL Server, was picked by the community for SQLRally....
2012-02-27
979 reads
New Article: Exploiting SQL Server via CONTROL SERVER permissions
I have a new article up at MSSQLTips.com, covering what someone can do with CONTROL SERVER. Most folks know to...
2012-02-27
1,734 reads
A Plea: Have your guidance documentation reviewed
Today one of my auditors sent me her matrix for auditing Microsoft SQL Server. I had seen part of it...
2012-02-23
1,229 reads
Two Sessions Up for Vote at SQLRally!
I received great news last week that one of my sessions, Windows Operating System Internals for DB Pros, was accepted,...
2012-02-21
856 reads
USB/Flash Drive Security
Gone are the days when remote drives were easy to detect because there was some size to them. Nowadays USB...
2012-02-15 (first published: 2012-02-13)
2,211 reads
See You at SQL Saturday!
I've been asked this question a few times, and Columbia, SC isn't hosting a SQL Saturday this year. Bobby Dimmick...
2012-02-13
1,175 reads
Slides and Scripts from Idera February webcast
For those who've asked, here are the slides and scripts from my SQL Server auditing webinar with Idera:
Presentation (.PDF)Scripts (.ZIP)
If...
2012-02-10
1,038 reads
Webcast: Successfully Meeting Your Audits for SQL Server
Tomorrow at 3 PM Eastern I'll be giving a webcast in conjection with Idera and MSSQLTips.com:
Registration for Successfully Meeting Your...
2012-02-07
1,014 reads
Blogs
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
4 CPE Opportunity (Virtual) for Charity
By Brian Kelley
Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...
Data Céilí 2026 Call for Speakers!
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...
Forums
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
UNISTR Basics
Comments posted to this topic are about the item UNISTR Basics
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers