Once again I put on a fireworks show for the Fourth of July. As per my standard, each year becomes bigger and better. However, this year was difficult because of the worldwide COVID-19 pandemic. Read on to see the show, preparation, bloopers, and lessons learned.
Read More »How to Monitor Windows Event Log for Reboots
When was my server last rebooted? Who shutdown my machine? Read on to see how easy it is to find out using the Windows Server Event Logs.
Read More »The Weakest Link – Protecting Industrial Control Systems
Like water flowing downhill, attackers will take the path of least resistance to compromise a system. Old technology that doesn’t learn new tricks is a prime target.
The ACM published an article in the Communications of the ACM by Keith Kirkpatrick which delves into security issues with SCADA systems.
Read on about SCADA systems and the security implications of old technology.
Read More »How to Load SQL Server Error Log into Table for Analysis
A while ago I wrote a post about the SQL Server error log. Today I will show how to load the SQL error log into a table for analysis via T-SQL.
Read on to see a couple of ways to traverse all the error logs and load into a table for analysis.
Read More »Hour of Code 2019
Last month was Computer Science Education Week. Once again I volunteered for the Hour of Code to support this endeavor.
Read More »Blogiversary #3 – Finding the Balance
September marked the 3 year birthday for my blog. It is times like this that I like to reflect upon the past year and see what I have learned.
Read on to hear about my last year in blogging!
Read More »The Fake News of Big Data
As engineers, developers, administrators, and other IT related disciplines, we govern our work by the scientific method. Or do we? What happens when we don’t? What are the implications if this happened a lot?
Read on the see the trouble that big data brings when trying to adhere to actual reproducible science…
Read More »SQL Server Presentations
I just uploaded some sample presentations I did. You can find them on the Resources page. Both talks were given at SQL Saturday Sacramento.
Read More »SQL Server 2008 – Come Join Us
This July marked the end of life for Microsoft SQL Server 2008 and 2008R2. Let’s raise a glass to toast / pour some liquor out / reminisce about the past…
Read More »I’m Speaking – SQL Saturday Sacramento 2019!
- Database Corruption! Preventing Disaster to your Database
- Environmental SQL Server Troubleshooting
Read on about my presentations…