Procedure Cache-Part II

Refer to our video blog , to know the important role that  “Procedure Cache”  can play  in increasing your application and SQL server performance. Procedure Cache, main goal is to cache the query plans  and allow its reuse and thus minimize the compile time and improve the performance. This blog will provide you detailed information…

1

Procedure cache – Part I

Refer to our video blog , to know the important role that  “Procedure Cache”  can play  in increasing your application and SQL server performance. Procedure Cache, main goal is to cache the query plans  and allow its reuse and thus minimize the compile time and improve the performance. This blog will provide you detailed information…

0

Troubleshooting Kerberos Delegation Using DelegConfig

Gain an expertise in solving the “Kerberos Delegation” issues using one of the useful troubleshooting tool for Kerberos i.e. DelegConfig. Refer to our video blog, that will provide you a step by step guidelines as to how to use this tool in resolving Kerberos Delegation. Highlights of the blog:- Troubleshoot Kerberos Delegation Step by Step…

0

What’s execution log in Reporting services?

Check out our video blog to gain in depth knowledge about importance of “Execution Log”  in reporting services. In this blog you will get to know more about the following :- What is execution log? Where to check for execution log? Information provided by Execution Log How to Manage Execution Log. For better quality of…

0

Transparent Data Encryption (TDE)

Leverage our video blog to empower your knowledge on TDE.  Highlights of this video blog :- 1. Introduction to  TDE2. How to implement TDE.3. Advantages of TDE4. Changing DEK5. Removing Encrypted database6. Migrating the encrypted database For better quality please check the link:- https://channel9.msdn.com/posts/Transparent-Data-Encryption-TDE    Presented By : – Shraddha Gupta,SE,Microsoft GTSCReviewed By: –   Gaurav…

0

Demystifying SQL server memory concepts video

Leverage our video blog to empower your knowledge on “SQL Memory”.This video will help you to gain in depth expertise to following topics :- 1. More about Process Address Space2. SQL Server 32 bit Memory Architecture3. AWE4. Managing SQL Server Memory5. Limitations of 32 bit SQL Servers   To watch this video in better quality…

3

Multiserver administration

In this video presentation you will learn in depth about Multiserver administration For better quality/download please check the link: – https://channel9.msdn.com/posts/Multi-server-Administration Presented by: Phani Raj,SE,Microsoft GTSC Reviewed by: Akbar Farishta,TL,Microsoft GTSC    

1

Your SQL Server Setup may hang forever when it’s almost at the 99 %!

Consider this scenario, I rebooted several times, disabling my favourite antivirus and still unable to get a clue from all the logs possible. I start looking at my favourite blogs and here I am. Check out if your symptoms match the following. “I am installing SQL Server including reporting services and my setup is getting…

0

SQL Server could not create a subscription for Subscriber ‘ServernameInstanceName’.The value for the @sync_method parameter is not valid

Recently we worked on a support case where creation of a Subscription was failing with the following error:- TITLE: New Subscription Wizard —————————— SQL Server could not create a subscription for Subscriber ‘Servername\InstanceName’. —————————— ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) —————————— The value for the @sync_method parameter is…

1