Does my database have data type drift?
Over the years I have come to see that every database has what I call data type drift. Simply put,...
2016-07-13 (first published: 2016-06-28)
2,482 reads
Confessions of a Microsoft Addict
Are my SQL logins weak?
Security is a vital component of data security. In today’s day and age it is imperative to think about security....
2016-07-04 (first published: 2016-06-24)
1,607 reads
Is Resource Monitor (resmon) all I need to troubleshoot storage?
I was recently doing some work on my Windows 10 desktop and placed a drive on one of the slower...
2016-06-30 (first published: 2016-06-23)
1,567 reads
Microsoft finally got SQL setup right!
This past week, Microsoft revealed that SQL Server 2016 will be available in June. Exciting news indeed! With that said,...
2016-06-22
460 reads
SQL Server Security Series, part 1
In the first entry in this SQL Server security series, we will demonstrate a brute force attack against SQL Server...
2016-06-22
467 reads
Blogs
SQL Prompt Quick Access to Helper Code
By Steve Jones
We’ve been doing some events as part of the Redgate Roadshow, and at one...
Eleven chapters of my data architecture book are available
By James Serra
As I have mentioned in prior blog posts, I have been writing a data...
Speaking at SQL Saturday Boston 2023
By alevyinroc
I’m happy to announce that I will be speaking at SQL Saturday Boston on...
Forums
Convert common Separated number to # table
@reportParameter 1008,1009,1011,1014 values need to insert to #Table Note: @reportParameter is not returning values...
Things to be considered before implementing database auditing
Hi All, As part of security compliance, we are told to audit DML &...
The Need for DevSecOps
Comments posted to this topic are about the item The Need for DevSecOps
Ask SSC