While hiring Database Administrators and senior developers for a large project, we discussed many interesting questions. Here are some, with my own views.
SQL SERVER – 10 Reasons for Database Outsourcing
10 reasons for database outsourcing, starting with cost reduction: no need to pay your own staff to watch servers, power supplies and security.
SQL SERVER – Find Last Date Time Updated for Any Table
Want the last date time a table was updated without an UpdatedDate column? The sys.dm_db_index_usage_stats DMV shows it. A quick demo on AdventureWorks.
Ordered Columnstore Indexes in SQL Server 2022
Build an ordered columnstore index in SQL Server 2022, inspect segment bounds, and compare range-query reads on your own data.
SQL SERVER – FIX : Error : Windows Update; Error Code 8000FFFF
Windows Update kept failing with Error Code 8000FFFF on my Vista machine, so SQL Server 2008 Books Online stayed out of date. Here is how I fixed it.
A Weekly Routine for SQL Server Administration
A weekly routine for SQL Server Administration checks recovery, failures, capacity, integrity, security, and pending changes in a practical order.
Adaptive Joins: When the Plan Picks Its Join at Run Time
Understand adaptive joins in SQL Server, read their runtime threshold, inspect the actual choice, and test a query hint safely.