Monthly Archives: June 2018

Frequently used MSSQL Commands

  Advertisements

Posted in commands, SQL Server, Uncategorized | Tagged , , , , , | 1 Comment

Best practices being DEVOPS in IT

Index: MSSQL Index naming recommendations:   PK_ for primary keys UK_ for unique keys IX_ for non clustered non unique indexes UX_ for unique indexes <index or key type>_<table name>_<column 1>_<column 2>_<column n>  

Posted in SQL Server, Uncategorized | Tagged , , | 1 Comment

Command to find domain group members

Related: https://vijredblog.wordpress.com/2016/04/21/activedirectory-group-user-membership-validation-tool/ (Active Directory Helper)

Posted in commands, Productivity, Uncategorized | Tagged , , , , , | Leave a comment

SQL latest available patch reference

Best source for latest SQL Server patches: https://sqlserverbuilds.blogspot.com/ Ref 2: https://technet.microsoft.com/en-us/library/ff803383.aspx (Hotfix information is not updated) Option 3: https://sqlserverupdates.com/

Posted in SQL Server, Uncategorized | Tagged , , | 1 Comment