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
Databases – Infrastructure – Security
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,177 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,043 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
New article: Identifying What Runs at Startup on SQL Server
Another article has published over at MSSQLTips.com. This one covers how to identify what stored procedures are set to run when...
2012-01-30
937 reads
You require WHAT for a license?
I was trying to acquire a license for a product I was trying to look at using a free program....
2012-01-26
1,035 reads
About those backups...
So I went to present at Charleston PASS on Thursday night and of course I had my standard contact information...
2012-01-30 (first published: 2012-01-25)
2,005 reads
Clicking on Links in Email
Every security awareness presentation makes the warning about opening attachments or clicking on links in emails when you don't know...
2012-01-24
1,255 reads
New Article: How to audit sysadmin members on multiple servers using PowerShell
My first article of 2012 has published over at MSSQLTips.com. This one covers the basic technique for using PowerShell to audit...
2012-01-23
1,943 reads
Speaking at Charleston PASS on January 19th
I will be presenting on SQL Server security on January 19th in Charleston, SC. You can find the details at...
2012-01-04
858 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...
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...
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers