Tag Archives: Microsoft SQL Server
-
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 -
Creating a Database Audit Specification can create new users & schemas in the background
1June 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 -
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
SQL Studies 