Category Archives: SQL Homework
-
SQL Homework – September 2023 – Time for temporal tables.
1September 5, 2023 by Kenneth Fisher
Recently I needed to use temporal tables. And not just for the job history table in a managed instance. In …
Continue reading -
SQL Homework – August 2023 – Have the best practices changed while you weren’t looking?
17August 1, 2023 by Kenneth Fisher
It’s been a bit since I did one of these so let’s go back to the basics. Best practices. We …
Continue reading -
SQL Homework – December 2022 – What’s new in SQL Server?
Leave a commentDecember 1, 2022 by Kenneth Fisher
SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still got a while before retirement. I …
Continue reading -
SQL Homework – November 2022 – Getting ready for the next time you have to look for a job.
Leave a commentNovember 1, 2022 by Kenneth Fisher
Back in July I suggested that you get your resume up to date. It’s something I’d wish I’d kept up …
Continue reading -
SQL Homework – October 2022 – Replication part 2
Leave a commentOctober 4, 2022 by Kenneth Fisher
In August we started taking a look at replication. We learned some of the terms used, and set up a …
Continue reading -
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.
1July 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 Studies 