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
256 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
334 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
397 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
266 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
330 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
360 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,066 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,928 reads
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
Dealing with huge heap tables
Recently, our dev teams approach me for advice on improving their huge heap table...
BCA KCU GAJAH MADA No.Telpon 087781685647
Whatsapp 087781685647 Jl. Gajah Mada No.112 B-C-D, RT.1/RW.1, Krukut, Kec. Taman Sari, Kota Jakarta...
Merge Replication failing with Error converting data type nvarchar to numeric
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers