(Allan Hirt) I was working on some things this past weekend for a few upcoming projects, and one of those involves Azure and automation.

(Denny Cherry) There are people out there that reboot SQL Servers (or all servers) weekly. Usually the argument that I hear for doing this is that SQL Server has memory leaks which can only be resolved by rebooting Windows.

(Ranga Babu) In our environment we use SQL Server merge replication to replicate data to multiple subscribers. We had a situation where a table needs to be part of merge replication and the table has more than 246 columns.

(Pinal Dave) Once there was an urgent request from my client and they asked my assistance. Without wasting any time, I sent them GoToMeeting invite and started working. In this blog we would learn how to fix FCB:: Open failed for TempDB database.

(Chris Webb) The new Relationships view (or Modeling view – it seems to have two names) in Power BI Desktop that has been in preview since November 2018 not only makes it easier to work with complex models and set properties more easily, it also exposes a brand new property on a column: the “Is null

(Bob Dorr) SQL Server 2017 introduced a small change to SQL Server’s default worker thread calculation, accounting for smaller environments.

(Hannes Du Preez) There are two ways to prevent your SQL code from running on a testing or production server.

(Kenneth Fisher) The thing about DBA Myths is that they are generally widespread and widely believed.

(Daniel Janik) It’s taken longer than I thought it may and I’ve run into several problems along the way but had a few people in the MVP community swing some homeruns to help me complete the BETA of this new SQL Server community query tuning tool.

(Pinal Dave) My primary responsibility is to help people with SQL Server Performance Tuning and Optimization, and I believe there are three important challenges any DBA faces.