Slides and Example Code for SQL Lunch #42 - Auditing Database Permission in SQL Server
As promised, here are the slides and sample code from my SQL Lunch presentation today. Thanks for all who came...
2010-11-04
684 reads
Databases – Infrastructure – Security
Successful Teams: Everyone Performs
By day I'm a DBA. Nights and weekends I'm a junior high youth pastor and Awana commander. I have the...
2010-11-03
1,469 reads
Rescheduled: SQL Lunch #42 - Auditing Database Permissions in SQL Server
Last Wednesday I woke up feeling under the weather with a hoarse voice. I wasn't up to doing the presentation...
2010-11-01
705 reads
Why You Should Vote for My SQLRally Pre-Con
Self-marketing is not my strong suit. I don't feel very comfortable doing it, but Andy Warren (twitter | blog) suggests that we...
2010-10-29
2,482 reads
Free SQL Server Training for the Week of November 1, 2010
Tuesday
PASS Performance Virtual Chapter - Five Fast Fixes for Fatal Flaws - Brent Ozar
Wednesday
SQL Lunch - Data Mining in SQL Server and Power...
2010-10-29
1,812 reads
Postponing SQL Lunch Presentation Until Next Week
I woke up this morning about 3 AM with clogged sinuses and a fever. Great. The changing weather patterns that...
2010-10-27
632 reads
Have You Grabbed the SQL Sentry Plan Explorer Yet?
I won't say I despise SQL Server Management Studio's (SSMS) display for execution plans, but it's about at that level....
2010-10-27
1,248 reads
Why CONTROL SERVER Doesn't Cut It
With the new securables since SQL Server 2005, Microsoft has advised that we start moving away from the fixed server...
2010-10-26
4,543 reads
Vote for Me for a PASS SQLRally Precon on SQL Server Security
Unless James Bond is in the picture, security is usually not a sexy topic. However, we all lament the lack...
2010-10-25
2,058 reads
Speaking for SQL Lunch on Wednesday
This coming Wednesday I'll be speaking for SQL Lunch on the topic of Auditing Database Permissions in SQL Server. The abstract for...
2010-10-22
516 reads
Blogs
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
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...
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