steve@thesqlguy.com

6 steps to a more secure SQL database

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

4,351 reads

Blogs

T-SQL Copy & Paste Pattern – Increasing a performance problem

By

Disclaimer: The title is my assumption because I saw it in the past happening...

Removing ad hoc plans from Query Store

By

This is not a post about the “optimize for ad hoc workloads” setting on...

Disaster recovery, tools edition

By

I just completed a chapter for another book where I spoke about the Recovery...

Read the latest Blogs

Forums

Convert Varchar to Int and SUM

By ibrahimovich87

Hi, need a request...it's possible to convert dbo.RE80_MOVSCHPUNTI.RE80_VALORE this table from nvarchar to INT...

TDE for Always on databases

By bobrooney.81

Hi All, In terms configuring and usage of TDE encryption is there a difference...

OLE DB Destination has written 0 rows

By DinoRS

Hi SSC, I'm having issues with one SSIS Package running on SQL Server 2017....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Fashion

See possible answers