The weakest link in database security
The weakest link in database security is the same as for most all IT security: people.
Because the weakest link is...
2014-03-06
956 reads
Blog Posts
Virtual Lab – Adapter Setup
This is part of a series where I set up a virtual lab for testing and misc. work. The other...
2014-03-06
1,070 reads
A Community Challenge
Earlier this week, I delivered a presentation called “Query Progress Tracking in SQL Server” to my local user group.
Among other...
2014-03-05
617 reads
Characters you should never ever use in an object or schema name!
You can put pretty much any character you want into an object or schema name by enclosing the name in...
2014-03-05
738 reads
SQL – Backup Report
The simple query to find the database backup status
The select statment consists of
ServerNamedbnameBackupStartDateBackupFinishDateBackupAgeSizestatusTypeThe query will only run from sql 2005...
2014-03-05
777 reads
SQL – Backup Report
The simple query to find the database backup status
The select statment consists of
ServerNamedbnameBackupStartDateBackupFinishDateBackupAgeSizestatusTypeThe query will only run from sql 2005...
2014-03-05
506 reads
SQL Server Data Encryption Options
SQL Server Data Encryption Types
Businesses today have a greater need than ever to protect their data from security breaches. Data...
2014-03-05
3,265 reads
SQLSaturday #318 in Orlando on September 27, 2014
Number 8! Our eight annual SQLSaturday in Orlando is coming up on September 27th (note, it’s technically our tenth, but...
2014-03-05
656 reads
Write The Perfect Question (Of The Day)
Have you ever voted against something only to be glad later you got out voted? Too many years ago the...
2014-03-05 (first published: 2014-02-25)
1,494 reads
Book: Expert Cube Development with SSAS Multidimensional Models
Those of you who use SQL Server Analysis Services (SSAS) are likely familiar with the “bible” for designing cubes: Expert Cube...
2014-03-04
2,320 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
Forums
Partitioning a table with TEXTIMAGE_ON option
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Building Great Software
Comments posted to this topic are about the item Building Great Software
Question of the Day
The Range of Customers
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers