Category Archives: SQL Homework
-
SQL Homework – July 2018 – Set up database mail
Leave a commentAugust 1, 2018 by Kenneth Fisher
This month’s homework is pretty simple to say, not necessarily easy to do. Set up database mail. Why database mail? …
Continue reading -
SQL Homework – July 2018 – Create a SQL Agent Job
Leave a commentJuly 2, 2018 by Kenneth Fisher
For this month’s homework let’s try something a bit different. SQL Agent jobs are a very powerful tool frequently used …
Continue reading -
SQL Homework – June 2018 – Alter a database
Leave a commentJune 4, 2018 by Kenneth Fisher
Here we are again. The beginning of another month. At the beginning of each month I put out a SQL …
Continue reading -
SQL Homework – May 2018 – Create a database
4May 2, 2018 by Kenneth Fisher
I’ve really got to make a plan here at some point. So far I’ve been just putting down things as …
Continue reading -
SQL Homework – April 2018 – Indexes
Leave a commentApril 2, 2018 by Kenneth Fisher
This month we are going to look at a topic near and dear to both database developers and database administrators …
Continue reading -
SQL Homework – March 2018 – Recovery Objectives
Leave a commentMarch 5, 2018 by Kenneth Fisher
My very first SQL Homework post was about taking a backup. The vast majority of people who work with databases …
Continue reading -
SQL Homework – February 2018 – Work with security
Leave a commentFebruary 5, 2018 by Kenneth Fisher
This month let’s create some security! Create logins: GUI 5 pts/Script 5 pts Create a SQL login and a Windows …
Continue reading -
SQL Homework – January 2018 – Inspect an Execution Plan
6January 3, 2018 by Kenneth Fisher
It’s a new year and yet education never ends. So this month let’s take a look at an important part …
Continue reading -
SQL Homework – December 2017 – View the log
2December 4, 2017 by Kenneth Fisher
Last homework of the year. Last month was to create a view. This month it’s time to take a look …
Continue reading -
SQL Homework Nov 2017: Create a view
3November 1, 2017 by Kenneth Fisher
Views are a highly useful tool for abstracting how you see the data stored in tables. At their simplest, they …
Continue reading
