Tag Archives: Microsoft SQL Server
-
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 -
New parameter in sp_DBPermissions and sp_SrvPermissions: @CopyTo
Leave a commentAugust 18, 2022 by Kenneth Fisher
I’ve added a new parameter to my permissions scripts (well, just the main two for now). Fair warning, it’s in …
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 -
Creating a Database Audit Specification can create new users & schemas in the background
2June 28, 2022 by Kenneth Fisher
I love database audits. They are simple, easy to use, effective, not overly resource intensive, and can be turned on …
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 