SQLCover Code Coverage for SQL Server T-SQL

Open Source code coverage tool for T-SQL, SQL Server 2008+
What is code coverage? Code coverage is a way to see how many statements in your database code have been...

SQLCover Code Coverage for SQL Server T-SQL

Open Source code coverage tool for T-SQL, SQL Server 2008+
What is code coverage? Code coverage is a way to see...

Using PowerShell to set Extended Events Sessions to AutoStart

When you look after more than a few SQL Servers you will need to perform the same actions against a...

Utility function: dbo.JobName(@job_id)

As often as I have to pull a job’s name based on its job_id in the MSDB system tables, I’m truly...

VMware CPU Co-Stop and SQL Server Performance (continued)

A number of you sent me some excellent questions about this topic, and my favorite asked me for the query...

Win a SQLBits Pass

You can win a free conference pass to SQL Bits, in Liverpool, May 4-7. It’s easy, just post a review...

All about Searching - Full-Text Indexes

SQL server has the capability to store text-based data in the form of char, varchar, nchar, nvarchar, text, ntext, image,...

Announcement: Backup(n.) vs Back Up(v.)

Let it be known that the word “backup” is a noun (it refers to a thing), and “back up” is a verb (it...

Cloud Backup - Directly to Azure

Backup is one of the major task for DBAs, it has many different options and ways for each companies to...

FIND OBJECTS BEING REFERRED BY SSRS REPORT

Hi Everyone

In the daily team meeting today, we had a requirement to find out the stored procedure used/referenced by SSRS...