Tag Archives: SQLServer

Compare Data in Two SQLServer Tables without Any 3rd-Party Tool

For comparing data in tables you don’t need any 3rd party tool, SQL Server ships with the tablediff utility which can be used to compare the data in two tables. You can use it for troubleshooting replication. This utility can be used from the command prompt or in a batch file to perform the following …

Introduction of SQL Server on Azure VM (IaaS)

SQL Server on top of a VM running in Azure is yet another example of Infrastructure-as-a-Service (IaaS). This is just like running SQL Server on a VM in your own data center, the only difference here is you don’t have to own all that hardware and maintain it, all the hardware is owned, hosted & …

Why the size of the backup file changes?

Hi Friends, Have you ever noticed, while taking a compressed backup the file which gets created initially has a different size than the final file size when the backup completes. To be more precise, the file which gets created initially allocates more space than the final backup file size.   But the question is why? …

Memory Configuration Changes | SQL Server 2012

Hi Friends, There are a few changes in SQL Server 2012 in Memory Manger, and a DBA should be aware of such changes before upgrading or installation of SQL 2012 Instance on production. In Earlier versions of SQL Server (before SQL 2012) SQL Server was also consuming memory outside of the limit defined in Max …

Which trigger will be triggered first?

Hi Friends, Yesterday I was working on a specific requirement of a client to create DDL trigger for a Database to log & validate certain things. While doing so I discovered there were already two DDL triggers created on the DB for the same event. Now I was not sure which one will be triggered …

Calculate Number of Leaves – excluding weekends

Hi Friends, Sometime back I was answering questions on TechNet Forum when I saw an interesting and genuine problem. The user wanted to calculate the number of leaves taken by an employee excluding weekends. Now calculating the number of leaves wasn’t a big deal all we need to do is just use datediff function but …

SQLServer Day 11th January 2014 | Gurgaon

Hi Friends, SQLServerGeeks.com cordially invites you to SQL Server Day, the monthly dose of SQL Server knowledge & learning. And this time we are going to cover both Dev and ITPro Audience with two different topics. This is yet another opportunity to learn. The Sessions are Optimizing from the Field: Parallelism and SQL Server Separation …

MVP Community Day \ PowerShell Day 9th Nov’2013 | Gurgaon

Dear Friends, This Saturday (9th Nov’2013) South East Asia MVP Community is celebrating MVP Community Day, a day dedicated to Knowledge sharing & Learning.   On this very day New Delhi PowerShell User Group is organizing an event in Gurgaon, and luckily my session “Managing SQL Server using PowerShell” has been selected. Aman Dhally (PowerShell …