Never miss Mytechmantra.com updates: Start reading the news feed of My Tech Mantra right away! Warning: This site may contain some obscene material or profanity, so we cannot display its news (despite the fact it is visited around 82.4K times per month).
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...
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...
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...
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...
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...
DBAtricksWorld.com is about database administration & linux tricks where you will find all kind of technical fix,Installation, Con...
DBA Security Advisor, is a powerful security tool which assesses SQL Server instances against a rich set of security checks and de...
The most wanted article query about SQL. How to configure sql on database and know their function.