Tag Archives: SQL Server

Finding Circular Dependencies in SQL Server

Posted on December 16, 2011 by Ashiq Alibhai, PMP

SQL Server doesn’t allow a cycle of foreign keys, nor two or more paths to cascadingly delete rows from a table. Thankfully, there’s a script you can use to detect at least table reference cycles. Continue reading →

Posted in Libraries, Web, Wndows Forms, WPF | Tagged , , | Leave a comment

Dropping an Active Database in SQL Server

Posted on September 14, 2011 by Ashiq Alibhai, PMP

How can you close open/active connections in SQL Server and drop the database? With a little statement like SET SINGLE USER. You can also abort transactions and force the database to drop immediately. Continue reading →

Posted in Tools | Tagged | Leave a comment

Searching the Entire SQL Server Database

Posted on September 8, 2011 by Ashiq Alibhai, PMP

How can you search every row and column in a SQL Server database for a specific string? Well, we link you to a handy dandy SQL stored procedure that does just that! Invoke it, and be amazed! Continue reading →

Posted in Tools, Web, Wndows Forms | Tagged , | Leave a comment

Selecting Encrypted Columns in SQL Server

Posted on September 7, 2011 by Ashiq Alibhai, PMP

Decrypting columns in SQL Server requires a security key and security certificate. You need to convert the resulting value into the correct type; we explain the process, and summarize what you need and how to do what you need to do. Continue reading →

Posted in Tools, Web, Wndows Forms | Tagged , | Leave a comment