Profile cover photo
Profile photo
Vinoth N Manoharan
159 followers
159 followers
About
Posts

Post has attachment
SQL Azure:Powershell AzureRM Create a new database in a existing server
Below is a simple script with modification from the MSDN
sample script below to create a SQL Azure database on an existing resouce group and existing SQL server in
oppose to creating a new RG and server in the below example, Copyright © 2018 Vinoth N Manoha...
Add a comment...

Post has attachment
SQL Azure:Powershell AzureRM Create a new database in a existing server
Below is a simple script with modification from the MSDN
sample script below to create a SQL Azure database on an existing resouce group and existing SQL server in
oppose to creating a new RG and server in the below example, https://docs.microsoft.com/en-us...
Add a comment...

Post has attachment
Schedule SQL Jobs Using Azure Automation account
With the migration to SQL Azure happening on a fast pace i get lot of queries from my clients on how to schedule a SQL Agent job on a SQL Azure database In this Blog We will see how to schedule a SQL how to schedule a SQL Job using Azure Automation Account....
Add a comment...

Post has attachment
Replication - Compatibility issue
I was working on a POC concept for my client to test some replication functionality and got the below error, "he selected subscriber does not satisfy the minimum version compatibility level" I was using SQL Server 2008 as a distributor and Publisher and SQL...
Add a comment...

Post has attachment
Run SSMS As User in Different Domain
Every come across the trouble of having to login to a jump server in just to access SSMS since the server is in different domain. There is a way to by pass it and access SSMS using your second domain login from your desktop by using Runas /NetOnly option ir...
Add a comment...

Post has attachment
Find SSAS instance Port Number
When you have more than one instance of SSAS installed in your Server you might end up in a situation to find the port numbers for each instance to set the firewall settings on the server. As you might all know the default Port for SSAS is TCP 2383,  To fin...
Add a comment...

Post has attachment
dbcreator SQL Azure database - dbmanager and loginmanager role
Recently I was working for a client to install a new application with a backend on SQL Azure (Paas), The application was an inbuilt application which creates a database during application and does not have an option of using existing database, They did not ...
Add a comment...

Post has attachment
Quick Tips:- Add SQL User/Rolemember to all Databases in SQL Server
Most of times when you have dedicated SQL Server for an Application
clients come up with a request to add a user to all databases in the SQL Server
with certain permission, while its east to do it via SSMS for if the system has
only couple of databases but ...
Add a comment...

Post has attachment
There is no remote user ‘xxxxx’ mapped to local user ‘(null)’ from the remote server ‘xxxxx’
My Client recently complained that his linked server was
failing to connect with the following error, “An error Occurred during Service Key decryption There is no remote user ‘xxxxx’ mapped to local user ‘(null)’
from the remote server ‘xxxxx’. (Microsoft S...
Add a comment...

Post has attachment
SQL Server 2016: Get-SQLErrorlog Powershell Module
With the latest update to SQL Server 2016 SSMS there are some new interesting features added to the SQL Server Powershell making managing SQL Server through Powershell more easier and efficient. The Detailed information on the addition can be found in the b...
Add a comment...
Wait while more posts are being loaded