What’s in the pipeline for Power BI?
If you’re interested in Power BI (or the Power platform in general), you might be interested in checking out the release overview guides of “2019 release wave 2” for...
2019-09-02
10 reads
Koen Verbeeck
The Azure-SSIS IR Startup Time
If you want to run SSIS packages in Azure Data Factory, you need the Azure SSIS Integration Runtime (quite the mouthful), which is basically a cluster of virtual machines...
2019-07-09 (first published: 2019-06-19)
361 reads
Cool Stuff in Snowflake – Part 9: ILIKE
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to...
2019-07-02 (first published: 2019-06-18)
629 reads
SQL Server Development Best Practices – Webinar
I’m delighted to announce I’ll be giving a webinar for MSSQLTips.com about SQL Server Development Best Practices. Aka writing T-SQL and stuff ?? The webcast is the 13th of...
2019-05-27
43 reads
Migrating SSIS to Azure – Slidedeck (Techorama 2019)
Techorama 2019 is over and it was a blast, as usual. Neatly organised, great speakers and fantastic content. I delivered a session on Migrating SSIS to Azure (Data Factory)....
2019-05-25
46 reads
SSIS 2019 has arrived!
It is not a joke: SSIS is available for Visual Studio 2019 as a preview. Whoa, hold on. SQL Server 2019 hasn’t been released yet? But there’s already an...
2019-04-25
3,770 reads
Cool Stuff in Snowflake – Part 8: Time Travel
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to...
2019-04-23 (first published: 2019-04-15)
870 reads
SSIS and Data Quality Webcast
On Thursday the 2nd of May, I’ll be giving a webcast for MSSQLTips.com about data quality and SSIS. The abstract: SQL Server Integration Services (SSIS) has been around for...
2019-04-10
30 reads
Speaking at Techorama 2019
I’m delighted to announce I’ll be giving a talk at Techorama 2019. It’s one of the best events I’ve ever been to and I’ll be in the good company...
2019-03-04
27 reads
Cool Stuff in Snowflake – Part 7: Creating Tables
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough...
2019-02-26
96 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