Category Archives: Sql Server

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

SQL Query Result set to Html Table

SQL Query Result set to Html Table In this post we will discuss how to get SQL Query Result set to Html Table. Getting SQL query results to a html is very useful. It is very useful for reporting purpose. In my day to day activities as SQL Sever DBA i have to send a report

Change Data Capture in SQL Server

Change Data Capture in SQL Server Change data capture in SQL Server is a feature that is introduced in SQL Server 2008. And is called CDC (Change Data Capture). CDC helps SQL Server developers to archiving and capturing data changes without any additional programming. CDC only tracks changes in user-created tables. Because captured data is

SQL Server DBA Interview Questions and Answers for Experienced

SQL Server DBA Interview Questions and Answers for Experienced Qus: Different type of pages in SQL Server? Ans: The following table shows the page types used in the data files of a SQL Server database. Page type Decription Data It holds the data of the table for databases.The format of the page is header , data rows and

SQL Server DBA Interview Question Accenture

SQL Server DBA Interview Question Accenture In this post we will provide some SQL Server DBA Interview Question Accenture, these questions asked from one of friend recently go for interview in accenture for SQL Server DBA position. Qus: Difference between Log Shipping and Database Mirroring? Ans: Log shipping DB Mirroring Primary server, secondary server and monitor

Enable TCP/IP Protocol in SQL Server Configuration Manager Using Command Prompt

Enable TCP/IP Protocol in SQL Server Configuration Manager Using Command Prompt Hi friends, in this tutorial we will explain how to Enable TCP/IP Protocol in SQL Server Configuration Manager Using Command Prompt. Here we are not using GUI. This question is asked by one of my friend in a interview. First of all open command prompt

How to Configure User to Create and Manage SQL Server Agent Jobs

How to Configure User to Create and Manage SQL Server Agent Jobs Hi friends, in this tutorial I will explain you How to Configure User to Create and Manage SQL Server Agent Jobs. Sometime it is required to provide a user permission only for managing SQL SERVER AGENT. To manage SQL server agent you must

Find Fragmentation Level by using Command Prompt SQL Server

Find Fragmentation Level by using Command Prompt SQL Server In this post we will learn how to Find Fragmentation Level by using Command Prompt SQL Server. Find fragmentation in SQL Server is so easy, and that much in command prompt too. Query: —–Find database id with this query—- select * from sys.sysdatabases —-Find Fragmentation Level by