Converting a Datetime to UTC
I was in a need of converting some datetime values (of which I know the actual timezone) to UTC dates. A quick Google search showed me that most results...
2020-09-28 (first published: 2020-09-22)
1,145 reads
Koen Verbeeck
- Twitter: @https://twitter.com/Ko_Ver
- Website: https://sqlkover.com/
- LinkedIn: https://www.linkedin.com/in/kverbeeck/
Optimize for Unknown for Inline Table-Valued Functions
I had a curious performance issue today. An inline table-valued function (iTVF) was performing poorly for some parameter sets, and quite fast for other parameter values. In short, this...
2020-09-24 (first published: 2020-09-17)
560 reads
Skip Validation of SSIS Packages
There’s been an update of the SSIS extension for Visual Studio 2019. There are some bug fixes and deployments are blocked to Azure-SSIS if the target server version is...
2020-09-10 (first published: 2020-09-02)
587 reads
Speaking at SQLSaturday Denmark 2020
I’m delighted to announce I’m speaking at the virtual SQLSaturday Denmark at the 26th of September 2020. I’ll be speaking about the cloud datawarehouse Snowflake and its integration with...
2020-09-09
14 reads
Speaking at DataMinds Connect 2020
I’m delighted to announce I’ll be speaking again at DataMinds Connect this year, one of the greatest and best Microsoft Data Platform conferences on the European mainland. Due to...
2020-08-04
10 reads
New Management Hub in Azure Data Factory
I wanted to manually start an Azure-SSIS Integration Runtime in ADF, so I went to the edit section and then to connections. But instead of showing me my linked...
2020-06-25 (first published: 2020-06-11)
281 reads
Cool Stuff in Snowflake – Part 12: IS DISTINCT FROM
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 share....
2020-05-13 (first published: 2020-04-29)
583 reads
Speaking at GroupBy Conference – Spring 2020
I’m excited to announce I’ll be speaking at the virtual GroupBy conference this year. Thanks everyone who voted! I’ll be speaking at the European day on May 12th at...
2020-05-06
13 reads
Switching between different Azure Data Factory environments
When working with Azure Data Factory, it’s possible you have multiple ADF environments. For example, you can have one for dev, one for test and one for production. Unfortunately,...
2020-04-21 (first published: 2020-04-08)
348 reads
Vote for GroupBy Conference May 2020
GroupBy is a virtual conference, for the community and by the community. Content is focused on the Microsoft Data Platform. Speakers can submit sessions for two events: GroupBy Europe...
2020-04-14
15 reads
Blogs
Query Intelligence in SQL Server 2025: What Developers Need to Know
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
Finding and Killing Blockers with Redgate AI Tech
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
Back at Small Data SF in 2025
By Steve Jones
Today I’m in San Francisco at Small Data SF 2025. I went to the...
Forums
Large posts full of code not allowed anymore?
Several times now, I've seen a post asking for a solution. I've replied, and...
Data > Hype
Comments posted to this topic are about the item Data > Hype
Create and Read the Analysis Services Flight Recorder
Comments posted to this topic are about the item Create and Read the Analysis...
Question of the Day
Slipstream parameters
What parameters are needed to enable a slipstream installation for setup.exe (SQL Server setup)?
See possible answers