Single value filters and custom error messages in Power BI

"Let me be the one for you, otherwise we need to work on communication". Basically this was a very brief...

Database Mail shutting down. Mail queue has been stopped.

DB mail in our production servers started acting up last week. We have SQL Server 2012 SP1. There were a couple...

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...

Community Reactions to Power BI General Availability

Power BI is released to the public on Friday, 07/24. There’re both free and Pro versions. For full details about...

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...

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...

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,...

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...

MDW Data Collector – Collection Set jobs not working

ERROR :
Error Message 1 :
Executed as user: Domain\UserName. SSIS error. Component name: DFT – Upload collection snapshot, Code: -1071636372, Subcomponent: RFS...