Posts by dbaservices

Announcing SQL Server 2017 Cumulative Update 14

What comes after a baker’s dozen of cumulative updates? CU14, that’s what, and it includes a really long list of fixes. I’m only gonna hit the highlights here: Non-yielding scheduler when there is a “heavy use” of prepared statements Columnstore index build times out after 25 seconds sys.fn_hadr_backup_is_preferred_replica returns true for multiple replicas when there…

The post Announcing SQL Server 2017 Cumulative Update 14 appeared first on SQLServerUpdates.com .

Read More

Announcing SQL Server 2016 SP2 CU6: The Update You’ll Remember Forever

I’ll always remember where I was on Tuesday, March 19th, 2019 at 6:55PM. I was sitting in the Seattle airport, waiting to board the last leg of my flights home to San Diego. I happened to check my phone, and… It was here. The update we’d waited for for YEARS had finally landed. Yes, ladies…

The post Announcing SQL Server 2016 SP2 CU6: The Update You’ll Remember Forever appeared first on SQLServerUpdates.com .

Read More

Announcing SQL Server 2014 SP3 CU2 and SP2 CU16

I’m gonna be honest, dear reader: there isn’t a lot of meat on these bones (and that’s a great thing, meaning this product is pretty darned stable.) In fact, there are so few that I can list ALL of them in one post, which is fairly unusual: High CPU usage when a large index is…

The post Announcing SQL Server 2014 SP3 CU2 and SP2 CU16 appeared first on SQLServerUpdates.com .

Read More

Announcing SQL Server 2016 SP2 CU5, SP1 CU13

Microsoft went on holiday vacation, and they came back with a vengeance. There are one heck of a lot of fixes inside SP2 CU5 and SP1 CU13, including: Access violation when you compile a query Access violations and unhandled exceptions with Always On Availability Groups automatic seeding Dynamic Data Masking doesn’t when there’s a cursor…

The post Announcing SQL Server 2016 SP2 CU5, SP1 CU13 appeared first on SQLServerUpdates.com .

Read More

Why Is SQL Server So Slow?

It’s the perennial question: Why is my SQL server so slow? What was once a finely tuned system has become sluggish and unresponsive. Something has changed and now the server is struggling. But what is the cause? How can we find out where the hold-up is to even start working on a solution? Thankfully, SQL…

Read More

10 Things Every Project Manager Must Know When Deploying a SQL Server

As someone who lives and breathes SQL servers, let me tell you they are complicated beasts. With as many moving parts as the international space station (or thereabouts), it might seem impossible for an outsider to understand what’s important and what’s chaff. So, if you’re implementing an SQL server project and you don’t have vast…

Read More

How to Configure SQL Server Auditing

With the GDPR requirements rattling quite a few trees in the industry, there’s been a renewed interest in SQL Server’s auditing capabilities that were once a very neglected feature. This article steps you through setting up both a server level audit, as well as a table auditing on specific events such as selects, updates and…

Read More

How outsourcing is changing the way you do business!

Outsourcing, it almost used to be a dirty word, evoking images of offshore call centers. Thanks to the rise of dynamic work forces and increases in available contract resources, outsourcing has become mainstream. Not only can your business save money, it can now gain access to technical experts previously outside the financial reach of most…

Read More

How to Attach a Database MDF Only

For databases with single log files, the sp_attach_single_file_db stored procedure will work to attach the DB file and create a new single log file. The syntax is as follows: sp_attach_single_file_db [ @dbname= ] ‘dbname’, [ @physname= ] ‘physical_name’ Where there are multiple log file, the above stored proc won’t work. You can still attach this…

Read More

SQL Server 2000 health check script in CVS

For those of you unfortunate enough to still be running legacy applications from the cretaceous period, the below SQL 2000 Health Check script might help to sooth that itch a little…

Read More