Database Weekly is the seven-day roundup from SQLServerCentral. We scour the Internet with a fine-toothed set of queries to compile the most informative weekly newsletter about SQL Server. Over 670,000 SQL Server professionals rely on it to kick-start their week.
Sign up to our newsletter now, to keep up to date with all the latest news.
Latest Database Weekly Newsletter Articles
SQL Server Version Numbers – Do they matter?
It’s a trick question, yes. Your SQL Server version matters! In this post I’ll tell you how to check your version, talk about what makes up the version number and talk about why it matters so much and why you should get a plan in place to regularly upgrade or update SQL Server.
After WhatsApp Vulnerability, Are Any Messaging Apps Truly Secure?
Is there a truly secure messaging app? On Friday it was revealed that attackers could exploit a security vulnerability in WhatsApp to snoop on its users. The vulnerability was found in the service’s implementation of end-to-end encryption, which is supposed to make it all but impossible for messages to be read by anyone except their intended recipient.
Six ways to treat your data right
Not everyone understands just how important data is until it is gone. When disaster strikes, and you can’t recover, you are likely to be shown the door…if your company still exists at all.
Identifying SQL Server Logins without Default Database Users
Tim Ford dissects a case where a client migrated their SQL Server instances from SQL Server 2012 to SQL Server 2016, but didn't do a complete job of migrating over their logins. This caused connectivity issues because some of the logins were missing a corresponding user in their default database.
Animated barplot and google map with R
It might happen that you will need a animated graph of any kind. For purposes of plotting demographic data and changes through the years, Google Maps and plotting maps, merging and converting jpg files into a animated gif, sure will give a nice visualization effect.
What is COPY_ONLY?
Did you know, for example, that a COPY_ONLY full backup can be used as the base for a log backup but not a differential?