dbatools for the accidental DBA
dbatools is a very well known tool within the SQL Server community, and probably most of the production DBA’s are...
2019-04-04 (first published: 2019-03-18)
2,352 reads
DBA Mastery
Speaker at SQL Saturday’s Guatemala city 2019
I’m very happy to announce that for the second year in a row I will be participating as speaker in...
2019-02-15
181 reads
Multi-server scripts with SSMS using SQLCMD mode
SSMS is the most common tool used by SQL Developers or DBA’s but unfortunately there are some features that are...
2019-01-30 (first published: 2019-01-16)
3,193 reads
Determine database version from a bak file
Have you ever imagine you can determine the version of SQL Server from a bak or a MDF file? I...
2018-11-26 (first published: 2018-11-15)
17,327 reads
Is your SQL Server environment ready for GDPR? Part 2
In my previous blog post of this topic, I talked about the definition of what GDPR is and also described...
2018-11-09 (first published: 2018-10-30)
3,467 reads
Creating Wait stats widget on Azure Data Studio for macOS
A couple of weeks ago, Microsoft released a new multi-platform tool called Azure Data Studio, this tool is the final...
2018-10-18 (first published: 2018-10-09)
2,543 reads
Starting SSMS with a specific connection and script file
Have you ever wanted SSMS to start and automatically and establish a connection to your DBA \ hub server and have...
2018-10-15 (first published: 2018-10-02)
7,381 reads
I will be speaking at SQL Saturday # 788 – Denver
I’m very thrilled to announce that I will be participating as speaker in Denver’s SQL Saturday that will take place on...
2018-09-07
306 reads
MAXDOP Calculator
Every time I conduct a SQL Server health check, it’s pretty common for me to find wrong configurations at instance...
2018-08-28
13,460 reads
Guatemala SQL Server local group
Good news for all the Guatemalan data professionals, starting from August 2018 you have an official PASS SQL Server local...
2018-08-23
296 reads
Blogs
Catching Up On SQLOrlando
By Andy Warren
Somehow two years have elapsed since my last update; hopefully it won’t be that...
Advice I Like: Pyramid Schemes
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
Forums
Database file shrink issue.
Hi experts, I have a 3+ TB database on a 2019 sql server which...
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers