(Joe Gavin) You want to create an alert in Log Analytics to monitor Performance Monitor counters and / or Event Logs and need a quick way to jump in and get familiar with it.
Tag: sql server
SQL SERVER – Empty Startup Parameter in SQL Cluster on One Node
(Pinal Dave) While working with many clients, I learned that “there could be many problems leading to same symptoms”. In this blog, we would learn about a reason which can cause empty startup parameter in SQL Cluster.
Granting Permissions in Azure Data Lake
(Melissa Coates) This purpose for this set of posts is to share some tips & scripts for setting permissions for Azure Data Lake. This content is split up into a short series:
SQL Server and the Spectre/Meltdown Vulnerabilities
(Glenn Berry) Since January 3, 2018, there has been a lot of conflicting and possibly alarming information published about the speculative execution side-channel vulnerabilities also known as Meltdown and Spectre that affect most modern processors in varying degrees.
SQL Server Replication for Temporal Tables
(Ameena Lalani) Let’s say you have the need to replicate SQL Server temporal table data to offload reporting to another server. When you try to setup replication you notice you get an error “The use of replication is not supported with system-versioned temporal table XXX.” So, how can you complete
Double hop error when using SQLCMD
(Kenneth Fisher) tl;dr; SQLCMD v2014 and up has special requirements for Kerberos.
Use of PIVOT in SQL
(Sandeep Raturi) PIVOT in SQL is very power full technique to transform row level data into column level.
SQL SERVER – Error 1324. The folder path ‘Program Files’ contains an invalid character.
(Pinal Dave) Some error messages are so interesting that it takes a lot of time to get the right solution. One of the errors which I faced during SQL Cluster installation is so common that my search was showing various solutions which were not applicable to me.
Demo – Azure SQL Database Managed Instance in action
(Jovan Popovic) Azure SQL Database Managed Instance is new data service in Azure cloud that exposes fully-managed SQL Server Instance that is hosted in Azure cloud and placed in customer VNET. Here you can see some of the key new features that are available in Managed Instance.
‘Failed to initialize deadlock control, Key cannot be null’ When Viewing Deadlock Graphs
(Michael J. Swart) I recently got this error in Management Studio when trying to view a deadlock graph that was collected with an extended events session:
