Security Audit
Of late I have seen a lot of questions on how to audit the logins and users on each SQL...
2010-03-19
1,787 reads
When It "Has" to Use SA...
As an infrastructure and security architect, I cringe any time any one mentions the following:
Domain AdminrootsaThose accounts can do anything...
2010-03-19
650 reads
Licensing SQL Server Reporting Services
I have my license here somewhere, officer.
Licensing models can sometimes make database modeling seem trivial. Per processor or per seat?...
2010-03-19
1,103 reads
SQL Log Shipping – by Abi Chapagai
SQL Server 2008 High Availability Solution: Log Shipping
In SQL Server, transaction log provides an ability to recover a database...
2010-03-19
1,715 reads
Being Involved in the Community
Regular readers know that I enjoy being involved in the SQL Server community. Over the last two and a half...
2010-03-19
342 reads
Tally Table CTE
Now that I have several posts on what you can do with a Tally table, I figured I'd share my...
2010-03-19
5,157 reads
Windows Themes (We need a PASS Theme!)
I imagine most of us change our wallpaper on the desktop from time to time. Frivolous but fun, a simple...
2010-03-19
870 reads
Losing Two Days
I’m off tomorrow to the UK for a week of work at the Red Gate offices, and then a couple...
2010-03-19
658 reads
Be Wary
We make mistakes when we publish things. It happens, and I am as guilty as some people of mistakenly putting...
2010-03-19
924 reads
Need to Persuade Your Manager or Co-Worker to Your Point of View?
At one time or another, each of us has been in a position where we need to persuade a manager,...
2010-03-18
567 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers