(Thomas LaRock) Your database design is awful.

(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

(blobeater) Have you ever heard of SQL Reserved vCores? Well I never until recently.

(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.

(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.

(randomnote_1) In order to secure and harden SQL Server it is important to control who and/or what can authenticate to the system and what they have access to. This will satisfy regulatory needs such as the Secure Technical Implementation Guide (STIG).

(Kenneth Fisher) A while back I was given the advice Move your tabs (Object Explorer etc) to the right side of SSMS. Now I didn’t do it at the time, but recently I decided they were right and I should give it a shot.

(Chris Webb) When I read about the new conditional formatting by values feature in the August 2018 release of Power BI Desktop, my first thought was to write a blog post on how DAX can be used to generate the hex values for colours – but then Daniil Masyluk wrote an excellent post on that (and more

(Pinal Dave) The question such as this makes my day during the Comprehensive Database Performance Health Check. One of the DBA asked if there is an easy way to know if they have Instant File Initialization Enabled or Not for their server.

(Anoop Kumar) Data Warehouse (DW or DWH) is a central repository of organizational data, which stores integrated data from multiple sources. To develop and manage a centralized system requires lots of development effort and time.