(Thomas LaRock) Your database design is awful.
Community
Azure SQL Database high availability
(James Serra) In this blog I want to talk about how Azure SQL Database achieves high availability. One of the major benefits from moving from on-prem SQL Server to Azure SQL Database is how much easier it is to have high availability – no need for creating and managing a SQL Server failover cluster
SQL Reserved vCores
(blobeater) Have you ever heard of SQL Reserved vCores? Well I never until recently.
Speed Up Entity Framework Queries
(Srinath M S) Queries like the one below will perform more slowly than they could be run on a varchar column.
Serilog Tutorial for .NET Logging: 16 Best Practices and Tips
(Matt Watson) Serilog is a newer logging framework for .NET. It was built with structured logging in mind. It makes it easy to record custom object properties and even output your logs to JSON.
Get and Set Volume with JavaScript
(David Walsh) The and tags provide a wealth more functionality than most people know. For instance, did you know that you could detect supported video formats and audio formats using a few JavaScript tricks?
How flexible is your DB2 support team?
Flexibility is the name of the game when it comes to DB2 support. If a problem is going to happen you can bet your lunch money on it happening in the middle of the night on a Sunday when your most experienced DB2 DBA is on holiday.
Practical SQL: PREPARE, EXECUTE, and EXECUTE IMMEDIATE
(Joe Pluta) I’ve used various features of SQL for a long time, but the one that has always given me a little trouble is the PREPARE statement.
SQL SERVER – T-SQL Script: How to Search for Multiple Values in ERRORLOG?
(Pinal Dave) There are many situations where we need to apply filters in ERRORLOG to look at meaningful data. In this blog, we would learn how to search for multiple values in the SQL Server ERRORLOG file.
Database Maintenance and ColumnStore Indexes
(Denny Cherry) Recently on Twitter I saw a question about what index maintenance you should be doing on your ColumnStore Indexes when it comes to maintenance.