What are the different types of cloud deployments? Private, public, hybrid and multi-cloud explained simply, with when to use each.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
What is Cloud Computing?
What is cloud computing? A beginner friendly guide to virtualization, scaling, and the IaaS, PaaS, SaaS and serverless service models.
What is the Cloud?
What is the cloud? A beginner friendly guide: whose computers you rent, what changes for you, what stays your job, and common myths.
What does Verify Backup When Finished do in SQL Server? – Interview Question of the Week #283
Question: What does Verify Backup When Finished do in SQL Server? It looks like a very important step in the entire backup and restores.
DEFAULT WITH VALUES: Fill Existing Rows on a New Column
DEFAULT WITH VALUES fills the rows that already exist when you add a column with a default. Without it, a nullable column keeps NULL in every old row. This post shows the three cases side by side, what a default never does, why the constraint needs a name, and how a large table takes the change in a millisecond.
SQL SERVER – Creating System Admin (SA) Login With Empty Password – Bad Practice
An empty password on sa is a serious security failure. I stopped an e-commerce consultation after noticing passwordless administrator sign-ins.
WITH NORECOMPUTE: Stop Auto Updates on One Table
WITH NORECOMPUTE tells SQL Server to stop updating the statistics of one table automatically. This post sets it with UPDATE STATISTICS, proves that the modification counter keeps growing while nothing refreshes, and shows how to turn it off again. It also shows a safer option for the same problem, a persisted sample percent.
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.