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 […]
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 […]
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 […]
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 […]
19
2013
How to become a Microsoft Most Valuable Professional (MVP)?
This question was haunting me from long that how to become an MVP, the simplest solution is CONTRIBUTE and SHARE! The Microsoft Most Valuable Professional (MVP) Award is an annual award given to outstanding members of Microsoft’s technical communities based on contributions made during the previous 12 months to offline and online Microsoft-related technical communities. More you can found on MVP FAQ’s available at http://mvp.support.microsoft.com/gp/mvpfaqs If you think you or your friend […]
25
2012
Troubleshooting Insufficient Disk Space in tempdb
Text Reference: http://dba.stackexchange.com/questions/19870/how-to-identify-which-query-is-filling-up-the-tempdb-transaction-log Some tips for minimizing tempdb utilization 1. Use fewer #temp tables and @table variables 2. Minimize concurrent index maintenance, and avoid the SORT_IN_TEMPDB option if it isn’t needed 3. Avoid unnecessary cursors; avoid static cursors if you think this may be a bottleneck, since static cursors use work tables in tempdb – though this is the type of cursor I always recommend if tempdb isn’t a bottleneck 4. Try to avoid spools […]
24
2012
Tips to optimize tempdb performance
In order to optimize tempdb performance pay attention to physical disk configuration, file configuration, as well as some settings within the database. Physical disk configuration tempdb should reside on its own dedicated physical disks. This allows it to split I/O transactions from the remainder of volumes on the SQL Server. To move tempdb to a new disk drive, use ALTER DATABASE. It is the key T-SQL command to perform this operation. Microsoft offers a good […]
8
2012
SQL Server 2000 Replication and Agents
General Replication concept and guide to set Up Snapshot Replication http://www.databasejournal.com/features/mssql/article.php/1458491/Setting-Up-Snapshot-Replication-A-Step-by-step-Guide.htm This article talks about general concept of replication, various topologies and also a guide to setup snapshot replication
11
2012
Upgrade SQL Server 2000 Active/Active cluster to SQL Server 2005 and Windows 2003 with High Availability
Part 1: Team composition and upgrade option pros and cons – http://searchsqlserver.techtarget.com/tip/Upgrade-Active-Active-cluster-to-SQL-Server-2005-and-Windows-2003 Part 2: Restoring a SQL Server database to a transition server – http://searchsqlserver.techtarget.com/tip/How-to-restore-SQL-Server-database-to-transition-server-during-an-upgrade Part 3: SQL Server high availability when upgrading to SQL Server 2005 – http://searchsqlserver.techtarget.com/tip/SQL-Server-high-availability-when-upgrading-to-SQL-Server-2005 Part 4: Upgrade live applications to SQL Server 2005 for high availability – http://searchsqlserver.techtarget.com/tip/Upgrade-live-applications-to-SQL-Server-2005-for-high-availability Part 5: Monitor database mirroring and replication after upgrade – http://searchsqlserver.techtarget.com/tip/Monitor-database-mirroring-and-replication-after-a-SQL-Server-upgrade
Subscribe to this blog via Email
Old Posts
- November 2017 (3)
- October 2017 (4)
- September 2017 (2)
- May 2017 (1)
- April 2017 (1)
- July 2016 (3)
- May 2016 (1)
- April 2016 (1)
- February 2016 (2)
- January 2016 (1)
- October 2015 (1)
- September 2015 (1)
- August 2015 (1)
- July 2015 (2)
- June 2015 (3)
- April 2015 (1)
- March 2015 (1)
- December 2014 (1)
- September 2014 (2)
- April 2014 (1)
- January 2014 (3)
- October 2013 (2)
- September 2013 (2)
- August 2013 (4)
- July 2013 (1)
- June 2013 (2)
- May 2013 (5)
- April 2013 (3)
- March 2013 (1)
- February 2013 (9)
- January 2013 (11)
- December 2012 (14)
- November 2012 (3)
- October 2012 (4)
- July 2012 (2)
- June 2012 (3)
- May 2012 (2)
- April 2012 (8)
- March 2012 (6)
- February 2012 (3)
- January 2012 (1)
- December 2011 (5)
- November 2011 (8)
- October 2011 (5)
- September 2011 (3)
- August 2011 (3)
- July 2011 (3)
- May 2011 (1)
- November 2010 (1)
Tags
Calender
M | T | W | T | F | S | S |
---|---|---|---|---|---|---|
« Nov | ||||||
1 | 2 | 3 | 4 | |||
5 | 6 | 7 | 8 | 9 | 10 | 11 |
12 | 13 | 14 | 15 | 16 | 17 | 18 |
19 | 20 | 21 | 22 | 23 | 24 | 25 |
26 | 27 | 28 | 29 | 30 |
View Post by Categories
Recent Articles
- Setting up Always ON Availability Group in Multi Subnet Cluster – Recommendations
- Configuring Replication with Always ON Availability Group
- Login failed for user ‘DOMAIN\COMPUTER$’. Reason: Could not find a login matching the name provided. [CLIENT: ]
- Modern Servicing Model (Service Pack and Cumulative Updates) for SQL Server 2017 and onwards
- Fix: SSMS 2012 opening Debug window when pressing F5