Debugging techniques (focusing on T-SQL)

• by Kenneth Fisher

• SQLStudies

tl;dr; Add PRINT and/or SELECT statements. Comment/uncomment out pieces of code to isolate problems. Change INSERT/UPDATE/DELETE statements to SELECTs. Disclaimer: ... Continue reading

2019-10-07 (first published: 2019-09-23)

775 reads

DBA Myths: CHECKDB runs on startup.

• by Kenneth Fisher

• SQLStudies

If you look at your error log you’ll (hopefully) see entries like this shortly after the instance startup: CHECKDB for ... Continue reading

2019-09-30 (first published: 2019-09-16)

556 reads

See SQL Run 2

• by Kenneth Fisher

• SQLStudies

Note: I am perfectly aware of my ability as an artist so let the ribbing begin ??

2019-09-30

17 reads

Blogging and coding best practices

• by Kenneth Fisher

• SQLStudies

I had a discussion a while back, I think it was with Grant Fritchey (b/t) but I just can’t remember. ... Continue reading

2019-09-25

15 reads

DMV with SQL Server Service info (including the service accounts)

• by Kenneth Fisher

• SQLStudies

I recently found this DMV and couldn’t wait to share. sys.dm_server_services What’s so great about it? For each service for ... Continue reading

2019-09-23 (first published: 2019-09-12)

695 reads

My fantasy SQL feature(s)? T-SQL Tuesday #118

• by Kenneth Fisher

• SQLStudies

It’s fantasy football time again? Oh, fantasy feature? Oh, yea, that makes a lot more sense for #tsql2sday. What’s #tsql2sday? ... Continue reading

2019-09-19 (first published: 2019-09-10)

507 reads

When using Powershell to control Azure the Cloud Shell doesn’t require an additional login.

• by Kenneth Fisher

• SQLStudies

When studying Azure one of the things you’ll be asked to learn is the Powershell commands that can control, well, ... Continue reading

2019-09-18

28 reads

Setting Trigger Order

• by Kenneth Fisher

• SQLStudies

If you can help it you probably shouldn’t be using triggers. But if you have to use a trigger you ... Continue reading

2019-09-09 (first published: 2019-08-26)

411 reads

When were the statistics last updated and how many rows were sampled?

• by Kenneth Fisher

• SQLStudies

TL;DR; Final query is at the bottom. Every now and again (particularly when someone is having performance problems) I’ll get ... Continue reading

2019-09-04

47 reads

SQL Homework – September 2019 – Getting the data in

• by Kenneth Fisher

• SQLStudies

Everything else aside two of the most important tasks of a database are to get data in, and get data ... Continue reading

2019-09-02

226 reads