Blog Posts

Azure Databricks to Power BI

• by Arun Sirpal

• All About SQL

A very common approach is to query data straight from Databricks via Power BI. For this you need Databricks token and the JDBC address URL. This is found within...

2020-10-20

9 reads

Azure SQL Database Elasticity – Presentation Notes

• by DataOnWheels

• DataOnWheels

This blog covers the content and points to the code used to create the demos in my Azure SQL Database Elasticity presentations. As of today, I have presented this...

2020-10-20

13 reads

Daily Coping 20 Oct 2020

• by Steve Jones

• The Voice of the DBA

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

2020-10-20

5 reads

How To: Create Schema Only Database Copies

• by gbargsley

• GarryBargsley

Have you ever been asked to make a schema only copy of a database? What is your preferred method to complete this request? Below we will discuss how to...

2020-10-20

127 reads

My 800th post!

• by Kenneth Fisher

• SQLStudies

It took me a little bit longer to get here than I expected but I finally made it. 800 posts. ... Continue reading

2020-10-20

1 reads

QDS Forced Plans - Gotchas and Limitations

• by cjsommer

• cjsommer.com

Released with SQL Server 2016, Query Data Store was a game changer for performance tuning. Right from Microsoft’s website: The SQL Server Query Store feature provides you with...

2020-10-20 (first published: 2020-10-13)

230 reads

Solve SQL Server Resource Database Crash

• by Mustafa Elmasry

• DB Cloud Tech

Based on Microsoft Documentation <The Resource database is a read-only database that contains all the system objects that are included with SQL Server. SQL Server system objects, such as...

2020-10-20

63 reads

Azure DevOps–Reconfiguring an Agent

• by Steve Jones

• The Voice of the DBA

This post looks at how to re-configure a local Azure DevOps agent when you need to change to a new pool or organization. PAT Expired I got a note...

2020-10-19

44 reads

Daily Coping 19 Oct 2020

• by Steve Jones

• The Voice of the DBA

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

2020-10-19

9 reads

Most Costly Statement in a Stored Procedure

• by Grant Fritchey

• The Scary DBA

A lot of stored procedures have multiple statements and determining the most costly statement in a given proc is a very common task. After all, you want to focus...

2020-10-19 (first published: 2020-10-12)

787 reads