Evaluate indexed views by building a sales summary, comparing read savings with write maintenance, and using NOEXPAND where required.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Denali – Startup Parameters Easy to Configure
SQL Server Denali makes startup parameters easy to change. Here is the quick path in SQL Server Configuration Manager to the startup parameters screen.
Azure SQL Database for the On-Premises DBA
Azure SQL database for the on-premises DBA changes patching and backups, while leaving query tuning, access, cost, and recovery checks with your team.
Running SQL Server in a Container for Testing
Create a SQL Server container for testing from Windows PowerShell, keep data in a named volume, and separate disposable runtime from backups.
Puzzle – Usage of New Index Hints – ForceSeek and ForceScan
SQL Server Denali adds the FORCESCAN hint next to FORCESEEK. A weekend puzzle on these Index Hints: write a query where each one improves performance.
SSAS Tabular vs Multidimensional: Choosing for a New Project
Compare Tabular vs Multidimensional for SSAS projects, including storage, relationships, write-back, team skills, and model checks.
Logging ETL Runs in a Table
Logging ETL runs in SQL Server gives each step start and end times, row counts, and errors so the next morning’s investigation has facts.
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.