Staging, warehouse and mart give data loads, trusted history, and focused reporting separate jobs; learn when each layer earns its place.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Fillfactor, Index and In-depth Look at Effect on Performance
Where in SQL Server does 100 equal 0? In Fillfactor settings. An in-depth look at how the Fillfactor of an index affects page fill and performance.
SQL SERVER – Difference TempTable and Table Variable – Table Variable in Memory a Myth
Is a table variable in memory while a temp table lives in TempDB? It is a myth: both are created in TempDB, and a simple script proves it.
SQLAuthority News – An Year of Personal Events – A Life Outside SQL
Do I have a life outside SQL? Yes, and it is beautiful. Three photographs from my year of personal events, told with very few words.
SQL SERVER – White Paper – Partitioned Table and Index Strategies Using SQL Server 2008
Ron Talmage’s white paper on partitioned table and index strategies using SQL Server 2008, for loading, removing and maintaining data in very large tables.
SQLAuthority News – Featured on Channel 9
This blog was featured on Channel 9 in This Week on Channel 9, where Scott Hanselman and Jon Galloway talked about my CSV from table column post.
SQL SERVER – ERROR: FIX: Cannot drop server because it is used as a Distributor in replication
Removing replication fails with Cannot drop server because it is used as a Distributor in replication? Two quick commands with sp_dropdistributor fix 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.