t-sql Archives - SQLChamp

Sunday, December 10, 2023

Latest:

SQLChamp

Let's learn together!

Azure Data Platform SQLAzure

Sarabpreet Singh Anand October 14, 2016 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

Monitor Active Geo Replication

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

Azure Data Platform SQLAzure

Sarabpreet Singh Anand June 23, 2016 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

Copy Azure SQL Database Deep-dive

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

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

How to get last used timestamp in SQL Azure database?

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

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

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

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

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

In-Person Events Speaking Events

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

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

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

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

In-Person Events Speaking Events

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

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