Kathi Kellenberger explains T-SQL window function framing, added in SQL Server 2012, and how frames help with running totals. Notes from the Field #102.
SQL SERVER – What is SQL Server Operating System?
What is the SQL Server Operating System, or SQLOS? An attendee spotted SOS waits after reading my wait stats book, and here is my simple explanation.
SQL SERVER – Understanding SQL Server Setup Support Rules for Cluster Nodes
What do the SQL Server setup support rules check when you build a cluster? My notes on the 11 Cluster Global Rules, and which ones are critical or optional.
SQL SERVER – How to Suppress SQL Server messages in Application Event Log
A brute force attack on sa flooded the Application Event Log with login failures and alerts. Here is how to suppress SQL Server messages from going there.
SQL SERVER – How to Change SQL Server Product Key or License Key?
How do you change the SQL Server product key or license key on an installed instance? Here is what I learned from senior DBAs who manage 1000s of servers.
MySQL – Different Methods to Know MySQL Version
Three simple ways to find your MySQL version with SQL: @@version, the version() function and SHOW VARIABLES, plus why the server version matters.
SQL SERVER – What is the OVER Clause? – Notes from the Field #101
The OVER Clause arrived in SQL Server 2005, yet few know all its uses. In Notes from the Field #101, Kathi Kellenberger explains it with window functions.