Articles - SQLServerCentral

Get updates from Articles - SQLServerCentral via email, on your phone or read them on follow.it on your own custom news page.

You can filter the news from Articles - SQLServerCentral that get delivered to you using tags or topics or you can opt for all of them. Unsubscription is also very simple.

See the latest news from Articles - SQLServerCentral below.

Site title: SQLServerCentral – The #1 SQL Server community

Is this your feed? Claim it!

Publisher: Unclaimed!

Message frequency: 0.88 / day

Message History

How a SQL Server backup can execute attacker code during restore2 days

The post How a SQL Server backup can execute attacker code during restore appeared first on SQLServerCentral.

Read full story

The memory toll of VARCHAR(MAX) in SQL Server2 days

Introduction

When designing the tables or writing the stored procedures in SQL Server, we get easily tempted to choose the path of least resistance. When deciding how much space to allocate for a text column in a database table which may contain the description of a product, a product name, or an additional comment/remarks, it is very common for us to think to allocate the ma...

Read full story

How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager4 days

The Starting Point

Last year, our executive leadership team sent a clear message to every department — find ways to cut costs, and find them fast.

As the Database Operations Manager, I knew the database infrastructure bill was one of the first places I needed to look. Not because someone told me to specifically, but because I had seen the numbers before and had a feeli...

Read full story