Many times when I am writing query I have to scroll the result displayed in the result set. Let us learn about the shortcut today.
SQL SERVER – 2008 – Fix Connection Error with Visual Studio 2008 – Server Version is not supported
While attending conference SQLAuthority Author Visit – Microsoft Student Partner Conference, some developers informed me that SQL SERVER 2008 cannot be connected to Visual Studio 2008 and error displays as MS does not support SQL Server version. I was surprised initially as I could not believe that two MS products are…
Read MoreSQL SERVER – Surface Area Configuration Tools Reduce Exposure To Security Risks
Read my article published at SQL Server Magazine Surface Area Configuration Tools Reduce Exposure To Security Risks [Articles are relocated so links are disabled] Reference : Pinal Dave (https://blog.sqlauthority.com)
Read More
SQLAuthority News – Download SQL Server 2017
This was a very old blog post and I have decided to re-write this as it was no longer useful. In this blog post, we will learn about SQL Server 2017. Here is how you can download SQL Server 2017 related material.
SQL SERVER – 2005 – Forced Parameterization and Simple Parameterization – T-SQL and SSMS
SQL Server compiles query and saves the procedures cache plans in the database. When the same query is called it uses compiled execution plan which improves the performance by saving compilation time. Queries which are parametrized requires less recompilation and dynamically built queries needs compilations and recompilation very frequently. Forced…
Read MoreSQL SERVER – 2005 – Fix : Error : Msg 7411, Level 16, State 1 Server is not configured for RPC
Error : Msg 7411, Level 16, State 1 Server is not configured for RPC This was annoying error which was fixed by Jr. DBA, whom I am personally training at my organization. I think he is going to be great programmer. He worked in my organization for more than 8…
Read More
SQL SERVER – 2005 – Connection Property of SQL Server Management Studio SSMS
Following images quickly explain how to connect to SQL Server with different connection property. It can be useful when connection properties need to be changed for SQL Server when connected. I use this in my company when I connect to one of our servers using named pipes instead of TCP/IP. Let us learn about Connection Property of SQL Server Management Studio SSMS.