-
Recent Posts
- T-SQL Cryptographic Patterns – part 6: a hole in the bucket
- T-SQL Cryptographic Patterns – part 5: running the gauntlet
- T-SQL Cryptographic Patterns – part 4: parts is parts
- T-SQL Cryptographic Patterns – part 3: Dog Food
- T-SQL Cryptographic Patterns – part 2: Hotel Juliet
- T-SQL Cryptographic Patterns – Part 1: hashed, scrambled or over easy?
- Throw FORMATMESSAGE() in the SQL Server 2012 Tool Bag
- Encrypting XML Typed Data in SQL Server
- Considering Cryptography in SQL Server Database Architectures
- Repel Dictionary Attacks With Checksum Truncation of The Random lambda
- Using Authenticity, Signing, Nesting in T-SQL to Protect Sensitive Data from (even) Highly Privileged Users
- Encryption Hierarchy Administration – a T-SQL Template
- The Emperor’s New Transparent Data Encryption
- Protecting Sensitive Data at Rest in SQL Azure
- Persisting Data: part 9 – A Modest Data Collection Proposal
- Implicit conversions will find you
- Persisting Data – part 8: Concurrent Persistence Processing
- Persisting Data – part 7: Concurrency and Deadlocking
- Persisting Data – part 6: TVPs are for SSISies
- Persisting Data – part 5: Concurrency and Locking
- Persisting Data – part 4: Upsert and MERGE
- Persisting Data – part 3: Rows, Sets and Files
- Persisting Data – part 2: The Un-Indexed Heap
- Persisting Data – part 1: The “impedance mismatch”
- Monitoring the Default Trace
Monthly Archives: November 2010
Persisting Data – part 2: The Un-Indexed Heap
A heap is a table with no clustered index. The performance and throughput advantages of targeting an un-indexed heap structure when loading multiple rows of data into SQL Server can be fantastic. That does not shed much light on how … Continue reading
Persisting Data – part 1: The “impedance mismatch”
This post is an introduction to a few posts to follow that will describe a testing methodology for designing optimized database synchronization protocols. Synchronization is the operation of persisting data changes at the application layers to the database. The methodology … Continue reading
Monitoring the Default Trace
There is a trace enabled and always running on every SQL 2005/2008 instance by default? … ! “Default trace provides troubleshooting assistance to database administrators by ensuring that they have the log data necessary to diagnose problems the first time … Continue reading
