SQL Server Datumsfunktionen Probleme - Date Functions Errors Solutions - black marker on notebook
|

The Biggest Problems with SQL Date Functions and How to Solve Them

Introduction Date functions in SQL are powerful tools, but they are also one of the most common sources of errors in database queries and applications. Database administrators (DBAs) and developers frequently encounter issues with processing, storing, and converting date values. These problems often lead to inconsistent results, performance issues, or even data loss. In this…

wichtiger Hinweis zum SQL Server oder Microsoft Data Platform
|

SQL Server 2019 is out of mainstream support – now what?

In case you missed it: As of February 28, 2025, SQL Server 2019 is no longer in mainstream support. That means no more functional updates or performance improvements – just security patches. If you’re still running SQL Server 2019, here’s what you need to keep in mind. What does this mean for you? No need…

Microsoft Learn - Image
|

Microsoft SQLPackage: Exciting innovations for data management and provisioning

There’s exciting news from Microsoft that specifically affects data management and provisioning. The SQLPackage tool, already indispensable to many of us, has received an impressive update. With preview support for extracting and publishing data stored in Parquet files in Azure Blob Storage, it opens up a new world of possibilities for managing data in Azure…

Photo by Marten Newhall on Unsplash - https://unsplash.com/@laughayette
|

SQL Server Patching – server won’t start

At times, specific topics come together simultaneously. In this case, several emails were received from the Data Platform MVP distribution list, and various customer reports and suitable posts in other blogs were found on “how DatabaseMailUserRole stops your patching,” so a German contribution was made to this. It’s about a bug that has appeared in…

Azure Arc-enabled Data Services – Cloud Summit 2021
|

Azure Arc-enabled Data Services – Cloud Summit 2021

Yesterday, I had the opportunity to speak at the Cloud Summit, an international community event, about Azure Arc-enabled Data Services. Specifically, I focused on operating an Azure SQL Managed Instance in your data center. As I previously did at DataSaturday #14 in Oslo, I began my presentation by discussing the various options of Azure Arc….

Azure Arc Data Services - Data Saturday #14 - Oslo 2021
| |

Data Saturday #14 – Oslo 2021 – Introduction into Azure Arc Data Services

Today the time had come – I was finally able to speak at Data Saturday (formerly SQLSaturday) in Oslo … that was finally not due to the organizers but rather to me or the pandemic, since I hadn’t dared to give lectures until 2020 Keeping English, I hadn’t submitted any sessions for Oslo either. I…