Mytechmantra.com

My Tech Mantra. This is a very useful feature which will help you identify whether the index is really useful or not without actually dropping...

Never miss Mytechmantra.com updates: Start reading the news feed of My Tech Mantra right away! It is pretty active and updates frequently with 100+ articles published this month alone (they might potentially reach about 45.4K visitors within the said period of time). It is generally safe for browsing, so you may click any item to proceed to the site.

News, stories and media buzz related to My Tech Mantra

Subscribe to related news

SQL Server Reporting Services (SSRS) IP Handling on Multi-Instance Servers
via serverfault

I was reluctant at first to post this question in serverfault.com because of the complex nature of the question. The question has both tendencies to be SQL Server specific, but also to be Windows Server specific. Eventually I decided to post it here...
Connection to local SQL Server 2012 can be established from SSMS 2008 but not from SSMS 2012
via dba.stackexchange

I have two local SQL Server instances running on my local machine. The first is SQL Server 2008 R2 Enterprise Edition (named MSSQLSERVER) and the 2nd is SQL Server 2012 Business Intelligence Edition. My problem is with SSMS 2012 which can connect to...
High Performance SQL Server: The Go Faster Book
via safarivideo-akamai.bvdep

Design and configure SQL Server instances and databases in support of high-throughput applications that are mission-critical and provide consistent response times in the face of variations in user numbers and query volumes. Learn to configure SQL Server...
SQL Server 2016: Distributed availability groups and Cross Cluster migration
via blog.dbi-services

How to migrate an environment that includes availability groups from one Windows Failover Cluster to another one? This scenario is definitely uncommon and requires a good preparation. How to achieve this task depends mainly of your context. Indeed, we...
Setting Up Continuous Integration with TeamCity
via dontpaniclabs

For one of my recent projects I needed to set up Continuous Integration from scratch on a server. Having never done this before I found myself assembling all the required components, installing them, and configuring them (and struggling now and then...

Mytechmantra.com popular pages

SQL Server Database Backup Tutorial with Examples - MyTechMantra.com

SQL Server Database Backup Tutorial with Examples - MyTechMantra.com SQL Server Database Backup Options and Commands a Step by Step Tutorial with Examples

MyTechMantra.com - SQL Server Articles, SQL Server Tips, SQL Server Tutorials, SQL Server Tuning, SQL Server DBA, SQL Server

In this article we will take a look at how to disable an index in SQL Server. This is a very useful feature which will help you identify whether the index is really useful or not without actually drop...