Category Archives: Sql Server

SQL Server Tutorials, SQL Server Tutorials for Beginners, SQL Server Online Course, Microsoft SQL Server Learning, Microsoft Online Learing

AlwaysOn Availability Groups SQL Server

AlwaysOn Availability Groups SQL Server In this post we will learn about AlwaysOn Availability Groups SQL Server. AlwaysOn Availability Groups was first introduced in SQL Server 2012. AlwaysOn Availability Groups SQL Server is the successor of Database mirroring which was introduced with SQL Server 2005 SP1, Database mirroring is a great feature for High Availability and Disaster Recovery,

Change Domain Name in Email ID SQL SERVER

Change Domain Name in Email ID SQL SERVER Recently my organization has changed his domain name, so this will also effect our HR portal. Because our HR portal is authenticate users from AD(Active Directory) also checks users status in HR database which reside on SQL SERVER. My manager asked me to change domain name from

The permissions granted to user ‘Domain\User’ are insufficient for performing this operation. (rsAccessDenied)

The permissions granted to user ‘Domain\User’ are insufficient for performing this operation. (rsAccessDenied) Hi friends in my previous post I had installed SQL Server 2016 – With Reporting Services. So I think a go through is must from reporting services, Although I am looking what Microsoft introduced new on Reporting Services. But after configuration end

How to Install SQL Server 2016

How to Install SQL Server 2016 Hi friends in this post we will learn how to install SQL Server 2016 or Installing SQL Server 2016. Here I am using Windows Server 2012 R2 Standard Edition 64 bit. I had applied all necessary updates & patches on windows server. Also install Windows Server 2012 KB2919355 &

Microsoft SQL Server 2016

Microsoft SQL Server 2016 Hi friends in this post we will discuss about Microsoft SQL Server 2016. Here we will discuss about SQL Server 2016 features, Download link etc.. Microsoft had just launched Microsoft SQL Server 2016 for Public, now anyone can download public Community Technology Preview (CTP2) for SQL Server 2016 from here  https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016. This

How to Search all Stored Procedures in a Database for a Particular String

How to Search all Stored Procedures in a Database for a Particular String Hi friends in this post we will discuss How to Search all Stored Procedures in a Database for a Particular String or Search all stored Procedures having a particular string. I have been asked by my Manager to send him a report all

Send SQL SERVER Query Result by Database Mail

Send SQL SERVER Query Result by Database Mail Hi friends in this topic we will learn how can we send query results through database mail in SQL SERVER, or you can say also how to Send SQL SERVER Query Result by Database Mail. Earlier we had discussed SQL Query Result set to Html Table. My manager told