Permissions Posters

I’ve been doing a lot of research recently for my permissions session and for a project at work. During said...

Indexes on GUIDs – Not Only Fragmentation

A client called us with the following issue:
He had a table of a few dozen million rows. The table had...

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