Better Security with dbatools
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
2018-01-26
763 reads
A month of SSMS tips and tricks
Wayne’s Tips and Tricks for SSMS
SQL Server Management Studio (SSMS ) is a program that many just launch daily (or only...
2018-01-26
703 reads
Working with Comments (Day 26)
We all know that we should liberally document our code with comments, so that others (and even yourself) will know...
2018-01-26
390 reads
Javascript Postback Download via Powershell
Recently, one of my clients had a need to automatically download a file from a public facing state government website. ...
2018-01-26
128 reads
Javascript Postback Download via Powershell
Recently, one of my clients had a need to automatically download a file from a public facing state government website. ...
2018-01-26
1,145 reads
Encrypting an existing database with TDE
As mentioned previously, the process of setting up TDE (Setting up Transparent Data Encryption (TDE)) is the same whether you’ve...
2018-01-26
1,198 reads
Setting up Transparent Data Encryption (TDE)
You can set up Transparent Data Encryption (TDE) when you first create a database, or you can apply it to...
2018-01-26
2,681 reads
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
Blogs
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
Forums
Execute as failure
Security has long been a problem for me. Every time I think I understand...
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager
Comments posted to this topic are about the item How We Reduced SQL Server...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers