SQL Server Education (by the geeks, for the geeks)
Hi Folks, I am starting a new series system stored procedures in SQL Server. In this series you will learn about many useful stored procedures which we use in our day-to-day …
sp_who – Day 1 – SQL Server System Stored Procedure Read MoreHi friends, while working a scenario I found some interesting fact about @@TRANCOUNT when we used IMPLICIT transaction & BEGIN TRANSACTION in Sql Server. I will create some scenarios and we …
IMPLICIT transaction & BEGIN TRANSACTION in Sql Server Read MoreWe all know that creating linked server from SQL 2012 to SQL 2000 does not work using the new native client SQLNCLI11. This client only connects to the following: 2005, 2008, …
Creating Linked Server from SQL 2012 to SQL 2000 Read MoreRecently I was approached and asked if there was an easy way to install client tools on SQL Server cluster. There is an easy way without ripping out and reinstalling the …
Install Client Tools on SQL Server Cluster Read MoreHi friends, In this blog I will discuss about Synonyms in SQL Server. Synonyms are the database object which is used to provide an alternative name to other database objects. We …
Synonyms in SQL Server Read MoreOver the years I have seen admins struggle when asked to provide SQL instance level information. They right click here and there and YES I was one of them till I …
SQL Sever SERVERPROPERTY – The Unused Power Read MoreThere are a lot of instances when you are asked to identify TCP port number for a SQL instance unless you use default port (1433) across the board. There are several ways to …
Identify TCP Port Number of a SQL Instance Read MoreHi Friends, Couple of weeks back one of the junior DBAs I know was installing SQL Server 2012 on Windows Server 2012 VM. He was confident that every pre-check were good …
An error occurred for a dependency of the feature causing the setup process for the feature to fail (SQL Server 2012) Read MoreHi Friends, Few days back I received a call from one of my friend mentioning that he ran into an issue while alwayson availability group setup. He did add two replicas …
Alwayson availability group setup, Checking for compatibility of the database file location on the secondary replica resulted in an error Read MoreHi Friends, Always On Availability Groups provides an enterprise-level alternative to database mirroring and it gives organizations the ability to manually or automatically fail over a group of database(s) as a …
Joining database on secondary replica resulted in an error Read More