|
|
-
|
|
SQL Server has the ability to enforce organzational security policies for SQL login passwords. This can be bypassed by using the CHECK_POLICY clause in the CREATE LOGIN statement. However, when using hashed passwords, no such restrictions seem to apply....
|
|
-
|
|
Working with SQL Server logins and users is one of the most important and critical activities when moving databases from one SQL Server instance to another. The hash value for SQL Server logins created in SQL 7.0 or earlier are 16-bit values and are no longer compatible with SQL Server 2012....
|
|
-
|
|
In this post, we see that temporary tables allow the use of only 116 characters out of a possible 128. How are temporary tables named, and what happens to the restricted length of 12 characters? What is the naming logic for temporary tables?...
|
|
-
|
|
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....
|
|