Dedicated administrator connections are not supported via SSMS as it establishes multiple connections by design Recently i am working on a Server and i want to use DAC (Dedicated Administrator Connection) via SSMS. But i have ended up with following error: Dedicated administrator connections are not supported via SSMS as it establishes multiple connections by design. […]
Category: Sql Server
SQL Server Tutorials, SQL Server Tutorials for Beginners, SQL Server Online Course, Microsoft SQL Server Learning, Microsoft Online Learing
Categories
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 […]
Categories
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 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 […]