Personal Blog of Life Adventures
Do you run SQL Agent Jobs in your environment? Do you know what is running at any given time? Most people do not know what is currently running if you ask them. There are several times I need to know what job(s) is running on which server. For instance, let’s say on the morning of Read More …
Back in March I saw a Tweet about the beta Microsoft Certification Exam AZ-104 program was looking for 300 candidates to take the exam by May 31st. Since moving to my current job over a year ago I have been fully in an Azure shop. While I am a DBA for the most part, I Read More …
Recently I have been able to work with our development teams to not create new databases. There are several reasons for me making this request of the teams. The number one problem is that they were deployed with default settings and owners which I am not a fan. These things kill my OCD, but also Read More …
Are you a Microsoft SQL Server DBA managing one or more servers? Then you should know about the First Responder Kit from Brent Ozar Unlimited. This is a free set of tools that help you check the health of your SQL Servers. Are you aware of SQL Server configuration settings that differ on your servers 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 …