Category Archives: Microsoft SQL Server
-
SQL Homework – March 2022 – Formatting
Leave a commentMarch 1, 2022 by Kenneth Fisher
Please write the following on the chalk board 100 times. Queries should be readable!Queries should be readable!Queries should be readable!Queries …
Continue reading -
I’m writing a SQL Server security presentation and I need your help.
5February 24, 2022 by Kenneth Fisher
I’m working on a new presentation titled Watch Ken solve security headaches in SQL Server. In this presentation I’m going …
Continue reading -
Help, not all of my column is displaying in the output of the query!
1February 22, 2022 by Kenneth Fisher
I’ll be honest, I don’t remember if I’ve written about this before but I couldn’t find it, so here we …
Continue reading -
You can’t use GO in dynamic SQL.
2February 10, 2022 by Kenneth Fisher
This is one of those things that when I look back on it seems really obvious. Note: If at the …
Continue reading -
Who do you contact before an upgrade? : T-SQL Tuesday #147
1February 9, 2022 by Kenneth Fisher
I haven’t been blogging as much recently as I’d like and I’m trying to get back into it. One excellent …
Continue reading -
SQL Homework – February 2022 – “Soft” skills.
Leave a commentFebruary 1, 2022 by Kenneth Fisher
Well, it’s a new year and a new start, even if I am a bit behind the start of the …
Continue reading -
SQL Homework – December 2021 – Changing collation
Leave a commentDecember 2, 2021 by Kenneth Fisher
I can only speak for the locations I’ve worked at of course, but in all of the places I’ve worked …
Continue reading -
Quiz & answers for my “Auditing your data and data access” session.
1November 16, 2021 by Kenneth Fisher
I was honored to speak at Pass Summit last week (Thanks again Redgate), and if you’ve ever been to one …
Continue reading -
#PowershellBasics: Select the columns in the output.
1November 4, 2021 by Kenneth Fisher
After my post last week on sorting the list, I now have a list of files, sorted in the right …
Continue reading -
SQL Homework – November 2021 – Backup, restore, and move the system databases.
2November 2, 2021 by Kenneth Fisher
On any instance you have at least 5 system databases. Master, model, msdb, tempdb and one other. First 5 points …
Continue reading
SQL Studies 