This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
A crimped interlocking seam beside a flat seam with separate edges

Checking Which Connections Use TDS 8.0 and Strict Encryption

July 14, 2013
Pinal Dave
SQL Tips and Tricks
SQL Connection, SQL Server, SQL Server Encryption

TRUE in encrypt_option does not mean strict mode. Here is how to read the protocol value on your server and what to test before you enforce anything.

Read More
A bowl of cracked walnuts with one sealed walnut and a red nutcracker beside it.

Finding Encrypted Stored Procedures Before a Migration

July 6, 2013
Pinal Dave
SQL Tips and Tricks
SQL Migration, SQL Server, SQL Server Encryption, SQL Stored Procedure

Inventory encrypted stored procedures and other modules before migration, then recover their approved source and dependencies.

Read More
A private path through a hedge to a red side gate, the front door shut

Connecting to SQL Server From Home Without Exposing Port 1433

June 2, 2013
Pinal Dave
SQL Tips and Tricks
Computer Network, SQL Connection, SQL Server, SQL Server Encryption, SQL Server Security

Keep port 1433 off the public internet by checking external reachability and using VPN, a jump host, Bastion, and trusted encryption.

Read More
A cloth-covered leather strip whose raised crease remains visible

Masked Values: What Dynamic Data Masking Does Not Hide

March 18, 2013
Pinal Dave
SQL Tips and Tricks
SQL Server, SQL Server Encryption, SQL Server Security

A masked column shows zeros, but a user with SELECT can still filter, sort and guess the real values. Here is the proof and the fix.

Read More
A packed crate of film cans on a doorstep, the projector with its red strap left behind.

Restoring a TDE Protected Database on Another Server

November 17, 2012
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Server, SQL Server Encryption, SQL Server Security

Restore a TDE protected database on another SQL Server by moving its certificate and private key, then verify encryption state.

Read More
A wooden drawbridge being lowered across a moat toward an open stone gateway

Connecting to SQL Server From Linux

December 4, 2011
Pinal Dave
SQL Tips and Tricks
Linux, SQL Connection, SQL Server, SQL Server Encryption, sqlcmd

Connecting to SQL Server from Linux requires the right Microsoft ODBC packages, a Kerberos plan, and certificate trust that matches the server name.

Read More
The cover of a book.

SQL SERVER – History of SQL Server Database Encryption

November 17, 2010
Pinal Dave
SQL Tips and Tricks
SQL PASS, SQL Server Encryption, SQLAuthority Book Review

Michael Coles, co-author of Expert SQL Server 2008 Encryption, let me share his history of SQL Server database encryption, starting from SQL Server 2000.

Read More
Previous 1 2 3 4 5 6 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com