Solutions to age-old problems are often very hard to see. It takes a new, visionary perspective to see the issue clearly and to find a solution that’s better, easier, and kinder. Learn the process of being a SQL visionary here!
There are daily reports of data leaks and ransomware attacks that maim companies in the public eye. What is it you’re supposed to do? Live in audit mode!
Fast backups mean fast restores. SQL Server native backup compression makes that happen! Read on for the pros, the cons, and the how-tos.
“Here’s an easy one,” the boss said. I tensed my toes inside my shoes, knowing it would NOT be an easy one. “Let’s get a look at the amount of space the databases are taking up.” There’s a short silence. I say, calmly, “Which databases?” “Oh, all of them.” This…is NOT an easy one. It …
Here’s the TL;DR (“too long; didn’t read” summary): In our personal AND professional lives, hundreds to thousands of things compete for our attention. We can sort these onto an X-Y graph of wanted to unwanted, and actionable to unactionable. Unwanted, unactionable attention-grabbers suck and should be eliminated as much as possible. Things that get our attention …
“Database administrator” is a job with a lot – a LOT – of different flavors, and no two days are the same. Here’s a decent example of one DBA’s day, with a bit of commentary on the side. 7:00 a.m. – Wake and have breakfast Our DBA isn’t on call this week, so there’s a …
For years we have attended technical events in person and online. In the post-COVID-19 world, online is all that is available, and I’m wondering: how will live events deliver the same benefits once they go virtual? “Attend from home” in the 2010s It’s no fun when everyone goes to summer camp, and you stay home. …
Dozens of major data breaches have occurred in the last fifteen years. Each one illustrates the massive cost – both in dollars and in reputation – of lax security. Consider: Uber in 2016 – Hackers downloaded more than 25 million drivers’ and customers’ personal information; the cover-up and resulting claims alone cost $148 million. Equifax …
We’re a large household with a small business, and we find ourselves with an interesting mix of tools for chat, screen sharing, and video conferencing. Here are our favorites! Work Life The tools we use for work include TweetDeck, Teams, Skype, and GoToMeeting. TweetDeck I’ve been connecting with other IT professionals on Twitter since 2009. …
“We have SQL Server version 20 years ago, and it runs fine. So what’s the problem? Why should we upgrade it?” The short answer is that the more your SQL Server is out of date, the more things become⦁ vulnerable,⦁ broken and unfixable,⦁ limited in features, and⦁ expensive. Vulnerable “Vulnerability = liability.” -Anon Older versions …
What happens if your SQL Server editions are out of support? Read More »