Tag Archives: t-sql

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 …

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 …

Tech-Meet by Delhi User Group | 01-Nov-2014 | Gurgaon

Hi friends! Delhi User Group presents Tech-Meet, your chance to learn Hot technologies from Industry experts. The half-day free event for professionals in Delhi NCR includes a great line-up of industry-recognized speakers. The event will start at sharp 9:30 AM and security takes time so please be on time to skip the line and grab …

Find Users with DBOwner Database role

Scenario: Auditors need a list of Users who have DBOwner Database role on any of the database which are hosted on Tier 1 Servers. Giving this information was Very easy for few servers where the DBCount was around 10 to 20, but we also have 8 SharePoint servers each hosting 200-350 DBs. Extracting this information …

SQL Server Day | Gurgaon | 8-Sept-2012 + Hiring Drive for Microsoft India

SQLServerGeeks.com cordially invites you to SQL Server Day, the quarterly dose of SQL Server knowledge & learning. And after multiple successful events in Bangalore, Kolkata, Mumbai & Delhi NCR, we are coming to Gurgaon, once again! This time SQL Server Day event has been customized for SQL Server Developers. We bring you 3 rock star …