Whilst this bug is not directly related to SQL Server I thought DBAs should be aware of it since there are a lot of web servers out there accessing SQL Server back ends. I found this article Everything you need to know about the Heartbleed SSL bug by Troy Hunt to be one of the best in explaining the bug’s ins and outs.
As you know SQL Server 2014 was released this month so the question is why would you consider upgrading to SQL Server 2014? If you have a budget to implement the Enterprise Edition then you probably have more of a case to upgrade now, though items 3, 9 and 10 below may provide enough performance benefit to also consider
Flowing on from my previous article Migrating Database Mirroring to an Availability Group I thought it might be worth posting the high level steps that worked for me in converting a SQL Server 2008 R2/Windows 2008 R2 Enterprise Database Mirroring implementation into a two node Availability Group environment with the second
This is Jason’s take on the monthly tasks for a SQL Server DBA (10 Monthly Maintenance Tasks for SQL Server). My recommendation is that these tasks should be automated where possible.
Recently a client of mine was experiencing performance issues with the daily Master Resource Planning (MRP) process run, in particular, not only would it run for extended periods but it would also stop other users from performing their tasks.
The following article from SQL Magazine (The DBA is Alive and Well—Here’s Why) provides a couple of opinions as to why the DBA role is not dead, I would like to add my two cents worth to this discussion.
I recently read the SQL Server Blog article Data-intensive Applications in the Cloud Computing World by Mark Souza, General Manager, Windows Azure Customer Advisory Team and it really drove home the concept that moving applications into the Cloud is not just about moving an application and related database to respective virtual
Consider the following situation, you create a database backup on a AWS virtual machine EBS disk and then move the backup file to Blob storage e.g. S3. However, you have switch on the Encryption option for your S3 storage. Is your database backup file fully protected? Yes, well, sort of.
I thought it would useful to highlight to readers that there can be differences in what a VM Guest performance counters show verses similar counters presented by the VMware performance charts. The following articles provide an insight into some of the discrepancies you may face.