SQL Homework – March 2020 – Database Configurations.
A little while back we tried configuring the instance. Sometimes though, instance settings are a bit heavy handed, so this ... Continue reading
2020-03-05 (first published: 2020-03-02)
475 reads
SQL Server Agent for Azure SQL DB?
I always wanted a way to schedule commands within Azure SQL Database. Personally, for me, the go to standard is the functionality of SQL Server Agent. Obviously, this is...
2020-03-02
53 reads
Undercover Tools: February Updates and Change Log
Below is the February list of changes and updates to the Undercover Tools. Undercover Catalogue Update 0.4.2Two new modules were added to the Catalogue. Trace Flags – Capture trace...
2020-03-02
37 reads
Why can’t I remove this extra transaction log file?
Before this post gets started, let’s get past the title. I know what many of you are thinking: what in the name of Paul Randal would make someone have...
2020-02-29
17 reads
Why can’t I remove this extra transaction log file?
Before this post gets started, let’s get past the title. I know what many of you are thinking: what in the name of Paul Randal would make someone have...
2020-03-05 (first published: 2020-02-29)
427 reads
Reviewing 2019 Career Goals
According to this post, I rate 2019 as a Failure. Of the books I planned to read, I read 2. I started 2 others, but they’re in progress, even...
2020-02-28
179 reads
ASF 029: Tomaz Kastrun interview
Introduction Tomaž Kastrun is BI & DEV developer, data analyst & data science. With more than 15 years of experiences in the field of databases, business warehouses and development,...
2020-02-28
22 reads
ASF 029: Tomaz Kastrun interview
Introduction Tomaž Kastrun is BI & DEV developer, data analyst & data science. With more than 15 years of experiences in the field of databases, business warehouses and development,...
2020-03-06 (first published: 2020-02-28)
167 reads
Schema Filtering in SQL Prompt
I love SQL Prompt, and I’m regularly impressed by the enhancements our teams continue to make in the product. One item that I found interesting recently was schema filtering....
2020-03-04 (first published: 2020-02-27)
268 reads
Information Measurement with SQL Server Part 4.8: The Intersection Family of Distances
By Steve Bolton …………Each group of distance measures surveyed in this segment of the series was defined by affinities between the underlying equations. For example, the common denominator for...
2020-03-04 (first published: 2020-02-27)
323 reads
Blogs
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
My PASS Summit West 2026
Comments posted to this topic are about the item My PASS Summit West 2026
Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server
Comments posted to this topic are about the item Packing and Decoding Device Status...
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers