Wateroxconsulting.com Website Review

This is the reality of learning newer tech somewhat in depth and working with it. What this series of posts will be are notes, code snippets and processes I am using and coming up with to figure out how to move the entire SQL Server infrastructure from on-prem to an AWS We have jobs that run in the early morning to load data to our data warehouses and other systems, and if they don’t complete correctly, we start to have issues that ripple through the day. In the past, we had a service provider that would monitor our jobs and rerun them if Today I am very excited to announce that I have (finally!) launched my email course covering the basics of SQL Server Security. This has been a lot of work to get a new system in place to make the learning experience a little different. It is like a normal email course, but When ‘Enforce Pas*word Policy’ for SQL Server logins is turned off, you can make your pas*word anything you want! Hooray! No picky criteria and trying to remember yet another convoluted pas*word! Not the best idea, especially if you need to have a more secured server. Recently I was performing a security audit for a client. One of the many things …   They kinda su*k. I mean it is nice that we have the option for the SQL Agent to tell us when a job fails or succeeds, but if you have ever looked at the message, there isn’t much detail in it. Take a look at this (slightly edited) email I used to get from our systems: