ISACA Class: Auditing SQL Server in Every Way Possible
At this year’s TechnoSecurity and Digital Forensics Conference I gave a 1 hour presentation on auditing SQL Server. There were...
2018-08-09
259 reads
Databases – Infrastructure – Security
New at Simple-Talk: Principles of Data Protection
My latest article, Principles of Data Protection, has been published at Simple-Talk! I address the basic problem and how we...
2018-07-02
362 reads
I’m published at Simple-Talk!
My first article has gone live at Simple-Talk! Thanks to Aunt Kathi for the opportunity!
Detecting Data Breaches
I’m also still writing...
2018-06-12
336 reads
New Article: Return SQL Server Connections Information Using sys.dm_exec_connections
I’ve started a new series at MSSQLTips.com walking through the various Dynamic Management Objects we have available to us in SQL...
2018-05-18
402 reads
Speaking at Idera’s Live Virtual Conference
Have you heard about Idera’s Live Virtual Conference? It is being held on May 16, from 9 AM to 3...
2018-05-01
269 reads
Webinar: Auditing with Extended Events
I’m giving a webinar today, April 5th, at 3 PM Eastern, on using Extended Events to audit your SQL Servers....
2018-04-05
332 reads
Webinar: Identify and Eliminate SQL Server Performance Issues
I’m giving a webinar tomorrow, March 22, 2018, at 3 PM Eastern.
Free Registration Link
Here’s what I’ll be covering:
Are you struggling...
2018-03-21
363 reads
Speaking at the 2018 Techno Security and Digital Forensics Conference
One of my favorite conferences is held in Myrtle Beach, SC, in June. It’s a security and digital forensics conference which...
2018-03-01
311 reads
Settings Goals Professionally
I was reminded of this topic after yesterday’s #SQLChat. Have you set professional goals for yourself? If so, have you...
2018-02-16 (first published: 2018-02-08)
2,067 reads
Tinker as You Learn
In recent weeks I’ve seen my brother from another mother, Andy Leonard (twitter | blog), write or post about his learning...
2018-02-09 (first published: 2018-01-24)
1,931 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Is Fabric a Reliable Service or a Ripped Resource?
Comments posted to this topic are about the item Is Fabric a Reliable Service...
locking down agent for new user on our dev machine
hi , a new user wants to be able to add sql agent jobs...
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers