I have been looking into this feature and also into understanding graph data in general. I believe introduction of graph database feature in SQL Server has many advantages –...
2019-08-22 (first published: 2019-08-09)
844 reads
The session line up for PASS Summit 2019 was announced today...there are so many good sessions to go to..managing time and what we do with our limited time there...
2019-08-08
25 reads
Temporal tables a.k.a Table Versioning was introduced in SQL Server 2016 and is an easy, convenient way to track changes to data. A good introduction to temporal tables can be found here. One of the key advantages of versioning tables is easy of querying – or getting a ‘single pane of glass’ look of how […]
2019-07-29
14,982 reads
One of the most significant and hardest challenges we face as data professionals (or generally anyone in IT) is how to keep up with learning. Most of us are...
2019-06-05 (first published: 2019-05-17)
221 reads
Its really hard to believe that its been 20 years since the start of the PASS organization – the volunteer run...
2019-03-19
836 reads
I cannot write this without stating some history. I have been part of PASS community since 1999. That is 21...
2019-03-11
216 reads
The last T-SQL Tuesday of this year is hosted by Jason Brimhall – one of my long-time friends in the SQL...
2018-12-12
124 reads
This will be my last post for the year. In this am going to look back on goals I set...
2018-12-03
731 reads
I am the proud host of TSQL Tuesday for the month of November 2018.
My call to post entries is here ....
2018-11-28 (first published: 2018-11-18)
2,231 reads
I have been a regular attendee at PASS Summit for 15 years now. This year (2018) marked my 15th year...
2018-11-22
197 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