(Chris Webb) Now that we can apply custom format strings to fields and measures in Power BI in the September 2019 release, I thought it would be useful to provide some examples of what’s possible with this very flexible new feature because the existing documentation for VBA isn’t easy to make sense

(Kenneth Fisher) If you look at your error log you’ll (hopefully) see entries like this shortly after the instance startup:

When using SSMS the query window is usually made up of the Editor on the top half and after you execute code, the Results are displayed on the bottom half. The problem with this is that if you need to modify the code in the Editor section the display is limited because the results pane takes up the

(Pinal Dave) Long-running queries are always trouble for many of us. During my Comprehensive Database Performance Health Check, the very last step is to help with long-running queries.

(Chris Webb) In Shabnam Watson’s recent blog post on a bug she found when trying to create a Live connection from Power BI to Analysis Services she mentioned that the AutoSetDefaultInitialCatalog server property could be used to solve her problem.

(Pablo Echeverria) For compliance auditing, a customer asked for a list of users who have read or write access in any database on the SQL Server instance. Although there are several tables that can provide us the information, the permissions can be at the instance level or at the individual database

(Pinal Dave) My favorite part of Comprehensive Database Performance Health Check is to resolve slow issues which are often very complicated to resolve. Recently I was hired for a specific task where my client had a very important query running usually in just subsecond, running for over 60 seconds o

(Grant Fritchey) While the CROSS JOIN is not used much, and, depending on the size of your data it can be dangerous, there are some uses for it.

(Rick Dobson) As a beginning SQL Server Developer DBA, I recently became comfortable placing T-SQL scripts into a stored procedure template to make the code from a script easily re-usable.

(Jack Vamvas) Question: I received an alert for a regular backup failure . A closer inspection of the sql server agent error logs displayed this error message: