SQLStudies

SQL Homework – November 2019 – SSMS built in reports

• by Kenneth Fisher

• SQLStudies

Time for some homework again. I know Pass Summit is this week so you may be a bit busy but ... Continue reading

2019-11-04

24 reads

That slippery slope

• by Kenneth Fisher

• SQLStudies

We need to have processes and rules. They are important to any business. That said, exceptions are also going to ... Continue reading

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

384 reads

#PowershellBasics: The GetType() and GetTypeCode() methods

• by Kenneth Fisher

• SQLStudies

I’m a DBA. Data types are kind of important to me. I mean I know they are important to developers ... Continue reading

2019-10-28

56 reads

Want to be more comfortable with the Extended Events Viewer?

• by Kenneth Fisher

• SQLStudies

I’ll admit, I’m a lot more comfortable with tracing and the profiler than I am with EE (extended events) and ... Continue reading

2019-10-23

334 reads

#PowershellBasics: Get-Help -Online

• by Kenneth Fisher

• SQLStudies

One of the other things I learned from the Powershell class I’m taking this week is that there is an ... Continue reading

2019-11-01 (first published: 2019-10-21)

445 reads

#PowershellBasics: Multiple run spaces in ISE

• by Kenneth Fisher

• SQLStudies

As you know from the last few posts, I’m in a class on Powershell. One of the first things we ... Continue reading

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

394 reads

#PowershellBasics: The Windows Powershell icon in the task bar also lets you run Powershell ISE.

• by Kenneth Fisher

• SQLStudies

I don’t know about you, but I like having the tools that I’m likely to use on my taskbar. That ... Continue reading

2019-10-14

22 reads

#PowershellBasics: Powershell vs Powershell Core

• by Kenneth Fisher

• SQLStudies

I’m taking a Powershell class this week and I have to say the teacher is one of the best I’ve ... Continue reading

2019-10-10

278 reads

Using 3rd party tools. T-SQL Tuesday #119

• by Kenneth Fisher

• SQLStudies

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

2019-10-11 (first published: 2019-10-08)

441 reads

SQL Homework – October 2019 – Code review (self and peer)

• by Kenneth Fisher

• SQLStudies

Every database person I’ve ever met writes at least some code at some point in their career. That code might ... Continue reading

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

507 reads