How Query execute
*This is my Opinion Whenever you execute any query…. Everything will be on Memory unless data is not available from...
2011-06-10
477 reads
Vinay Thakur
Isolation level and Locks
Before moving with next blog. We should be aware of some information about Isolation level. As the trasaction is depends...
2011-06-08
844 reads
Failure Cluster -General
We have discussed some basic high availability here. Yesterday we were discussing about Windows clustering (here on will say “Clustering”)...
2011-06-04
578 reads
SQL Server Migration Assistant v5.0
I bloog about mysql to sql server migration lastly here Today found very good migration tool Free Downloads: 1. SSMA...
2011-05-25
671 reads
Troubleshooting Performance -1
Whenever you get a call from user that they are facing any performance issue what would you do. As I...
2011-05-11
472 reads
Download: Powershell a Day -April 2011
I you liked my Powershell a day – april 2011, where every day I wrote a blog about powershell you can...
2011-04-30
1,540 reads
Powershell Day 30
Day 30 Best Practice Having good Security is first best practice for any language no exception with Powershell. Having that...
2011-04-30
1,451 reads
Powershell Day 29
Day 29 Advance Security As discussed in earlier blog about “Security” Day 7. Continue on that we will discuss here...
2011-04-29
1,444 reads
Powershell Day 28
Day 27 SQL Policy I highly recommand to go through the Policy –based management (BCM)’s official excellent site to learn...
2011-04-28
518 reads
Powershell Day 27
Day 27 Inventory As discussed ealier about wmi, wmi is a good for accessing inventory data from remote system as:...
2011-04-27
526 reads
Blogs
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Forums
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Upgrading Admin Queries
Comments posted to this topic are about the item Upgrading Admin Queries
Question of the Day
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