t-sql Archives - SQLChamp

Azure Data Platform SQLAzure

Monitor Active Geo Replication

October 14, 2016 Sarabpreet Singh Anand Active Geo Replication, Catch-up, Monitor Active Geo Replication, Monitor Active Geo Replication configuration, Monitor Active Geo Replication Health, percent_complete, queries, query, replication_state, scripts, secondary_allow_connections, seeding, Sys.dm_geo_replication_links, Sys.dm_operation_status, Sys.dm_replication_link_status, t-sql

If you want to know Active Geo Replication from scratch you can read its introduction, the step by step how

Azure Data Platform SQLAzure

Copy Azure SQL Database Deep-dive

June 23, 2016 Sarabpreet Singh Anand AS COPY OF, azure, azure portal, Azure SQL Database, cancel copy, Copy, copy azure sql database, COPY AZURE SQL DB, CREATE DATABASE, DB, Migrate, monitor copy, SQL Azure, SQL Database, SUSPECT, sys.databases, sys.dm_database_copies, t-sql

If you are supporting Azure you might have to copy Azure SQL Database, In-fact sometimes this becomes a daily task

SQLAzure SQLServer SQLServer on Azure VM

How to get last used timestamp in SQL Azure database?

June 6, 2016 Sarabpreet Singh Anand @@DBTS, azure, Function, MIN_ACTIVE_ROWVERSION, row version, rowversion, SQL Azure, SQL Server 2016, t-sql, time stamp, timestamp

A timestamp is the time at which an event is recorded (inserted or updated), and timestamp is guaranteed to be

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

April 2, 2016 Sarabpreet Singh Anand compare, data comparison, replication, SQL, SQLServer, t-sql, table, tablediff, values

For comparing data in tables you don’t need any 3rd party tool, SQL Server ships with the tablediff utility which

Calculate Number of Leaves – excluding weekends

February 12, 2016 Sarabpreet Singh Anand calculate leaves, Calculated Measures, datediff, exclude weekends, leaves, SQLServer, t-sql

Hi Friends, Sometime back I was answering questions on TechNet Forum when I saw an interesting and genuine problem. The

In-Person Events Speaking Events

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

October 20, 2014 Sarabpreet Singh Anand ASP.NET, backup and restore, event, MVC, powershell, speaking, SQL 2014, sql server 2014, t-sql

Hi friends! Delhi User Group presents Tech-Meet, your chance to learn Hot technologies from Industry experts. The half-day free event

Find Users with DBOwner Database role

October 17, 2013 Sarabpreet Singh Anand all databases, audit, DBOwner, script, security, SQL, sql server 2012, t-sql

Scenario: Auditors need a list of Users who have DBOwner Database role on any of the database which are hosted

In-Person Events Speaking Events

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

September 4, 2012 Sarabpreet Singh Anand developer, hiring, job opportunity, Microsoft, myth-buster, optimizing transactional and procedural code, SQLServerday, t-sql, tips, tricks

SQLServerGeeks.com cordially invites you to SQL Server Day, the quarterly dose of SQL Server knowledge & learning. And after multiple