Sarabpreet Singh Anand, Author at SQLChamp

SQL Server on Azure VM is yet another example of Infrastructure-as-a-Service (IaaS). This is just like running SQL Server on

What is SQLAzure (Azure SQL Database)

SQLAzure also known as Azure SQL Database is a database-as-a-service cloud based offering (Microsoft Azure); this offers a fully managed

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

Hi Friends, Welcome to SQLChamp.com, my name is Sarabpreet Singh Anand and i am a Microsoft Data Platform MVP. The

Question of the day: What all changes require a restart of SQL Service? Let’s say you get a request to

SQL Server on top of a VM running in Azure is yet another example of Infrastructure-as-a-Service (IaaS). This is just

FULL Recovery model: This means that all database changes are fully logged and ideally the log records should stay in

SQLAzure or Azure SQL Database is a database-as-a-service cloud based offering (Microsoft Azure); this offers a fully managed relational Database

SQL Server Password audit is a must for all SQL Servers. Weak or Blank passwords are invitation to trouble and

Microsoft SQL Server 2012 introduced 14 new built in functions. These new functions are: Conversion functions PARSE TRY_CONVERT TRY_PARSE Date