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,339 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
175 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,179 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,059 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,463 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,541 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,240 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
302 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,265 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
292 reads
Blogs
Seeing the Bigger Picture: How A Monitoring Tool Changed My Approach to Estate Management
By Chris Yates
When it comes to managing complex database environments, having the right monitoring solution is...
A New Word: Foilsick
By Steve Jones
foilsick – adj. feeling ashamed after revealing a little too much of yourself to...
Accelerated Database Recovery for tempdb in SQL Server 2025
Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
count the number of NULLs in a row
Hi everyone I have a SP that finds the average based on 3 tables. ...
Deleting data in large table
I have a large table with 17M+ rows for our package record audits. I've...