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,643 reads
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,643 reads
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,473 reads
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,545 reads
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,507 reads
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
308 reads
Query Store is a very powerful tool for performance tuning, if you are not using it already you should!! It...
2018-08-29 (first published: 2018-08-13)
2,073 reads
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,653 reads
Good news for all the Guatemalan data professionals, starting from August 2018 you have an official PASS SQL Server local...
2018-08-23
297 reads
I really like Microsoft philosophy nowadays, they are putting a lot of time developing good open source tools like SQLCLI,...
2018-08-10 (first published: 2018-08-07)
3,512 reads
06/21 was the date that marked my career as data professional, for the first time ever I decided to participate as...
2018-08-01
243 reads
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
Comments posted to this topic are about the item Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers