Doing a Full Outer Join in Power Query
A while back a give a session at the element61 Microsoft Business Analytics Day, a free event where the capabilities...
2015-07-09 (first published: 2015-07-02)
3,708 reads
Blog Posts
Introduction To Dynamic Data Masking in SQL Server 2016
In release of SQL Server 2016 CTP 2.0 another new feature that is released is Dynamic Data Masking. Using Dynamic...
2015-07-09
599 reads
Overview of Published Articles – 2015Q2
Here is an overview of the articles I published in the secondt quarter of 2015.
INTENSE SCHOOL
Book Review: Query Tuning & Optimization by...
2015-07-09
529 reads
Podcast about my career and the SQL Server Community with Chris Bell
During my time at SQL Saturday in Philadelphia (Early June), Chris Bell invited me to be a guest on his...
2015-07-09
665 reads
Proper Aliasing will help you somewhere TIP#104
Recently, When we were delivering session on “SQL SERVER” one of the persons asked why we require Aliasing so I...
2015-07-09
460 reads
SQL Server Storage best practices
Server storage is one of the most important things for SQL Server performance. Chances to utilize a lot of RAM and...
2015-07-09
3,458 reads
Why I won’t be running SQL Server Standard Edition on Business Critical Servers!
I keep getting questions around what core features are missing in Standard Edition of SQL Server,and why there is a...
2015-07-09
1,151 reads
Database Settings Changes – Red Handed
One of my pet-peeves (and consequently frequent topic of discussion) is finding database settings (or any setting that has changed) without knowing about it. Worse yet is finding that...
2015-07-08
15 reads
Database Settings Changes – Red Handed
One of my pet-peeves (and consequently frequent topic of discussion) is finding database settings (or any setting that has changed)...
2015-07-08
634 reads
Get a comma separated list
I’m writing this post as a way to help motivate the #SQLNewBloggers out there. Read the bottom for a few...
2015-07-08
3,606 reads
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers