Author: Derrick

  • Tracking down Failed Login Attempts in Active Directory

    I had a recent experience with a client where a user account was getting locked out but the but the logs on the domain controller weren’t very helpful. Basically besides telling us the account was locked out they did nothing, no location, nothing. After quite a bit of research on google I found this blog…

  • Who do you use for upstream DNS?

    There are so many good options for upstream DNS other than your internet provider I figured I would ask everyone, please post a comment below. Here are some of my favorites but its by no means an inclusive list. Wikipedia has a longer list here Public Recursive Name Server . My current favorite is 1.1.1.1…

  • SQL 2016 Won’t Send Mail

    I’ve come across this problem a few times and always end up googling it so I figured I would make a post for my own benefit and also to help anyone else running into the issue. Basically the RTM version of SQL Server 2016 has a bug in it where it doesn’t reference the correct…

  • Cisco Firepower Threat Defense Packet Flow

    Early in my days of learning Cisco FTD it could be hard to get my mind around how packets were flowing and where and when they were dropped. Cisco has some good images showing the packet flow but the one below by Todd Lammle is even better. Posted with permission from the author Todd Lammle…

  • SQL DB Execute to a Role

    Have you ever needed a less privileged user to execute Stored Procedures? Me too. Here is how you do it. Run this against the database — Create a db_executor role CREATE ROLE db_executor — Grant execute rights to the new role GRANT EXECUTE TO db_executor Then add the db_executor role to the users you want to be…

  • iSCSI and SQL Corruption

    I’m a heavy user of iSCSI and frequently advocate its use. For me its been reliable and has saved money. However Steve and I have over the last year worked with to clients where the use of iSCSI has caused an interesting corruption situation. The first was a database corruption repair engagement where the database…

  • SQL 2008 and 2008R2 End of Life

    July 9, 2019 is coming faster than we think. That’s the day Microsoft will no longer support SQL 2008 and SQL2008R2. I know there is a thought out there of if its not broken don’t fix it but if your business depends on SQL Server running an unsupported version isn’t a good idea. On top…

  • New Desk

    Off my normally technical topics but I wanted to share about my new work desk. A Spalted Fiddleback Maple slap with live edges on the front and back the sides are smooth curved edges. I ordered a Uplift Desk frame with dual motors and the Memory Keypad. A friend I now owe a lot to…

  • Max SQL Memory Recommendations

    I can’t take credit for this one. The credit goes to my friend Randolph. His post is at https://bornsql.ca/s/memory/ . He even has a script that will do it for you. This leaves some ram for Windows to use and I’ve found its a good map to follow for production servers. RAM Installed in System…

  • SQL 2012 Standard Memory Limits

    I’ve found there is a lot of confusion around the memory support of SQL 2012 Standard. Traditionally we see 2012 at 64GB and 2014 at 128GB and that is correct. However like most things in technology it depends. Yes SQL 2012 Standard has the 64GB Limit but the Limit only applies to the buffer pool.…

  • Printers and Old Memories

    Printers and Old Memories

    I was cleaning out my home office and came across something I’ve kept since my first tech job back in 2003. I was fixing a badge printing machine and after lots of tinkering out spit a Windows 98 test page PRINTED ON A CARD. I wonder if the card printer is still in use. The…

  • Rodents and Servers

    Recent I was dusting off a lightly used Dell R720 for a client when to my horror I discovered a home for a mouse. This teaches me two things. One don’t leave a server in a storeroom. Two don’t ever take a card out and not replace the slot. This rodent squeezed his way in…