Posted in Admin T-SQL

Performance Tuning Tip#2

Tip: Do not use Order by unless the output is not required in sorted format. If ‘Order by’ is required then include only required columns in…

Continue Reading... Performance Tuning Tip#2
Posted in Admin T-SQL

Performance Tuning Tip#1

Tip: Never use functions/Calculations/Formula on the left side of Where clause or in Join Predicate. Demo: I am using Production.TransactionHistory Table in AdventureWorks2017 database. You…

Continue Reading... Performance Tuning Tip#1
Posted in Admin

CPU Bottleneck in SQL Server

The CPU is one of the most important resource on SQL Server. High CPU utilization may potentially cause bad performance . How to Detect: Task…

Continue Reading... CPU Bottleneck in SQL Server
Posted in Admin

Always Encrypted in SQL Server

Requirement: SQL server 2016 or newer SQL Server always encrypted is a way to encrypt the table column(s) to restrict the unauthenticated access of sensitive/secured/special…

Continue Reading... Always Encrypted in SQL Server
Posted in Admin

PowerShell For DBA Part-6 (HTML Conversion and Monitoring)

Watch Part-1, Part-2, Part-3, Part-4, Part-5 Follow me: Blog: http://Sqldepository.com YouTube : Sql depository Facebook: https://www.facebook.com/sqldepository/ Google+ :https://plus.google.com/u/0/107093915534620159617

Continue Reading... PowerShell For DBA Part-6 (HTML Conversion and Monitoring)
Posted in Admin

Memory bottleneck in SQL Server

How to Identify: SQL Server is Designed to consume all the memory on the server. High memory utilization is often considered as normal in SQL…

Continue Reading... Memory bottleneck in SQL Server
Posted in Admin

PowerShell For DBA Part-5 (Credential management and MailMessage)

Watch Part-1, Part-2, Part-3, Part-4   Follow me: Blog: http://Sqldepository.com YouTube : Sql depository Facebook: https://www.facebook.com/sqldepository/ Google+ :https://plus.google.com/u/0/107093915534620159617

Continue Reading... PowerShell For DBA Part-5 (Credential management and MailMessage)
Posted in Admin

PowerShell FOR DBA Part-4 (Monitor Disk Space and send Alerts)

Watch Part-1, Part-2, Part-3     Scripts Get-DbaDiskSpace -ComputerName Sauras-Lenovo Get-DbaDiskSpace -ComputerName Sauras-Lenovo|Where-Object {$_.Free/1gb -lt 120}|Select * Get-DbaDiskSpace -ComputerName Sauras-Lenovo|Where-Object {$_.Free/1gb -lt 120}|Select *|Format-Table Get-DbaDiskSpace -ComputerName Sauras-Lenovo|Where-Object {$_.Free/1gb…

Continue Reading... PowerShell FOR DBA Part-4 (Monitor Disk Space and send Alerts)