Microsoft Azure – How to Check the availability of cloud services using PowerShell
Hello friends, in this blog we will learn how to check whether a cloud service is available to use with...
2017-08-21
475 reads
Kapil Blogs
Microsoft Azure – How to create a virtual machine (VM) with Reserved Public IP (VIP)
In my previous blog, we learnt that a Virtual IP (VIP) get lost or changed when we stop or deallocate...
2017-08-11
684 reads
Limitation of Virtual IP address (VIP) in Microsoft Azure – Part 1
Virtual IP (VIP) is a public IP address and created when a cloud service is created. A VIP is a...
2017-08-07
578 reads
Azure – Storing all cmdlets in a file using Windows Azure PowerShell
Hello friends, windows Azure Powershell has a big library for Azure cmdlets which is very helpful in doing things without...
2017-08-04
635 reads
Connect to Microsoft Azure Subscription using Windows PowerShell – Part 2
In my previous blog we learnt to connect to Azure subscription by importing azure license setting file. In this blog...
2017-08-03
528 reads
Connect to Microsoft Azure Subscription using Windows PowerShell – Part 1
Hello friends, in this blog we will learn how we can connect to Azure Subscription using PowerShell. As you know...
2017-08-01
490 reads
How to attach a new data disk to Azure VM using Azure Portal
In this blog I will tell you how we can attach a data disk to an Azure Virtual Machine using...
2017-01-05
557 reads
How to backup local SQL database and restore to Azure SQL database
Hi friends, recently I was finding a way on taking backup of local database and restore that database to Azure...
2016-11-28
974 reads
How to collected inventory for SQL Server using Microsoft Assessment and Planning (MAP) tool
Hi friends, We need to collect inventory for database migration as well as platform to set up environment for migration,...
2016-09-30
1,094 reads
SQL Server Execution Plan Operator – Table Scan
In my previous blog we discussed about the different format of SQL Server execution plan. Now in upcoming blogs we...
2016-09-28
517 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers