Skip to content
Wednesday, February 8, 2023
Latest:
  • Changing Service tiers? Do you need downtime?
  • Different Database Services in AWS
  • Google Launched second Cloud Region in India
  • SQL Server IaaS Agent Extension |Part-1
  • Day-3 | SQL Server Internals and SQL Azure Workshop | IBM Noida

SQLChamp

Let's learn together!

  • Home
  • LearnSQL
  • SQLServer
  • SQLTips
  • Azure Data Platform
    • SQLAzure
    • SQLServer on Azure VM
  • Best Practices
  • Speaking Events
    • In-Person Events
    • Events

Best Practices

Best Practices 

Best Practice No.37

September 9, 2013 Sarabpreet Singh Anand

Check Database consistency at-least once every month.

Read more
Best Practices 

Best Practice No.36

September 5, 2013 Sarabpreet Singh Anand

Do proper capacity planning for the growth of your Transaction log file and size them accordingly – don’t leave it

Read more
Best Practices 

Best Practice No.35

September 2, 2013 Sarabpreet Singh Anand

In your backup strategy avoid taking daily backups of your read-only databases, monthly full backup is more than enough.

Read more
Best Practices 

Best Practice No.34

August 29, 2013 Sarabpreet Singh Anand

Rebuild only those Indexes where the fragmentation level exceeds the threshold value of 30.

Read more
Best Practices 

Best Practice No.33

August 26, 2013 Sarabpreet Singh Anand

Configure a dedicated NIC (network card) card for your Backups on your busy systems.

Read more
Best Practices 

Best Practice No.32

August 22, 2013 Sarabpreet Singh Anand

Always use SQL Server Configuration Manager to change Service account for any SQL Related Service.

Read more
Best Practices 

Best Practice No.31

August 19, 2013 Sarabpreet Singh Anand

While referring objects in Stored Procedures, functions, views and Triggers always use Fully Qualified (Multi Part) Name of the object.

Read more
Best Practices 

Best Practice No.30

August 15, 2013 Sarabpreet Singh Anand

Enable “remote admin connections” on all your SQL Servers to be able to take DAC (Dedicated Admin Connection) remotely.

Read more
Best Practices 

Best Practice No.29

August 12, 2013 Sarabpreet Singh Anand

Apply Password policy on all SQL Server logins (along with password expiration if possible) to avoid any security compromise.

Read more
Best Practices 

Best Practice No.28

August 8, 2013 Sarabpreet Singh Anand

Understand NOLOCK hint before using this in your transactions\applications – the data you are reading might not be consistent (Dirty

Read more
  • ← Previous
  • Azure (2)
  • Azure Data Platform (2)
  • Azure Data Platform (32)
  • Best Practices (37)
  • Events (9)
  • In-Person (9)
  • In-Person Events (22)
  • Latest Announcements (6)
  • LearnSQL (32)
  • Powershell for SQL (5)
  • Powershell-Basics (1)
  • Pro-Tip (1)
  • Product Reviews (1)
  • Speaking Events (18)
  • SQL for Beginners (5)
  • SQL Server (1)
  • SQLAzure (33)
  • SQLServer (15)
  • SQLServer on Azure VM (1)
  • SQLServer on Azure VM (17)
  • SQLTips (22)
  • Uncategorized (9)
  • Webcast (6)

Always Encrypted (6) azure (32) azure portal (6) Azure SQL Database (10) backup (5) backup encryption (6) cloud (6) Database (4) DDM (5) deadlock (4) Dynamic Data Masking (5) error log (3) event (21) Execute As (4) Execution context (3) free (10) Free event (8) free sql learning (6) Function (3) grant (3) gurgaon (9) in person (9) learn (3) Learning (9) limitations (4) MCT (8) Microsoft (8) MVP (8) permissions (3) powershell (8) Powershell4SQL (3) restore (3) sarab (19) sarabpreet singh anand (4) security (11) SQL (51) SQL 2012 (5) SQL 2014 (8) SQL Azure (12) SQLAzure (10) SQL Database (10) SQL Saturday (9) sql server (17) SQLServer (31) sql server 2012 (6) SQLServer 2014 (9) sql server 2014 (4) SQL Server 2016 (8) SQL Server day (9) SQLServerday (13) SQLServer Workshop (3) sql tips (4) step-by-step (4) t-sql (8) tech days (3) tips (4) Training (10) tricks (3) webcast (7) windows azure (6)

Copyright © 2023 SQLChamp. All rights reserved.
Theme: ColorMag by ThemeGrill. Powered by WordPress.