Patching

The Time to Patch

  • Editorial

Microsoft has spent years working on building a reliable and dependable patch process for their software. While some products have had more sporadic updates, SQL Server has moved to a fairly regular schedule. Not quite a predictable "Patch Tuesday" schedule, but you can count on a CU arriving every month or two for SQL Server. […]

2020-01-03

303 reads

6 steps to a more secure SQL database

  • Article

Security is often something people think about only after they have had a problem. Given that the average cost of a data breach is $3.92 million (SecurityIntelligence 2019) and ransomware attacks have increased 97% over the past 2 years (PhishMe 2019), the "if it's not broke, don't fix it" approach can clearly be catastrophic. Here […]

5 (2)

2019-10-07

5,649 reads

Blogs

PASS Summit 2020 Mental Health Presentation Eval Comments

By

I first starting presenting on mental health last December in Charlotte, NC on mental...

Daily Coping 1 Dec 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Power BI – Hungry Median – Aggregations

By

Introduction In my last blog post, I have addressed an issue with DAX Median...

Read the latest Blogs

Forums

poor performance function

By Tomas Martin

Hello friends. This is my table "Cuentas" [IdCuenta] [int] IDENTITY(1,1) NOT NULL, [IdJerarquia] [int]...

Random Timeout Error

By tinyyyy

Hi, following a code release we have seen random timeout errors. I'm not sure...

is_merge_published

By dudik

I'm running the following query to get a list of my Merge Publications but...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers