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 »
I’m Speaking – SQL Saturday Raleigh 2019!
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!
If you want a preview of the talk and some supplemental info please look at these:
- Environmental Checks – Overview
- SQL Server Environmental Diagnostics Guide
- Windows Server Environmental Diagnostics Guide
- VMware Environmental Diagnostics Guide
These are all available under the Resources menu at the top of the page.
T-SQL Tuesday #113 – What Do You Use a Database For?
The topic for this months T-SQL Tuesday #113 hosted by Todd Kleinhans (Blog / Twitter) is about “what do YOU use a database for”. We work all day, night, and weekend sometimes on our database craft. Todd asks:
So what do you use databases for in your personal life that you are willing to share?
Read on to hear my story.
Read More »
Why You Should Use a Password Manager – The Pros and Cons of Password Management Systems
The proliferation of online login accounts has made our lives easier and more convenient to gather information, pay bills, etc. However, it comes at a cost. Our password management hasn’t changed much – and that creates a vulnerability that can really hurt.
Read on to see the pros and cons of password management systems.
Read More »
Why You Need a VPN – Protect Yourself Online
Using a VPN is critical for protecting yourself online and maintaining a level of privacy. It might sound technical and intimidating but it is as easy as checking email – and the benefits are significant.
Let’s discuss what you can do and why to stay safe online.
Read More »