Getting and storing a high precision datetime
Earlier today I was working on a project where I was recording some time stamps. In order to get as...
2015-08-13
587 reads
SQLStudies
Database Master Keys can have more than one password.
Our subject for this month’s T-SQL Tuesday blog party (#69) is Encryption, hosted by a guy with an awesome first...
2015-08-11
814 reads
A pattern to match correctly on a value or a NULL
As you may have noticed if you read my blog I learn a lot from trolling various forums. In this...
2015-08-05
1,301 reads
SQL Crossword
I decided I’d have some fun today. So for your entertainment here is my first crossword puzzle. (Word and PDF...
2015-08-03
957 reads
Some of my favorite SSMS Keyboard shortcuts
I love keyboard shortcuts. I recently mapped a keyboard shortcut to Change Connection and thought I would share some of...
2015-07-29
1,278 reads
Permissions Posters
I’ve been doing a lot of research recently for my permissions session and for a project at work. During said...
2015-07-27
1,380 reads
#ArgenisWithoutBorders the Sequel
Last year Kirsten Benzel(b/t) and Argenis Fernandez(b/t) did this amazing thing. They organized a campaign and raised over $13,000 for...
2015-07-22
689 reads
Filtered Index restrictions and Kendra Little’s Index Quiz
A few weeks ago I saw a tweet about Kendra Little’s (b/t) new SQL Server Quizzes. Of course I had...
2015-07-24 (first published: 2015-07-20)
2,184 reads
SSMS 2015
Yes, you heard me right. SSMS 2015. No I’m not one of those crazy recruiters who keep asking for 10...
2015-07-16
991 reads
TSQL Tuesday #68: What is my configuration?
It’s T-SQL Tuesday again and this month Andy Yun (b/t) is our host and he has asked us to “Just...
2015-07-21 (first published: 2015-07-14)
1,446 reads
Blogs
Audit – Security Compliance Frameworks (Part 1)
By Vinay Thakur
This blog series on Audit/Compliance/Security, this is first blog where we would discuss about...
Restore SQL Server Database to an OrbStack Container
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...
Day of Data Baton Rouge Slides and Code
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Forums
Can You Really Downgrade from Enterprise to Standard and Save Thousands? Here's What Happened
Comments posted to this topic are about the item Can You Really Downgrade from...
What is CPU Usage?
Comments posted to this topic are about the item What is CPU Usage?
Limiting Checkpoints
Comments posted to this topic are about the item Limiting Checkpoints
Question of the Day
Limiting Checkpoints
If I use the -k parameter with a number after it, what does this change in SQL Server?
See possible answers