Getting table row counts with sp_Tablecount

• by davidfowler-42596

• SQL Undercover

Sometimes you just want to get a quick row count for a specific table – other times you may want to see a list of tables order by size...

2019-11-06 (first published: 2019-10-30)

887 reads

SQL Undercover TV – Using Excel to Visualise SQL Performance Data

• by davidfowler-42596

• SQL Undercover

Adrian looks at how you can use Excel to visualise SQL performance data, specifically data collected by the Blitz First Responder Kit

2019-11-05

75 reads

Undercover TV Podcast – Scripting Options in SSMS

• by davidfowler-42596

• SQL Undercover

In this episode of the podcast, Adrian looks at the scripting options available in SSMS.

2019-10-31 (first published: 2019-10-21)

399 reads

Availability Groups and Redo Latency, Data Committed on a Primary isn’t Visible on a Synchronous Secondary

• by davidfowler-42596

• SQL Undercover

If you’re running availability groups it may seem like a great idea to offload your read only reporting workloads to a secondary. There are a couple of ways that...

2019-10-28 (first published: 2019-10-16)

337 reads

Finding the Primary Replica of an Availability Group

• by davidfowler-42596

• SQL Undercover

This is going to be a bit of a quick post but one about something that I see coming up time and time again on SQL Undercover’s search terms....

2019-10-24

24 reads

Undercover TV Podcast – Intent Locks

• by davidfowler-42596

• SQL Undercover

The first of our new series of new look podcasts, David has a look at intent locks in SQL Server and what the purpose of them is.

2019-10-18 (first published: 2019-10-14)

177 reads

We Thought That Sean McCown’s SMO Tutorial Was So Good, It Needed To Be A Video In It’s Own Right

• by davidfowler-42596

• SQL Undercover

Back in February, Sean McCown joined us on the Undercover podcast and presented a brilliant tutorial on the SMO. We thought that it was so good that we’ve decided...

2019-10-01

33 reads

SQL Tuesday #118 – Your Fantasy SQL Feature

• by davidfowler-42596

• SQL Undercover

This month’s T-SQL Tuesday invitation comes from Kevin Chant and he’s asking us about a fantasy feature that we’d love to see in SQL Server. I had a little...

2019-09-09

14 reads

sp_RestoreScript 1.6 Release – @Credential Added For Backups In Azure BLOB Storage

• by davidfowler-42596

• SQL Undercover

Releases seem to be coming out thick and fast at the moment, here’s the latest v1.6 revision to sp_restorescript For those of you backing up to Azure BLOB Storage,...

2019-08-29

31 reads

Get All Database Snapshots and Their Parent Databases On A SQL Server

• by davidfowler-42596

• SQL Undercover

This is going to be a quick post but this morning I was asked the question, ‘how can I get the name of all the database snapshots on a...

2019-08-15

13 reads