In my view, data security is an abstract concept, just as abstract as money, religion and fascination – all devised by humans. And anything that is human-made can be human-destroyed. When it comes to IT and data security, history has proven that pretty much anything can be cracked, taken, reshuffled, altered, refurbished, reheated and re-served. … Read more
Recently, I thought about the difference between a career and a job. Technically, a job is one employment agreement out of many that span a career. A career could be database administration, while a job could be the time employed at one company. The difference between these could be considered in another way, however. If … Read more
Being an entrepreneur isn’t for everyone; by the same token, being an employee is not either. There are serious pros and cons to each side that affect one’s stress level, work/life balance, and personal fulfillment. People don’t so much choose to be an entrepreneur as they are called to be one. Entrepreneurs generally know from … Read more
I was recently asked if I thought getting a Microsoft certification was valuable. I see quite a few benefits. Certifications might help your company become a Microsoft Gold Partner, and certification may be a selling point when assigning consultants to engagements. For me, the big benefits have been about learning new features and getting to … Read more
Security, compliance, and data ethics are related concepts that everyone who works with software should know about, from the help desk to the C-level office… but almost everyone thinks that worrying about these things is someone else’s problem. As data breaches become increasingly common and data privacy regulations pass in more regions, there are increasing … Read more
Most of us haven’t learned everything we know about technology from books or classes. Instead, when things go wrong, a quick search on Google or Bing typically brings up possible solutions from others who have experienced the same problem. I often wonder about that unfortunate guy who is the first to tackle a difficult issue. … Read more
Just recently, my local .NET user group asked me to present at their meeting on the topic of graphical execution plans. I love presenting for developers on SQL Server topics. I’m often describing something well known by database administrators, but completely new to the devs. I think the group learned a lot from me that … Read more
I recently took two of my grandchildren to a McDonald’s restaurant for some lunch. We were greeted by a young woman with a big smile on her face asking if she could show us how to use the new kiosk to place our order. My first thought is that she must have been instructed by … Read more
St. Louis, MO, has a wonderful museum called The St. Louis Science Center. If you are ever in the area, it’s worth a visit. I’m lucky enough to live less than an hour’s drive away and visit once a month or so. My favourite event at the Science Center is called First Friday, an evening … Read more
As I write this, my mind is focused on my big holiday trip, just two days away. It’s a trip I’ve been planning for five years, and it includes our children, their spouses, and our grandchildren – eleven people in all. I’m still debating on whether to take a laptop along, but I’m leaning towards … Read more
At the center of all businesses is a company culture. This culture exists whether the leaders created it or not. If the leaders did not create the culture, then the loudest voices at the company define the culture. Business leaders need to stand up, define, implement and live their company culture. Some view company culture … Read more
You may have noticed a recent flurry of activity in your email inbox as many companies sent out new privacy policies and, in some cases, asked you to opt-in to continue to receive communications from them. This coincides with the deadline to comply with the GDPR (General Data Protection Regulation). This regulation is meant to … Read more
Typewriters have become rare over the past twenty years or so as we began to use computers more often at home and in the workplace. Correction tape, whiteout, and those typing erasers with a brush on the end have been replaced by the backspace and delete keys. Most people welcome this progress or have never … Read more
I was recently asked about which tools I used back when I was a full-time SQL Server database administrator. I had a tool to compress backups and a monitoring tool with licenses for just a fraction of the servers I was responsible for. Over time, I figured out ways to gather information or automate processes … Read more
One big question for software developers and IT departments in small companies is always “should I hire a DBA?” The fact that one is asking this question demonstrates that there are some symptoms that need a deeper diagnosis than you can handle. This may be a concern about backup procedures, database slowness for users, or errors … Read more
About ten years ago, my friends and family were abandoning their Myspace accounts and heading to Facebook. I fought it for a while but eventually assimilated and ended up with over 650 Facebook “friends” at last count. Even my mother embraced the platform, very happy that she could see frequently updated photos of her many … Read more
It was a rough winter for flying in and out of Heathrow as the UK experienced unusually cold and snowy weather. Unfortunately, one of my colleagues and I landed at Heathrow on 10 December during one of these storms. There was just a small amount of snow on the ground, but thousands of passengers were … Read more
A myriad of laws regulate data retention and generally compete with each other. William Brewer provides an introduction to the principles, but gives good advice -- leave the details to the specialists. … Read more
We make a special effort in March to acknowledge the accomplishments of women. Women have been making gains in many professions over the past several decades but are still underrepresented in technology. There are several hypotheses about why this is the case, but often women find they are not welcome in the “brogrammer” cultures of … Read more
Time management is simply the ability to plan how and where you spend your time throughout the work day. When you have a proper time management strategy in place, you will be more productive, enjoy your work more and have less stress. The process of implementing time management is really quite simple; it’s all about … Read more
Subscribe for more articles
Fortnightly newsletters help sharpen your skills and keep you ahead, with articles, ebooks and opinion to keep you informed.
Compliant Database DevOps
