Category Archives: SQL Homework

  1. SQL Homework – September 2023 – Time for temporal tables.

    1

    September 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

    Category: Microsoft SQL Server, SQL Homework, SQLServerPedia Syndication | Tags: , ,

  2. SQL Homework – August 2023 – Have the best practices changed while you weren’t looking?

    17

    August 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

    Category: Microsoft SQL Server, SQL Homework, SQLServerPedia Syndication | Tags: , ,

  3. SQL Homework – December 2022 – What’s new in SQL Server?

    Leave a comment

    December 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

    Category: Documentation, Microsoft SQL Server, SQL Homework, SQLServerPedia Syndication | Tags: , ,

  4. SQL Homework – November 2022 – Getting ready for the next time you have to look for a job.

    Leave a comment

    November 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

    Category: SQL Homework, SQLServerPedia Syndication | Tags: , ,

  5. SQL Homework – October 2022 – Replication part 2

    Leave a comment

    October 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

    Category: Microsoft SQL Server, Replication, SQL Homework, SQLServerPedia Syndication | Tags: , ,

  6. SQL Homework – September 2022 – Query window challenge

    Leave a comment

    September 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

    Category: Microsoft SQL Server, SQL Homework, SQLServerPedia Syndication, T-SQL | Tags: , , ,

  7. SQL Homework – August 2022 – Replication part 1

    Leave a comment

    August 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

    Category: Microsoft SQL Server, Replication, SQL Homework, SQLServerPedia Syndication | Tags: , ,

  8. SQL Homework – July 2022 – Update your resume.

    1

    July 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

    Category: Collation, SQL Homework, SQLServerPedia Syndication | Tags: , ,

  9. SQL Homework – June 2022 – SQL Agent Jobs continued.

    2

    June 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

    Category: Collation, Microsoft SQL Server, SQL Homework, SQLServerPedia Syndication | Tags: , ,

  10. SQL Homework – May 2022 – Books on Line

    Leave a comment

    May 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

    Category: Documentation, Microsoft SQL Server, SQL Homework, SQLServerPedia Syndication, T-SQL | Tags: , , ,

« Older Entries

Follow me via RSS

RSS Feed RSS - Posts

RSS Feed RSS - Comments

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,978 other subscribers

Follow me on Twitter

@sqlstudent144