Skip to content
Thursday, February 9, 2023
Latest:
  • Changing Service tiers? Do you need downtime?
  • Different Database Services in AWS
  • Google Launched second Cloud Region in India
  • SQL Server IaaS Agent Extension |Part-1
  • Day-3 | SQL Server Internals and SQL Azure Workshop | IBM Noida

SQLChamp

Let's learn together!

  • Home
  • LearnSQL
  • SQLServer
  • SQLTips
  • Azure Data Platform
    • SQLAzure
    • SQLServer on Azure VM
  • Best Practices
  • Speaking Events
    • In-Person Events
    • Events

SQLServer

Azure SQL Server 

SQL Server IaaS Agent Extension |Part-1

October 19, 2020 Sarabpreet Singh Anand azure, SQL Server IaaS Agent Extension, SqlIaasExtension, SQLServer

The SQL Server IaaS Agent Extension runs on top of Azure VM to help automate administrative tasks for SQL Server.  This gets installed automatically when you provision SQL Server VM from Azure marketplace.

I am not using SQL VM

Read more
Azure Data Platform SQLAzure SQLServer 

Find End-Of-Month (EOMONTH) date from SQL

May 31, 2016 Sarabpreet Singh Anand azure, Azure SQL Databases, datetime, EOMONTH, Function, month-to-add, SQL, SQLAzure, SQLServer, startdate

Hi Friends, have you ever struggled to find the end of the month date; I know its not a big

Read more
Azure Data Platform SQLAzure 

Know these restrictions\limitations before moving to SQLAzure

April 12, 2016 Sarabpreet Singh Anand limitations, restrictions, SQL, SQLAzure, sqldatabase, SQLServer, unable to do, what does not work

As we already discussed SQLAzure is an offering under Microsoft Azure umbrella as PaaS (Platform as a service) & there are limitations of

Read more
Azure Data Platform SQLAzure 

How to create a new database using SQLAzure?

April 7, 2016 Sarabpreet Singh Anand AdventureworksLT, azure, collation, create, Database, DB, db creation, default collation, new, provision, provisioning, sample data, sarab, sarabpreet, SQL, SQL_Latin1_General_CP1_CI_AS, SQLAzure, SQLServer, step-by-sep

Hi Friends, in the last post we summarized the main differences between running your workload on SQLAzure and SQLServer on

Read more
Azure Data Platform SQLAzure SQLServer on Azure VM 

Difference between SQLAzure and SQLServer in Azure VM?

April 4, 2016 Sarabpreet Singh Anand azure, cost, diff, difference, features, high availability, license, max, max DB size, scalability, SQL, sql server, SQLAzure, SQLServer

If you want to use SQL Database in Azure you get two options: either deploy it on SQLAzure or SQL

Read more
Azure Data Platform SQLServer on Azure VM 

Introduction of SQL Server on Azure VM (IaaS)

April 3, 2016 Sarabpreet Singh Anand azure, IaaS, Infrastructure-as-a-Service, SQLServer, Virtual Machine, VM

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

Read more
LearnSQL 

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

Read more
Azure Data Platform SQLServer on Azure VM 

Introduction of SQL Server on Azure VM (IaaS)

March 31, 2016 Sarabpreet Singh Anand azure, IaaS, Infrastructure-as-a-Service, SQLServer, Virtual Machine, VM

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

Read more
LearnSQL 

Why the size of the backup file changes?

March 19, 2016 Sarabpreet Singh Anand backup file, compressed backup, size of backup, SQL, SQLServer

Hi Friends, Have you ever noticed, while taking a compressed backup the file which gets created initially has a different

Read more
LearnSQL 

Memory Configuration Changes | SQL Server 2012

March 3, 2016 Sarabpreet Singh Anand awe, lock pages in memory, max server memory, memory, memory to reserve, min server memory, multi page allocation, Single page allocation, SQL 2012, SQL Server Denali, SQLServer

Hi Friends, There are a few changes in SQL Server 2012 in Memory Manger, and a DBA should be aware

Read more
  • ← Previous
  • Azure (2)
  • Azure Data Platform (2)
  • Azure Data Platform (32)
  • Best Practices (37)
  • Events (9)
  • In-Person (9)
  • In-Person Events (22)
  • Latest Announcements (6)
  • LearnSQL (32)
  • Powershell for SQL (5)
  • Powershell-Basics (1)
  • Pro-Tip (1)
  • Product Reviews (1)
  • Speaking Events (18)
  • SQL for Beginners (5)
  • SQL Server (1)
  • SQLAzure (33)
  • SQLServer (15)
  • SQLServer on Azure VM (1)
  • SQLServer on Azure VM (17)
  • SQLTips (22)
  • Uncategorized (9)
  • Webcast (6)

Always Encrypted (6) azure (32) azure portal (6) Azure SQL Database (10) backup (5) backup encryption (6) cloud (6) Database (4) DDM (5) deadlock (4) Dynamic Data Masking (5) error log (3) event (21) Execute As (4) Execution context (3) free (10) Free event (8) free sql learning (6) Function (3) grant (3) gurgaon (9) in person (9) learn (3) Learning (9) limitations (4) MCT (8) Microsoft (8) MVP (8) permissions (3) powershell (8) Powershell4SQL (3) restore (3) sarab (19) sarabpreet singh anand (4) security (11) SQL (51) SQL 2012 (5) SQL 2014 (8) SQL Azure (12) SQLAzure (10) SQL Database (10) SQL Saturday (9) sql server (17) SQLServer (31) sql server 2012 (6) SQLServer 2014 (9) sql server 2014 (4) SQL Server 2016 (8) SQL Server day (9) SQLServerday (13) SQLServer Workshop (3) sql tips (4) step-by-step (4) t-sql (8) tech days (3) tips (4) Training (10) tricks (3) webcast (7) windows azure (6)

Copyright © 2023 SQLChamp. All rights reserved.
Theme: ColorMag by ThemeGrill. Powered by WordPress.