Consider All the Possibilities When Troubleshooting
When you are troubleshooting, the rule is if you've checked the obvious possibilities and still haven't solved the problem, it's...
2013-01-28
1,663 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
Cash Over Credit
What does cash over credit have to deal with security? An awful lot, as it turns out.
Personal Story: Mere days...
2013-01-17
1,208 reads
Observe Carefully When Things Are Running Fine
Cross-posted from The Goal Keeping DBA blog:
As a worker in information technology, I’ve always been a big proponent of studying systems...
2013-01-14 (first published: 2013-01-10)
2,147 reads
Rename the SQL Server Management Studio shortcut
Jorge Segarra (blog | twitter) was giving a presentation and he remarked on how the SQL Server Management Studio shortcuts have...
2013-01-11
7,779 reads
Speaking at Midlands PASS in February
On February 12th I'll be giving a SQL Server Security Refresher for Midlands PASS at Microstaff IT in Cayce/West Columbia,...
2013-01-10
955 reads
Re-Awarded as a Microsoft MVP
Yesterday (January 1) I received the email indicating I was re-awarded as a Microsoft MVP, once again in SQL Server....
2013-01-02
1,185 reads
Looking Forward to the New Year - Professional Goals
Most folks make New Year's resolutions of things they want to do over the course of the next 364/365 days....
2013-01-01
1,302 reads
Are You a Chessplayer?
I was having a twitter coversation with @dataartisan about chess. He remarked that playing on-line with random folks didn't strike him...
2012-12-17
1,029 reads
Are Your Protecting Your DB Backups?
Folks have cited the recent InformationWeek article on how South Carolina's Department of Revenue was hacked because the SC state government...
2012-11-27
3,147 reads
Server Level Security
We'll discuss surface area later in the week. Today let's talk about if you're able to connect to SQL Server....
2012-11-09 (first published: 2012-11-06)
3,419 reads
Blogs
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Solving SQL Server Mysteries with a Whole Gang of Sleuths -Scooby Dooing Episode 4
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
Forums
SQL Server 2025 Jobs
Hello SQL Server 2022 16.0.4212.1 running on a Windows Server 2025 Std,V 24H2, SO...
how to optimise whole database full of table and sp in one go using githubcopilo
i have subscription of github copilot which i can access in vs 2022 comunity...
Password Guidance
Comments posted to this topic are about the item Password Guidance
Question of the Day
Using table variables in T-SQL
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers