In the interview and I end up seeing candidates failing to answer this question about the Stored Procedure Modified recently.
SQL SERVER – Change Color for System Object Name in Text Editor (SSMS 2016)
SSMS 2016 shows system objects and DMVs in a color that is hard to read. Here is how I changed the system object color in the Text Editor back to the old style.
SQL SERVER – Optimizing Tabular Models for Self-Service Reporting: Summarize By – Notes from the Field #123
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.