Category Archives: Sql Server

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

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

TSQL-Checking Database Recovery Model

TSQL-Checking Database Recovery Model In this post we will learn how to check recovery model of all database hosted on your SQL Server or you can say TSQL-Checking Database Recovery Model. This is very easy we just have to run a script to do this. Earlier we had discussed about Change Data Capture in SQL Server, DDL Triggers

How To Know Uptime Of SQL Server By TSQL

How To Know Uptime Of SQL Server By TSQL Hi friends, in this post we will discuss how to know uptime of SQL Server by TSQL or you can say how to check sql server uptime through tsql. Earlier we had discussed about SQL Server Schema Ownership, How to create a database in sql server with Tsql, Enable

DDL Triggers to Audit Database-SQL Server

DDL Triggers to Audit Database-SQL Server In this post we will discuss how to audit database with DDL trigger or DDL Triggers to Audit Database-SQL Server. By this we can track all DDL events performing on a database, what was changed, when and by whom . Enable TCP/IP Protocol in SQL Server Configuration Manager Using Command Prompt

Central Management Server In SQL Server

Central Management Server In SQL Server Central Management Server In SQL Server designate an instance of SQL Server as a central management server in SQL Server. Central management servers store a list of all instances of SQL Server that is organized central management server groups. Actions will act on all servers in the server group of central