How Serverless is Working in Azure SQL Database
When Azure SQL Database introduced the serverless option, I decided to try it. I moved one of my databases to the tier, though I had to move to a...
2019-12-10 (first published: 2019-11-27)
1,053 reads
The Voice of the DBA
Cleaning up the [NOT] NULL for Columns with SQL Prompt 10
SQL Prompt 10 is out and there are a few interesting things that have changed in the product. One of these is the Quick Fixes, inspired by some other...
2019-12-06 (first published: 2019-11-25)
416 reads
Data Masker Reads Column Classificiations
One of the newer features in Data Masker for SQL Server is the ability to read column classifications and suggest rules to clean the data. I decided to give...
2019-12-02 (first published: 2019-11-22)
273 reads
Setting Certificate Backup Permissions for an Instance–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Recently I was testing some security change, and...
2019-11-20
123 reads
Getting Started with SQL Prompt 10
This week we released SQL Prompt 10, which is an exciting milestone for us. I remember when I discovered this little gem for Database Weekly and sent it over...
2019-11-15
133 reads
Batch Scripting SQLCMD–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I wouldn’t do this anymore, but I ran...
2019-11-22 (first published: 2019-11-13)
427 reads
New HA Licensing Benefits
Microsoft announced recently that they were changing the way licensing works for HA and DR situations. I think this is a great change, and the summary is: You can...
2019-11-11
43 reads
Focusing on Business Value
This was a fun talk with David Atkinson at Redgate. We talk satellites, finance, and more. Including some early history of the company. We are talking about how to...
2019-11-14 (first published: 2019-11-08)
239 reads
Voting for the PASS Board
Voting is open for the PASS Board, as of yesterday (Nov 6). The candidate page is up, and there are 6 amazing candidates for 3 slots. They are: Chris...
2019-11-07
74 reads
Powerhell Notebooks in ADS–A Minor Issue
I heard about the addition of PoSh as a kernel for notebooks in Azure Data Studio. This is in the November 2019 release, and you can download/upgrade today to...
2019-11-06
45 reads
Blogs
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...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Alamat Kantor BCA KCU Sidoarjo Tlp:(08218200203)
Hub Via Wa:628218200203 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo,...
Alamat Kantor BCA KCU Diponegoro Tlp:(08218200233)
Hub Via Wa:628218200233 Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241
Alamat Kantor BCA KCU Indrapura Tlp:08218200174
Hub Via Wa:628218200174 Jl. Indrapura No.35, Kemayoran, Kec. Krembangan, Surabaya, Jawa Timur 60176
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