Tag Archives: SQL Homework
-
SQL Homework – September 2022 – Query window challenge
Leave a commentSeptember 1, 2022 by Kenneth Fisher
I had every intention of doing Replication Part 2 this month but had a thought I liked better. I will …
Continue reading -
SQL Homework – August 2022 – Replication part 1
Leave a commentAugust 2, 2022 by Kenneth Fisher
You’ll hear a lot of people complain about replication. Including me. That said, replication is an amazing tool. There really …
Continue reading -
SQL Homework – July 2022 – Update your resume.
Leave a commentJuly 5, 2022 by Kenneth Fisher
Resumes have been on my mind a lot recently. I’ve been thinking that I wish I’d kept mine up to …
Continue reading -
SQL Homework – June 2022 – SQL Agent Jobs continued.
2June 2, 2022 by Kenneth Fisher
A few years ago I gave you homework to create a SQL Agent Job and play with it a little …
Continue reading -
SQL Homework – May 2022 – Books on Line
Leave a commentMay 5, 2022 by Kenneth Fisher
No one knows everything. Ask any senior level person in IT and they’ll tell you that they spend plenty of …
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 -
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 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
SQL Studies 