|
|
-
|
|
My blog on BeyondRelational.com (BR) is completing two years today! Here's a quick snapshot of the splendid & exciting journey that these two years have been....
|
|
-
|
|
How can one implement a scenario wherein a table needs to be passed over to a stored procedure, modify the table inside it and then consume the results outside of the procedure? We can share temporary tables through stored procedures and today we look at the various scope definitions of these temporary tables....
|
|
-
|
|
Often the most obvious information can be the most confusing - What does the "Number of Users" value in the Database Properties window of the Object Expolrer in SSMS really stand for? This post answers the question....
|
|
-
|
|
If you reference URLs to TFS defects/work items/enhancements, a Sharepoint page or a blog citation in your T-SQL code, ensure that the "Enable single-click URL navigation" switch is checked so that you can navigate to the URL via a simple key & mouse click combination....
|
|
-
|
|
In this post, I walk you through how to restore broken file associations using the SQL Server Management Studio (SSMS) for SQL 2012....
|
|
-
|
|
What do you do when you need help on a DBCC command without using the Books On Line? You can use the DBCC HELP command to get syntax/parameter related help for the documented DBCC commands....
|
|
-
|
|
When you drop a SQL Server database, associated SQL Server Agent jobs are not dropped with it. Presenting a simple query that can be used to identify SQL Server Agent jobs that used to be targeted to a database, but the database no longer exists....
|
|
-
|
|
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....
|
|