I’m Speaking – SQL Saturday Sacramento 2019!

August 9, 2019August 9, 2019 Jeff Mlakar1 Comment

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

July 19, 2019July 19, 2019 Jeff Mlakar1 Comment

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.

Encryption Bans – Efforts to Ban Encryption

June 18, 2019June 18, 2019 Jeff MlakarLeave a comment

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.

How to Generate Scripts In SQL Server

May 31, 2019May 30, 2019 Jeff Mlakar2 Comments

There are multiple methods for exporting data from SQL Server. We will explore a few and focus on the “Generate Scripts” feature in SSMS.

Feature Image / License

The Worsening of WhatsApp – Signal for Privacy

May 21, 2019May 21, 2019 Jeff Mlakar1 Comment

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.

SQL Server Drop Tables in Bulk – 2 Methods

May 10, 2019May 9, 2019 Jeff Mlakar1 Comment

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.

Feature Image / License

Surveillance in the Workplace – Care or Coercion?

May 3, 2019May 4, 2019 Jeff Mlakar3 Comments

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…

I’m Speaking – SQL Saturday Phoenix 2019!

April 26, 2019April 25, 2019 Jeff MlakarLeave a comment

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

April 16, 2019April 15, 2019 Jeff Mlakar1 Comment

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.

Feature Image / License

I’m Speaking – SQL Saturday Raleigh 2019!

April 12, 2019April 15, 2019 Jeff MlakarLeave a comment

On Saturday April 27th I’ll be speaking at SQL Saturday Raleigh. I am excited to be presenting a lively and practical session about Environmental SQL Server Troubleshooting.

When called in to diagnose a performance issue what are the 1st things you review? Many DBAs and developers make the mistake of diving straight into the code looking for an answer. However, often times the solution is not in the code but rather in the overall environment.

Environmental troubleshooting is often a quick and overlooked method for discovering and configuring SQL Server to perform at a higher level without the need for application change controls.

In this session we will discuss both performance pitfalls and optimizations that can be made to the system outside of code changes. We will diagnose configurations commonly misapplied and review best practices in SQL Server, Windows Server, and VMware!