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…
On Saturday August 17th I will be speaking at SQL Saturday Sacramento presenting on 2 fun topics:
Read on about my presentations…
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 »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 »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 »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 »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 »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 »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 »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!
If you want a preview of the talk and some supplemental info please look at these:
These are all available under the Resources menu at the top of the page.