Browsing articles in "Links and Articles"
Oct
6
2017

Modern Servicing Model (Service Pack and Cumulative Updates) for SQL Server 2017 and onwards

With SQL Server 2017 GA announcement for October-2 2017, Microsoft is introducing changes to the servicing model through GDRs, CUs and SPs.   Excerpt from article published:   —————————————–   The Modern Servicing Model   Starting with SQL Server 2017, we are adopting a simplified, predictable mainstream servicing lifecycle: SPs will no longer be made available. Only CUs, and GDRs when needed. CUs will now accommodate localized content, allowing new feature completeness and supportability enhancements […]

Oct
3
2017

Windows Cluster Asymmetric Disks – In Always ON Clusters

Starting Windows 2012, Windows cluster supports asymmetric disks which is required for Cluster participating in Always ON technology hence is a useful concept to be aware of,   http://www.sqlserverfaq.net/2012/09/16/when-do-we-need-asymmetric-storage-with-alwayson-fci-and-availability-storage/   https://social.technet.microsoft.com/Forums/windows/en-US/493bf438-eb9d-405c-81c5-42aaa31eef8a/configure-asymmetric-storage-for-crosssite-windows-failover-cluster?forum=winserverClustering  

May
25
2017

Antivirus Exclusion List for SQL Server

After struggling a lot and working with vendor, identified list of exclusions for SQL Server related to Anti Virus Software (McAfee, Symantec, etc.), the details can be found in this link, last one is important as it impacts performance.   https://support.microsoft.com/en-us/help/309422/how-to-choose-antivirus-software-to-run-on-computers-that-are-running-sql-server   Directories and file-name extensions to exclude from virus scanning When you configure your antivirus software settings, make sure that you exclude the following files or directories (as applicable) from virus scanning. Doing this […]

Feb
11
2016

List of Free Database and PowerShell Tools

This Article covers the list of Free database and PowerShell tools I come across time to time, this list will keep growing as I discover them, leave comments if you like any one tool better than other.   SQL Server   Database Health – dashboard overview for quick database health checks (http://databasehealth.com) Idera Free tools for SQL server: https://www.idera.com/productssolutions/freetools, below are some of best which I like, they are not totally free but works for […]

Aug
24
2015

SQL Server TDE (Transparent Data Encryption) alternatives

TDE (Transparent Data Encryption) is an inbuilt encryption feature of SQL Server Enterprise Edition introduced by Microsoft from SQL server 2008 onwards, this comes in handy when someone has to secure the PII (Personal Identifiable Information) from prying eyes, as it is Enterprise Edition feature only hence comes with a premium price. So while I got a request to analyze implementation of it on more than 200+ SQL standard edition then first thing which has […]

Jun
15
2015

Ten Step Technique to learn

One of best ten step technique for learning,   Link: http://boingboing.net/2015/05/11/the-only-technique-to-learn-so.html  

Jun
10
2015

Virtual Numa Overview – links

Came across following links relevant to Virtual NUMA, read for additional knowledge,     Vmware: https://pubs.vmware.com/vsphere-55/index.jsp?topic=%2Fcom.vmware.vsphere.resmgmt.doc%2FGUID-A80A6337-7B99-48C8-B024-EE47E2366C1B.html     Hyper-v https://technet.microsoft.com/en-ca/library/dn282282.aspx

Sep
4
2014

All about SQL Server Trace flags – Links

  While doing search for SQL Server 2005 trace flags found few good links which greatly describe the info in detail, please use as per your requirement, most of them may be applicable to higher version of SQL Server as well.   Flags can be set for Session or Global (some are startup) levels though for later some can only be switched at startup using –T (you are suggested to avoid –t which turns on […]

Jan
1
2014

Generate SQL Server Database Diagrams – tools tips

Came across a requirement where I need to generate database component chart and their relationships, though database diagram tool is available but it has some risks associated, hence just in order to generate component chart, third party tools are also available and can server purpose, below is just collection of such tools and related links for use of needy ones,     Using inbuilt Database Diagram Tool: Just right Click on Database Diagrams and create […]

Jan
1
2014

Database Backup Compression using SQL Server 2008 R2

Database backup compression is a feature provided by Microsoft which reduces the native backup size by up to 66% depending upon the type of data stored in a database and similar other factors. By default backup compression is disabled as it has some limitations which needs to be looked as per environment setup and if suites one’s need then it can be enabled as default or a parameter can be added to backup script to […]

Pages:123»

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 34 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

December 2017
M T W T F S S
« Nov    
 123
45678910
11121314151617
18192021222324
25262728293031

View Post by Categories

%d bloggers like this: