A puzzle from a migration project: SSMS cannot script every Primary Key and Foreign Key at once. Can you write a script that generates them all?
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Calculating the Cost of a Slow Query
Cost of a slow query includes frequency, CPU, reads, waits, and user time; learn to turn SQL Server measurements into a practical tuning priority.
SQLAuthority News – SQL Azure – Microsoft SQL Data Services – Introduction and Pricing
SQL Data Services is now SQL Azure. An introduction to SQL Azure Database and its pricing: Web Edition at $9.99 and Business Edition at $99.99 a month.
SQLAuthority News – Authors Visit – DelhiBuzz TechEd on July 11, 2009
My report from DelhiBuzz TechEd on July 11, 2009, where Delhi got its own PASS Chapter, with thanks to the people who made the day a success.
SQL SERVER – Get Last Running Query Based on SPID
How to see the last running query of another session based on its SPID, using @@SPID to find session IDs and DBCC INPUTBUFFER to read the query.
Resource Governor: Capping a Runaway Report
Capping a runaway report with Resource Governor uses workload groups, pools, and a tested classifier to limit one workload safely.
SQL SERVER – Two Methods to Retrieve List of Primary Keys and Foreign Keys of Database
There are two different methods to retrieve the list of Primary Keys and Foreign Keys from the database.
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.