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 »
Surveillance in the Workplace – Care or Coercion?
More and more people are being put under surveillance in the workplace. Organizations that employ them cite increased efficiency. Employees for the most part are left stressed and demoralized.
Read on for the story about TSA surveillance on their employees…
Read More »
I’m Speaking – SQL Saturday Phoenix 2019!
On Saturday May 4th I’ll be speaking at SQL Saturday Phoenix. I am excited to be presenting a lively and practical session about Environmental SQL Server Troubleshooting.
InfoSec Design Principles – 8 Security Principles To Implement
Many times when people think about security principles the one that jumps out to them is the principle of least privilege. However, there are other security principles to consider. Let’s look at 8 security principles laid out decades ago that are still relevant today.
Read More »