The CTP1 Refresh of Microsoft Synchronization Services for ADO.NET v2.0 is out. It syncs data between a local store on laptops or devices and a central server.
A Throwaway Virtual Machine for SQL Server Testing
Use a Throwaway Virtual Machine to test SQL Server setup, patches, and failures with snapshots and safe rollback away from shared servers.
SQL SERVER – ACID (Atomicity, Consistency, Isolation, Durability)
ACID stands for Atomicity, Consistency, Isolation and Durability, the four properties every reliable database needs. Each one explained in a line or two.
SQL SERVER – Generic Architecture Image
A Generic Architecture image of SQL Server I found on Wikipedia, with a short note on physical storage in MDF and LDF files and how data is grouped logically.
SQL SERVER – FIX : Error : 3702 Cannot drop database because it is currently in use.
Error 3702 says you cannot drop database because it is in use. Switch to master, find other connections and drop it safely with this fix.
SQL SERVER – 2005 – Dynamic Management Views (DMV) and Dynamic Management Functions (DMF)
Dynamic Management Views and Management Functions show what SQL Server is doing right now. The two scopes, the main categories and where to start.
SQL SERVER – UDF – Remove Duplicate Chars From String
A reader, Virendra Chauhan, shared a UDF that removes duplicate chars from one large string. Here is his REMOVE_DUPLICATE_INSTR function and how to call it.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.