Bill Anton explains how the Summarize By property helps you optimize Tabular Models for self-service reporting, where users build their own reports.
SQL SERVER – Skip “Save Changes to the Following Items?” Prompt in Management Studio (SSMS 2016)
Tired of the ‘Save changes to the following items?’ prompt when closing query windows? SSMS 2016 has a setting to skip it, and here is where to find it.
SQL SERVER – Q&A: SQL Clustering Virtual Server Name and Instance Name
Basic SQL Clustering questions from a team new to cluster installs, like whether a new clustered instance needs a new virtual server name, answered one by one.
SQL SERVER – FIX: Setup Was Not Able to Access Domain
A DBA installing SQL Server 2012 on a virtual machine got ‘Setup was not able to access domain’. Here is what the message means and how to get past it.
How to Insert Multiple Rows in a Single SQL Query – Interview Question of the Week #069
Interview question: write one script that inserts multiple rows in a single SQL query and runs unchanged in SQL Server, MySQL and PostgreSQL. Here is my answer.
SELECT One by Two – Interview Question Extended – Part II
After my SELECT One by Two puzzle, I played with a small extension: three queries mixing 1. and 1/2. Can you guess what each one returns and why?
Database Scalability: Vertical and Horizontal Explained
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.