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 an encrypted database using Transparent Data Encryption (TDE), this post deals with a method of combining Page Compression with TDE and getting the best of both worlds. Transparent Data Encryption (TDE) feature encrypts data at rest i.e.… Read More »

Read more

SQL Cardiff

SQL Cardiff is a group dedicated to bringing it’s members more knowledge about SQL Server whether it’s straight database administration & development, business intelligence, or using it in scalable or cloud-based solutions. We have evening events every other month with two or three speakers on different topics, 6sq ft of pizza and plenty of opportunity to chat and network. The […]

Read more

SQL Midlands

We normally hold meetings every other month, after work in the centre of Birmingham, usually on a Thursday. It’s an informal gathering of like minded people, with a couple of speakers presenting tips, techniques and information on old, new and upcoming technology. We like to get a mixture of world leading speakers as well as providing an opportunity for our members […]

Read more

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 8.3; we covered theory in the post Tableau Kerberos Delegation to SQL Server / SSAS Part 1 – The Theory (Kerberos Tickets, Service Principal Names and Token Size) – make sure you have reviewed that before continuing… Read More »

Read more

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 or on the Server it directly connects to. For multi-tier Client/Server environments it’s more tricky because the user doesn’t authenticate directly with the target server perhaps not even able to connect because of firewall or routing constraints, the middle… Read More »

Read more
1 2