Prett Sons

Prett Sons is a SQL Server Consultant & have 9 years of experience in SQL Server Database. Right now Prett is working as a SQL Server Database Consultant at http://www.stellarinfo.com/. He loves to spend his time to research on SQL Server Database Corruption Errors.

SQLServerCentral Article

Tune SQL Server 2012 Databases Using Database Engine Tuning Advisor

Microsoft Database Engine Tuning Advisor (DTA) is a database performance tuning utility designed to analyze your SQL Server database and suggest actions to be taken in order for taking your query performance to the next level.

1.89 (19)

You rated this post out of 5. Change rating

2013-04-09

4,970 reads

Blogs

Parameter Sensitive Plan Optimization in SQL Server 2022. What is it and is it any good?

By

Parameter Sensitive Plan (PSP) optimization is a new feature in SQL Server 2022 that...

Azure chaos STUDIO

By

Chaos engineering is fun but especially important when building solutions in the cloud. It...

Announcing a New Book on SQL from 3Cloud Authors

By

I am proud to announce the launch of a new book, centered around the...

Read the latest Blogs

Forums

Azure DW default schema in a query / proc equal to "Search_Path" in AWS

By digdave7

I know you can't do this in MSSQL, but hoping DW has progressed more....

Call SQL Agent job using different account to one executing powershell

By Dave D

Hi Folks trying the below but having zero luck and was wondering if anybody...

Encrypt Varchar(max) column in SQL Server

By SatishAyyar

I have a varchar(max) column which has sensitive data and want to encrypt it....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers