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 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 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
A hand pressing a signet ring into red sealing wax on a folded parcel, a candle and wax stick beside it

Connecting Java Applications With the JDBC Driver

March 13, 2010
Pinal Dave
SQL Tips and Tricks
Java, SQL Connection, SQL Server, SQL Server Encryption

Choose a current JDBC driver for SQL Server, verify its connection URL and encryption settings, and test integrated authentication on the app host.

Read More
Two rings of keys hang inside a cupboard door, one bright and new, the other old, tarnished and tied with string.

Rotating the TDE Certificate

October 3, 2009
Pinal Dave
SQL Tips and Tricks
DBA, SQL Backup and Restore, SQL Server Encryption, SQL Server Security

Rotating the TDE certificate protects recovery only when the new private key is backed up and old backups still restore.

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

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