Storage Management

Reliable Storage Systems for SQL Server

  • Article

By validating the IO path before commissioning the production database system, and performing ongoing validation through page checksums and DBCC checks, you can hopefully avoid data corruption altogether, or at least nip it in the bud. If corruption occurs, then you have to take the right decisions fast to deal with it. Rod Colledge explains how a pessimistic mindset can be an advantage

2010-06-03

2,506 reads

Blogs

Join me at SQLBits 2020

By

The SQLBits conference is taking place in London again this year, between March 31st...

DBA, a job, a vital job

By

DBA, a job, a vital job. T-SQL a language that is fun. Select, a...

SOS_SCHEDULER_YIELD – What is it really telling us?

By

I decided to write this off the back of a conversation I was having...

Read the latest Blogs

Forums

SMO Certificate Export - FailedOperationException

By BPRocket

Greetings, Given this Powershell SMO method call... $_cert.Export("$CertificateLocation\$_cert_name.cer", ` "$PrivateKeyLocation\$_cert_name.pvk", ` $_secret) where $_cert...

Resultset in a format

By VSSGeorge

I have the following tables: create table #EmployeeSystemsMaster(EmployeeSystemID int, EmployeeSystemName nvarchar(150)) insert into #EmployeeSystemsMaster...

SQL Server data masking

By Admingod

Can you able to mask data in sql server 2012? If yes, would it...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers