Tag Archives: Microsoft SQL Server
-
TSQL Tuesday #150 Invite – Your first technical job
45May 3, 2022 by Kenneth Fisher
This month for TSQL Tuesday I’d like to hear about your first technical job(s). I know most DBAs don’t start …
Continue reading -
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 -
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 -
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 -
Commenting a branching IF-THEN-ELSE.
1October 19, 2021 by Kenneth Fisher
I’m a big fan of comments (MSSQL, Powershell), so along those lines here’s an interesting way to comment an IF-THEN-ELSE …
Continue reading -
Code examples : T-SQL Tuesday #143
Leave a commentOctober 12, 2021 by Kenneth Fisher
It’s TSQL Tuesday! John Armando McCormack (blog|twitter) is our host this month and he’d like us to share some of …
Continue reading -
Dealing with foreign keys when deleting rows.
2October 7, 2021 by Kenneth Fisher
Deleting rows from a table is a pretty simple task right? Not always. Foreign keys, while providing a ton of …
Continue reading -
SQL Homework – October 2021 – What can you tell me about the server your SQL Server instance is on?
Leave a commentOctober 5, 2021 by Kenneth Fisher
Here are some really common questions I get: How many CPUs does ServerA have? How much memory does ServerA have? …
Continue reading