Encrypting a Database Never Finishes
There is plenty of legislation and regulation in place these days that strongly suggest the encryption of data within a...
2018-12-20
394 reads
Blog Posts
Information Measurement with SQL Server Part 4.3: Euclidean Distance and the Minkowski Family
By Steve Bolton
…………“The shortest distance between two points is a straight line.”
…………In this famous remark, Archimedes[1] (287-212 B.C.) managed to...
2018-12-20 (first published: 2018-11-30)
2,519 reads
Personal Touch: An Argument Against Automation
At the far end of an out-of-the-way aging strip shopping center in southern Louisiana, there stands a small and modest sushi restaurant. The exterior could be described as tasteful...
2018-12-20
17 reads
Personal Touch: An Argument Against Automation
At the far end of an out-of-the-way aging strip shopping center in southern Louisiana, there stands a small and modest...
2018-12-20
215 reads
Restarting a Sequence–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-12-20
1,059 reads
SHUTDOWN SQL Server
Recently a friend by the name of Chris Bell (blog | twitter) wrote about an easy way to disrupt SQL Server....
2018-12-20 (first published: 2018-12-03)
3,589 reads
Actual Emails: What is a "soft delete"?
What's a "soft delete", and why should DBAs be aware of such behavior in tables?
So, a DELETE statement is a “hard” delete. The data is gone.
However, it is a...
2018-12-19
13 reads
Infrastructure matters, even in the Cloud
I am still amused by terminology in the Information Technology field. Words like “Kubernetes,” “containers,” and the BASIC keywords PEEK...
2018-12-19
280 reads
MongoDB – Basic Commands
We discussed about MongoDb installation and startup. I highly recommend to go though the training session which will provide a detail...
2018-12-19
214 reads
SQL Server Availability Group FailoverDetection Utility PowerShell Function Improvements – Named Instances, Archiving Data, Speed
In my last post I wrote about a new function for gathering the data and running the FailoverDetection utility by...
2018-12-19 (first published: 2018-12-01)
1,863 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers