One server with 64 cores or two with 32 cores? A customer asked me to help decide. Here is a simple look at database scalability, vertical and horizontal.
Hey DBAs – What Are You Assuming/Missing Today? – Notes from the Field #122
Hey DBAs, what are you assuming or missing today? Mike Walsh on why a good DBA watches every instance and is not afraid to say I do not know.
SQL SERVER – Computed Column and Conditions with Case Statement
How to write conditions with CASE statement in a computed column, using a simple AdventureWorks script you can adapt for any complicated logic.
SQL SERVER – Identify Table Where Clustered Index is Not a Primary Key – DMV
Let us first see script which will return us tablename with schema where clustered index is not a primary key.
SQL SERVER – What is WRK file in Log Shipping?
Even if you have used log shipping for years, you may never have noticed the WRK file in log shipping. Here is what I learned about it.
What is Difference Between HAVING and WHERE – Interview Question of the Week #068
Clients sometimes interview me, and my answers from experience do not always match the textbook. Last week’s Interview Question: HAVING versus WHERE.
PowerShell Script – Backup Every Database In SQL Server
A client wanted to automate backups with a script instead of a GUI. Here is the PowerShell and SMO script I have used for years to backup every database.