Tagged: SQLServer

0

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...

0

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...

0

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,...

0

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...

0

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...

0

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....

0

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...

0

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...