|
|
-
|
|
How can connection strings be used to change the behaviour of an application? In this post, we explore the use of the system function APP_NAME(), which returns the application name for the current session if set by the application....
|
|
-
|
|
In this post, I explore whether one can use the SQL Server Management Studio (SSMS) can be used to test a connection string. This is related to the post I wrote ealier about how adding the Application Name and the Workstation ID in a connection string are recommended best practices because these would help system administrators and DBAs troubleshoot problems faster....
|
|
-
|
|
Can connection strings help application implement auditing and changing behaviours based on the calling application? Can a well-defined connection string aid administrators in troubleshooting problems with an application? Here's a best practice that I follow: Always use the Application Name and Workstation Id parameters....
|
|
-
|
|
Completion mode for Intellisense in the SSMS for SQL 2012 does not work in the same way as it used to in SQL 2008. In today's post, I explore how to toggle completion mode and make Intellisense in SSMS 2012 behave similar to SSMS for SQL 2008....
|
|
-
|
|
While working on the query editor, I often find myself requiring to switch over to the Object Explorer window. In such cases, I use a little known, underappreciated feature hidden within the pop-up menu of the query explorer. Today, I share this SSMS productivity tip with you....
|
|
-
|
|
We know the sequence in which system databases are made available during restart recovery. However, if a SQL Server instance has multiple user databases, what is the sequence in which these user databases are brought online?...
|
|
-
|
|
Have you ever wondered as to which database is first made online when a SQL Server instance starts? When are user databases made available in the startup sequence? When is the tempdb available? Today, I try to find answers to these questions....
|
|
-
|
|
If you wish to copy the column headers from the results tab of the SQL Server Management Studio (SSMS) alongwith the results to another program like Excel, use the built-in functionalities of the SSMS demonstrated in this post....
|
|
-
|
|
Queries appear to behave in a similar way under NOEXEC and FMTONLY SET options. Hence, how is FMTONLY different from NOEXEC? Does it really execute a query when there are no visible side-effects of the query execution? Today's post attempts to answer this question....
|
|
-
|
|
If applications need to know the format of the response and test a query without actually running the query in SQL 2012, they can use sp_describe_first_result_set, sys.dm_exec_describe_first_result_set or sys.dm_exec_describe_first_result_set_for_object. The query is parsed, compiled, executed and only the meta-data is returned to the client application....
|
|