What is Transparent Data Encryption?
Transparent Data Encryption (TDE) was introduced in SQL 2008 as a way of protecting “at rest” data. It continues to...
2018-02-07 (first published: 2018-01-26)
2,184 reads
Friday Reading 2018-01-26
It’s moving weekend! Hopefully two hard days and then I’ll be all settled in my new place. Cannot wait.
Inbetween packing...
2018-01-26
259 reads
Information Measurement with SQL Server, Part 2.5: Mutual, Lautum and Shared Information
By Steve Bolton
…………The sample T-SQL I posted in the last article wasn’t as difficult as it looked, considering that it...
2018-02-06 (first published: 2018-01-25)
1,154 reads
Guest Post at Pure Storage – VVols and SQL Server are a Game Changer
I’m thrilled to have contributed a blog post on how SQL Servers, VVols, and Pure Storage’s unique implementation of VVols...
2018-01-25
364 reads
Using the SSMS Web Browser (Day 25)
One of the things that I do with my code is to include reference links to what I was doing...
2018-01-25
311 reads
Using the SSMS Web Browser (Day 25)
One of the things that I do with my code is to include reference links to what I was doing...
2018-01-25
371 reads
Advent of Code 2017 Day 5–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-01-25
942 reads
How to write a PowerShell function to use Confirm, Verbose and WhatIf
In my last blog post I showed how to run a script with the WhatIf parameter. This assumes that the...
2018-02-05 (first published: 2018-01-25)
1,599 reads
Session Materials – Biml DataMinds
All of the materials for my Biml session for DataMinds.be can be downloaded from Github:
the slidedeck (it’s only 12MB :))a...
2018-01-25
345 reads
Extended Event Packages
I continue blogging on extended events. Today, I will discuss about the top level containers (Package) that gives access to...
2018-01-25
509 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers