This is the first of a series of posts where I cover common Interview questions in MS SQL Server in detail. Why? Some questions are not framed properly […]
Chinese Hackers(Cracker) and Azure, have I hit the bigtime??
I have a website hosted on Azure which I use for my trainings. Today I received a number of alerts from Azure showing High CPU usage for the […]
Session State request to session state server
Problem Unable to make the session state request to the session state server. Please ensure that the ASP.NET State service is started and that the client and server […]
SQL 2016 – Always encrypted
Here I try to summarize a lot of the information available on the MSDN website for the Always Encrypted feature being launched in SQL 2016. The primary concept […]
SQL 2016 – Setting up Always Encrypted
A quick Step by step guide on setting up always encrypted on the server as well as the client, and a quick approach on migrating existing tables to […]
Setting up Integrated Security / Windows Authentication with Azure SQL Databases
In this lengthy post I explain how to setup Azure AD Authenticated users such that they may be used to connect to SQL Database hosted in Azure. Users […]
VM and IP Configurations
Recently there was a post on DB mirroring not working on a VM, in the post I had suggested checking the network connectivity and NIC configurations in the […]
SQL 2016 – Dynamic Data Mask –& Hacking the feature
After working with PHI for many years now, I can appreciate the importance of data masking. While normally the first approach is to encrypt the data it is […]
SQL 2016 -Row level security misuse: – Visual Totals in SSAS
Ever since I heard of Row level security I have been wanting to try it out. Not the usual stuff that I was sure MS would have already […]
Security: Capturing additional login information Trace vs Audit
Recently on a popular SQL Server forum as well as commonly during my trainings people ask about how to get additional security information about logins. Most often the […]