SQLFAQ Home

Who did what to my database and when…

One of the most popular questions on forums / SO etc is, “How can i find out who dropped a ...
Read More
/ by

SQL Server – Making Backup Compression work with Transparent Data Encryption by using Page Compression

Encrypted data does not compress well if at all so using the BACKUP with COMPRESSION feature will be ineffective on ...
Read More
/ by

Why is creating excel sheets from SSIS so hard ?

If there is one process that should be simpler than it is out of the box, it is creating Excel ...
Read More
/ by

Tableau Kerberos Delegation to SQL Server / SSAS – Part 2 – Setting it up

The ability to use Kerberos delegation against SQL Server and SQL Server Analysis Services (SSAS) was introduced in Tableau Server ...
Read More
/ by

Tableau Kerberos Delegation to SQL Server / SSAS – Part 1 – The Theory (Kerberos Tickets, Service Principal Names and Token Size)

Active Directory is by default geared to a two tier Client/Server architecture, the Client can only use resources either locally ...
Read More
/ by

IT Community Roadshow – Real-world stories and demos from local community experts – May 2016

The IT Community Roadshow is a series of free training events focusing on next-generation technologies including Microsoft Azure, Windows 10, ...
Read More
/ by

.Net 4.6.1 and MultiSubnetFailover

Im not a big clustering/HA expert, but I obviously understand the need for such things to exist However, the standard ...
Read More
/ by

A journey to a movie recommender in U-SQL

I haven’t gotten to involved in the whole “Big Data” movement to much, I’ve kept an arms length watch and ...
Read More
/ by

A first look at SQL Server 2016–String_split

I’ve been developing T-SQL for about 20 years now and almost since day one there has been functionality that , ...
Read More
/ by

Transaction Log Concepts – Part 2: Full Database Backups and Mirroring/Availability Groups

In Transaction Log Concepts – Part 1: ACID, Write Ahead Logging, Structure of the Log (VLF’s) and the Checkpoint/Lazywriter/Eagerwriter process ...
Read More
/ by
« Sep 2016 » loading...
MTWTFSS
29
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2