Tags » SQL Authority

SQL SERVER - Difference Between Read Committed Snapshot and Snapshot Isolation Level

It is quite common that when a new feature gets introduced, there is a lot of talk about them. Sometimes even the old capabilities are lesser known because they can be used interchangeably in conversations. 644 more words

SQL Authority

SQL SERVER - Why Haven’t You Disabled CPU Power Saving Yet?! - Notes from the Field #087

: This is an 87th episode of Notes from the Field series. Every week, I personally wait for the notes from the fields from Mike because it contains lessons of life which directly impacts DBA and Developer’s life positively. 723 more words

SQL Authority

SQL SERVER - Steps to Generate Windows Cluster Log?

Every now and then I sit next to DBA to learn some of their tricks. One of this recent learning is what I plan to share here. 509 more words

SQL Authority

SQL SERVER - Knowing the Source Application Using APP_NAME() Function

APP_NAME() function in SQL Server returns the application name of the current session in which it is called.

When you execute the following code

SELECT APP_NAME() AS application_name… 121 more words

SQL Authority

SQL SERVER - Getting started and creating JSON using SQL Server 2016

With SQL Server 2016 CTP out, I know many have started to play around with it and exploring some of the new capabilities. One of the new capabilities that has caught my attention is the introduction of JSON support. 476 more words

SQL Authority

Interview Question of the Week #026 - 64 Bit Vs 32 Bit Confusion

I often see people getting lost between 64 bit and 32 bit operating systems and application conversation. There are plenty of individuals still today, not sure what is the difference between them as well what runs on what platform. 102 more words

SQL Authority

SQL Server - 2016 - New Feature: Dynamic Data Masking

As most of you know that latest update from Microsoft about SQL Server 2016 was released of CTP2.1 version. There is a long list of new features getting introduced in SQL Server 2016. 560 more words

SQL Authority