New Row

For me as a DBA one of the interesting new features in SQL Server 2022 is the support for Intel QAT compression with backups with compression algorithm QAT Deflate. Backup and Restore are bread and butter things for us DBAs. Unfortunately as time goes by and database size increases backup processes tend to run longer and longer. As these are small changes over longer time frames it typically is difficult to observe till you wake up one morning….production is not…

Read More Read More

I am currently volunteering as an instructor to teach young women about Data & SQL. Right in the first module we covered core data types as shown here: For this blog post I’d like to write about FLOAT and DECIMAL and why in most cases I think that DECIMAL is a much better choice. Approximate values According to the MySQL documentation float (and double) represent approximate numeric data values This is the reason where the general problem comes from. But…

Read More Read More

This is my contribution to TSQL Tuesday #99: Dealer’s Choice hosted by Aaron Bertrand this month. I choose door #2 to write about T-SQL bad habits. One thing that comes to my mind immediately is how to handle id columns and which data type to choose. First of all: I don’t think there is any one-size-fits-all-approach you could use without thinking twice. My experience is based on working for a mid-sized business with fairly small sized tables which rarely have…

Read More Read More