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

363 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

6,115 reads

Blogs

Goal Progress–Feb 2021

By

I set goals at the beginning of the year, and I’m tracking my progress...

How to: exec sp_help on temp tables?

By

Say you have a temp table and you want to see the columns names. For...

Daily Coping 26 Feb 2021

By

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

Read the latest Blogs

Forums

MSDTC and Always On AG

By VastSQL

Hi Experts, We are planning to implement 2 Node AO SQL Server 2019. For...

Remove Carriage Returns / Line Breaks / Any other reason the "text" moves down

By DCL

I know this has been covered ad nauseum all over the internet for years....

Better query to get count based on column value

By IT researcher

I am using SQL server 2008 R2 express edition. Out of below 3 method...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers