The topic for this months T-SQL Tuesday #112 hosted by Shane O’Neill (Blog / Twitter) is about “dipping into your cookie jar”. This reference means “when times get tough how do you dip into your reserves to keep going”. Shane asks the following:
That is what I want from the contributors of this T-SQL Tuesday, those memories that they can think back on for sustenance. Like the humble cookie, I want a humble brag.
Read on as I share some stories…
Read More »
Wait statistic are a fundamental concept of any RDBMS. Let’s review some basics of troubleshooting performance issues with wait statistics.
Read More »
Recently there were two huge data breaches of two very large companies. Both organizations collected a ton of information about their clients. The breaches were both spectacular in scope. Furthermore, both were among the largest known data breaches.
I see a large contrast between the Marriott breach and the Equifax breach. The difference between the two massive breaches clearly demonstrates the importance of basic security methods.
Read More »
There are many articles online describing SQL Server data compression. In this post I will summarize some of the salient points.
Read More »
Location services abound in apps everywhere. Your smartphone is constantly tracking your location whether to guage traffic, share with loved ones your whereabouts, or get the weather. However, this can lead to all sorts of abuses which are not immediately obvious to most.
Let’s delve into it and see what’s at stake.
Yesterday, Monday January 28th, was Data Privacy Day 2019.
Read More »
Many years ago Microsoft published a list of the “10 immutable laws of security”. The page has since been removed; however, another version popped up with very slight changes.
Read on the see the security principles from decades ago which are still prevelant today.
Read More »
The Internet was created in simpler times. The various principles which formed it are under constant challenge. Over time the Internet has gone from a research curiosity to a mainstream utility.
The openness of cyberspace is heavily challenged by various competing interests. Read on about the struggle, various players, and what can be done.
Read More »
Time for another batch of dank SQL Memes! Love to hear your feedback on the hits and misses. Read on to see the meme magic…
Read More »
Network problems with connecting to SQL Server can be daunting. DBAs have various levels of proficiency in networking. It ranges from deep working knowledge to very primitive. Here I outline some basic network troubleshooting techniques that will help you navigate the issue.
Read on to see how to troubleshoot basic networking issues at the command line.
Read More »