Resolving state is the intermediate state of an AlwaysOn availability group during a role change. If the transition fails, the group stays there and the database is not accessible. Here is what the ERRORLOG showed in one case.
SQL SERVER – 2016 – Check Value as JSON With ISJSON()
Before you store JSON sent from the front end, make sure it is valid. Here is how the ISJSON() function in SQL Server 2016 checks a value as JSON.
SQL SERVER – Boosting User Experience with Analysis Services Perspectives – Notes from the Field #116
Analysis Services Perspectives let a designer show users only the parts of a data model they need. Notes from the Field #116 explains how they help users.
A T-SQL Formatting Style Guide for Teams
Adopt a short T-SQL formatting style with clear columns, joins, aliases, semicolons and comments, and keep review focused on query behavior.
SQL SERVER – How to Start SQL Server Service Without tempdb?
During a live demo, SQL Server refused to connect after a config change. Here is how to start SQL Server Service without tempdb. Never try this in production.
SQL SERVER – Scripting Tip: PowerShell to Identify Last Bootup Time
A friend from the networking team asked when his server was last started. Here is a quick PowerShell script to identify the last Bootup Time of a machine.
Interview Question of the Week #059 – What are the Limitations of User Defined Functions (UDF) ?
Interview Question of the Week – What are the Limitations of User Defined Functions (UDF) ? Let us learn about that in today’s blog post.