Category Archives: SQLServerPedia Syndication
-
DBA Myths: The system sessions are the ones with a session_id 50 or less
Leave a commentNovember 18, 2019 by Kenneth Fisher
Anecdotally any session_id that’s 50 or less is going to be a system session and anything over 50 will be …
Continue reading -
The curious case of CHAR(0)
12November 14, 2019 by Kenneth Fisher
Over the years I’ve seen quite a few strange things with SQL Server. This one may not have been the …
Continue reading -
What the ???? T-SQL Tuesday #120
11November 12, 2019 by Kenneth Fisher
Hey, it’s T-SQL Tuesday again! I almost forgot about it what with Summit and all. Wayne Sheffield (blog|twitter) is our …
Continue reading -
Volunteers
1November 6, 2019 by Kenneth Fisher
This week is the PASS Summit and it has me thinking about all of the amazing work done in our …
Continue reading -
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 -
#PowershellBasics: The GetType() and GetTypeCode() methods
1October 28, 2019 by Kenneth Fisher
I’m a DBA. Data types are kind of important to me. I mean I know they are important to developers …
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: Get-Help -Online
Leave a commentOctober 21, 2019 by Kenneth Fisher
One of the other things I learned from the Powershell class I’m taking this week is that there is an …
Continue reading -
#PowershellBasics: Powershell vs Powershell Core
1October 10, 2019 by Kenneth Fisher
I’m taking a Powershell class this week and I have to say the teacher is one of the best I’ve …
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 Studies 