You can use the VALUES clause to build a small dataset like a table without creating one. Here is the syntax, which works from SQL Server 2008 onwards.
SQL SERVER – Secure by Default – The Mantra
A SQLSaturday discussion led to this secure-by-default reminder: restrict application permissions, protect connections and inspect access before changing it.
SQL SERVER – Difference Between Read Committed Snapshot and Snapshot Isolation Level
Read Committed Snapshot and Snapshot Isolation level sound alike but work differently. I explain the difference and show the ALTER DATABASE command for each.
SQL SERVER – Why Haven’t You Disabled CPU Power Saving Yet?! – Notes from the Field #087
Notes from the Field #087: why you should disable CPU power saving on your SQL Server, and how this one setting can quietly slow queries.
SQL SERVER – Steps to Generate Windows Cluster Log?
When a SQL Server resource will not come online in a failover cluster, I check the cluster log. Here are the steps to generate the cluster log on Windows.
SQL SERVER – Knowing the Source Application Using APP_NAME() Function
The APP_NAME() function returns the application name of the current session. See what it returns in SSMS and how it helps you audit where data comes from.
SQL SERVER – Getting Started and Creating JSON Using SQL Server 2016 – JavaScript Object Notation
SQL Server 2016 adds JSON support. Here is a quick look at what JSON (JavaScript Object Notation) is and how to create your first JSON document with a query.