My first go at smokin’ a brisket is documented below. It is summertime and we are stuck at home in isolation, might as well find a new hobby. I was blessed to get an electric smoker for Father’s Day. It was from my mom, so not sure how much of a Father’s Day gift or Read More …
Heading to PASS Summit… It is Sunday the week of PASS Summit and I am at the airport after a relaxing morning with my wife and son. Unfortunately, I keep getting notifications that my flight keeps getting delayed. On the bright side I don’t have anything on my agenda today for the conference. I had Read More …
It is that time of year again. The NTSSUG has two spots coming open on the board. Last year I decided at the last minute to opt in as a candidate and lost out to the great Russ and Fernando. A year has gone by and my dedication to community and giving back to the Read More …
Do you frequently use the “log_reuse_wait_type_desc” column in the sys.databases view? Have you ever seen the type of OLDEST_PAGE? You are not the only one!! Recently I was troubleshooting an issue with a database where the log was growing and the virtual logs would not clear after executing a transaction log backup. So I took Read More …
So you hear this spread across the Twitterverse and Blogosphere. You should not RDP your SQL Servers to do administrative work. My nature has always been to troubleshoot issues from the server in an RDP session. When I received a disk space alert on a development system I was about to RDP and do my Read More …
HaHa, tricked you. You can’t install SQL MDS on Standard Edition. You must first upgrade to SQL Enterprise Edition before you can proceed with an MDS installation. Upgrading SQL Server Edition: Launch the Installation wizard on the server you want to update Choose the Maintenance section and choose Edition Upgrade Then click through the defaults Read More …
There is a little known or used command that can grant you great power when it comes to running PowerShell commands. The Show-Command cmdlet will display in a graphical interface all the parameter options related to a function, cmdlet or workflow. I always recommend the book “Learn Windows PowerShell in a Month of Lunches” for Read More …
No, don’t worry this did not happen. Depending on who you have been listening to over the past few months your SQL 2008 and 2008 R2 servers did not magically stop working when the clock struck midnight on 07/09/2019. Have you ever had software just die on a specific date and not work? Sure, if Read More …
The long awaited official release of dbatools v1.0 is upon us. Today at DataGrillen the official launch will happen and the release to the PowerShell Gallery will shortly follow. This version has been a long time in the making with tons and tons of awesome community contributors. As you may or may not know, dbatools Read More …
I am back!!! And no, I did not volunteer to go to jail for 60 days. Since my wife and I are avid watchers of police/crime/prison shows on TV, I felt like that was a good title, so I ran with it. Maybe my attraction to these shows has to do with my inner bad Read More …
