Category Archives: Microsoft SQL Server
-
SQL Homework – November 2019 – SSMS built in reports
1November 4, 2019 by Kenneth Fisher
Time for some homework again. I know Pass Summit is this week so you may be a bit busy but …
Continue reading -
That slippery slope
1October 30, 2019 by Kenneth Fisher
We need to have processes and rules. They are important to any business. That said, exceptions are also going to …
Continue reading -
Want to be more comfortable with the Extended Events Viewer?
2October 23, 2019 by Kenneth Fisher
I’ll admit, I’m a lot more comfortable with tracing and the profiler than I am with EE (extended events) and …
Continue reading -
#PowershellBasics: Multiple run spaces in ISE
2October 16, 2019 by Kenneth Fisher
As you know from the last few posts, I’m in a class on Powershell. One of the first things we …
Continue reading -
#PowershellBasics: The Windows Powershell icon in the task bar also lets you run Powershell ISE.
Leave a commentOctober 14, 2019 by Kenneth Fisher
I don’t know about you, but I like having the tools that I’m likely to use on my taskbar. That …
Continue reading -
Using 3rd party tools. T-SQL Tuesday #119
1October 8, 2019 by Kenneth Fisher
It’s that time again! Alex Yates (b/t) has asked us to discuss a time in tech when we’ve changed our …
Continue reading -
SQL Homework – October 2019 – Code review (self and peer)
1October 2, 2019 by Kenneth Fisher
Every database person I’ve ever met writes at least some code at some point in their career. That code might …
Continue reading -
See SQL Run 2
2September 30, 2019 by Kenneth Fisher
Note: I am perfectly aware of my ability as an artist so let the ribbing begin 🙂
-
Debugging techniques (focusing on T-SQL)
13September 23, 2019 by Kenneth Fisher
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 -
DBA Myths: CHECKDB runs on startup.
2September 16, 2019 by Kenneth Fisher
If you look at your error log you’ll (hopefully) see entries like this shortly after the instance startup: CHECKDB for …
Continue reading
SQL Studies 