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
586 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
813 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,297 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,275 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,361 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
688 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,444 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers