Without Borders – Getting Involved

One of the things I enjoy about the SQL community is the many people that you come into contact with....

A simple way for consistency TIP #106

 
Whenever we develop application of maintain application we define sets of rules or policies  like naming convention , data type, database...

SQL Server 2016 Blogs

Hi friends, As you all know that SQL Server CTP2 has released with new great features. Here is the list of...

Transparent Data Encryption in Azure SQL Database

Transparent Data Encryption in Azure SQL Database
JULY 26, 2015

IntroductionTransparent Data Encryption (TDE) is a security feature of SQL Server that has been around since SQL Server 2008. With TDE,...

Transparent Data Encryption in Azure SQL Database

Transparent Data Encryption in Azure SQL DatabaseJULY 26, 2015
Introduction
Transparent Data Encryption (TDE) is a security feature of SQL Server that...

Change in sys.dm_exec_query_stats in SQL Server 2016

Sys.dm_exec_query_stats is most commonly used DMO used by DBA and developers to find out the information about queries involving query...

Security-Fixes for SQL Server and why Security Best Practices Matter / Sicherheitsfixe für SQL Server und warum Sicherheits Best Practices wichtig sind (MS15-058 SQL Server Security Bulletin)

Ziemlich genau ein Jahr nachdem die für 5 Jahre ersten Sicherheits-Bugs in SQL Server gefixt werden mussten, gibt es nun,...

013 – The Start of Something Big! - WaterOx Consulting

Together we can make a difference in the data world! In WOxPod!,...
The post 013 – The Start of Something Big! appeared...

Boost your OLTP database performance with SQL Server 2014 in-memory tables

Today we can already say with certainty that the most striking innovation in the MS SQL 2014 is the In-MemoryOLTP. In-Memory...

Columnstore Indexes at PASS Performance Palooza: Recording and Materials

Yesterday I participated in PASS Performance Palooza.
I had a lot of fun delivering my session Columnstore Indexes – Questions and Answers.
The...