(Kenneth Fisher) The other day I was asked to tune a stored procedure. Not exactly an uncommon task, but I worked something out in the process. I typically want to start by determining what the slowest part of the SP is.

(Pinal Dave) Here is a quick script which will help users to identify locked tables in the SQL Server.

(Tim Smith) We recently updated SQL Azure version 11 databases to version 12. After doing so, we noticed issues with point in time restores taking longer than they did in version 11.

(Tim Smith) We recently updated SQL Azure version 11 databases to version 12. After doing so, we noticed issues with point in time restores taking longer than they did in version 11.

(Pinal Dave) Here is the situation which my client explained and I was asked for help.

(Pinal Dave) Here is the situation which my client explained and I was asked for help.

(Robert Sheldon) What’s the best way of providing self-service business intelligence (BI) to data that is held in on-premise SQL Server? Not, it seems, Power BI 2.0 the hosted cloud service, but Power BI 2.0 Desktop. If moving your database to Azure isn’t an option, Power BI 2.0 desktop could still

(Kenneth Fisher) T-SQL Tuesday This T-SQL Tuesday we are hosted by one of the DBA’s of the night: Jen McCown (b/t). She want’s us to talk about Strategies for managing an enterprise.

(Carla Abanes) It’s time to apply SQL Server Service Pack 2 to your SQL 2012 instances. Normally the installation of SQL 2012 Service Pack 2 is pretty straightforward even for replicas involved in an Availability Group. But for your SQL Server 2012 instances that include Integration Services for yo

(Marcin Policht) In a recent article published on this forum, we have described an automated method of backing up user databases hosted on SQL Server instances running in Infrastructure-as-a-Service (IaaS) Azure virtual machines.