Learn how to unit test SQL Server T-SQL code
A free email course on how to use tSQLt including the technical aspects of writing unit tests AND the art...
2017-09-05
66 reads
Learn how to unit test SQL Server T-SQL code
A free email course on how to use tSQLt including the technical aspects of writing unit tests AND the art of writing repeatable, using unit tests for even the...
2017-09-05
7 reads
SSIS ForEach Enumerator File Order
I saw on slack recently a question about how the ssis file enumeraror orders (or more specifically doesn’t order) files....
2017-09-04
76 reads
SSIS ForEach Enumerator File Order
I saw on slack recently a question about how the ssis file enumeraror orders (or more specifically doesn’t order) files....
2017-09-04
71 reads
14 years of Summit…
I have been trying to get my blogging going again after a gap of two months. It has been incredibly...
2017-09-04
514 reads
SSIS ForEach Enumerator File Order
I saw on slack recently a question about how the ssis file enumeraror orders (or more specifically doesn't order) files. I have been thinking about ssis quite a lot...
2017-09-04
17 reads
SQLCLR vs. SQL Server 2017, Part 5: “Trusted Assemblies” – Valid Use Cases?
In the previous post in this series on SQLCLR in SQL Server 2017 — Part 4: “Trusted Assemblies” — The Disappointment — we...
2017-09-04
426 reads
Working with the registry in SQL Server – adding trace flags to startup parameters
In a recent post, I introduced you to how to work with the registry directly from within SQL Server. Continuing...
2017-09-04
776 reads
A Trip Across the Pond for the Community Hub
The Redgate Community Hub is out, and people are starting to use it. It’s a an idea that we think...
2017-09-04
797 reads
DBCC CHECKDB Azure SQL Database
Who should be running DBCC CHECKDB for Azure SQL Database? Should it be Microsoft or should customers be scheduling it?...
2017-09-04
761 reads
Blogs
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...
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....
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers