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 »
Year: 2019
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!
On Saturday August 17th I will be speaking at SQL Saturday Sacramento presenting on 2 fun topics:
- Database Corruption! Preventing Disaster to your Database
- Environmental SQL Server Troubleshooting
Read on about my presentations…
My Amateur Backyard Fireworks Show – 2019
I put on a fireworks show for the Fourth of July this year a little bigger than last. Check out the pics and videos of the show!
TLDR; Go straight to the video – https://www.youtube.com/watch?v=UkHHWZw4Yhk.
Read More »
Encryption Bans – Efforts to Ban Encryption
More and more countries are considering various types of bans on encrypted communications. Germany is thinking about it. So is the UK. Australia is actively pursuing it too.
Read on to hear why encryption bans are a bad idea.
Read More »
How to Generate Scripts In SQL Server
There are multiple methods for exporting data from SQL Server. We will explore a few and focus on the “Generate Scripts” feature in SSMS.
Read More »
The Worsening of WhatsApp – Signal for Privacy
WhatsApp isn’t what it used to be. Since the 2014 acquisition by Facebook for $19 billion, there have been noticable changes in the application.
Read on for the erosion of a well secured and private messaging application and the quest for profit that drove their descent.
Read More »
SQL Server Drop Tables in Bulk – 2 Methods
There are times when you may find yourself needing to drop many tables in your database but not all. Some criteria defines what must go. It could be archived tables, tables before or after a certain date time stamp, dummy data tables, etc.
Let’s look at 2 simple methods for dropping lots of tables in your database.
Read More »