Steve Jones from Redgate and SQLServerCentral.com recently put out an interesting challenge: A day in the life of a DBA. The thought is that there is not a lot of discussion around what IT professionals and DBA’s in general do day to day. For the upcoming generation there is a large gap of knowledge out Read More …
My second SQL Saturday presentation is officially complete. This past weekend was SQL Saturday #734 in my hometown of Dallas, Tx. To say I was nervous to present locally is an understatement. I tell myself the reason I picked Phoenix as my first attempt at public speaking is because if things did not go Read More …
Are you a dbatools enthusiast like I am? Have you been introduced to the greatness? Well here is hoping you said yes to both questions and you are using dbatools on a daily basis. dbatools has changed the daily routine of hundreds of DBA’s around the world. You do not have to be a Read More …
Issue Recently, I was forwarded a request from our Product Support team to prepare the database for a third party application to be sent to the vendor for troubleshooting. This particular database has TDE enabled, so I figured that is easy, let me knock that out. So I proceeded to restore the database to one Read More …
It is that time again to rave about dbachecks! This week I put in to action automated checks that run via SQL Agent for different scenarios. Issue In my environment I have 300+ servers from development to production. I do not just want to run all checks on all servers as that would take forever and Read More …
Last weekend it happened, I performed my first speaking engagement at a SQL Saturday. Over the past six weeks a have felt a range of emotions after clicking that submit button on the Speakers Session Submission page. I have already done a couple of posts about getting selected and my plan to preparation. With Read More …
Have you embraced the awesomeness that is dbachecks? dbachecks is a great framework that was built to check your SQL Environment for best practices and alert you to out of compliance items that can be acted upon. I have recently been building a demo to introduce the tool to my work team. While doing this Read More …
12 Days to GO Since learning I was selected to speak at SQL Saturday Phoenix; I have been preparing all my material, practicing my presentation, getting feedback from the SQL community. This has been a overwhelming, but I am looking past all of the anxiety and focusing on the excitement for the opportunity. A couple Read More …
From the creators of the wildly popular dbatools open source PowerShell project comes dbachecks. Harnessing the power of the Pester framework and the amazing PSFrameWork module by Fred Weinmann (t) , the team has put together a module that compiles the checklists that all good DBA’s should be performing on their environments. This list of checks Read More …
For this week I am going to go through a process that I developed and am pretty proud of. We the DBA Team are responsible for getting data in to our Integration environments and higher. We do not trust the developers with this responsibility as they would probably break something. Issue Recently one of our Read More …
