Removing Orphan Users from All Databases on Server
In this article by Greg Larsen, he shows you how to remove those pesky orphaned users that can be a security risk after restoring to a new server.
Best SoftTool Announces SQLSourceSafe 2.0
Best SoftTool, Inc. today announces that its flagship product SQLSourceSafe 2.0 is available for download and purchase. SQLSourceSafe is the integrated solution that Best SoftTool provides to meet the mounting market demand for a solid version control system for SQL Server database development. SQLSourceSafe integrates Microsoft Visual SourceSafe® and Microsoft SQL Server® together, offers robust and advanced version control functions to database scripts in SQL Server.
Creating Your Dream Project
In this article, columnist Christopher Duncan shows you how to create your dream development project.
What is the search order for Procedures prefixed sp_?
In this article, James Travis covers a common performance topic of prefixing stored procedures sp_. Does it really slow down performance?
A Sneak Peek at Entegra
Recently, the SQLServerCentral.com labs had the chance to get a sneak peak at Lumigents latest creation, Entegra, which is scheduled to ship in the second week in December. Entegra monitors database activity and provides a complete record of access to the data and changes to database structure and permissions.
Move Your Master
How often do you move your master database? Hopefully never, but this article looks at an easy technique should you need to perform this trick.
Worst Practice - Not Having An Archive Plan For Each Table
We're curious to see what our readers have to say about this one! How many of us have tables accruing data that won't be used and/or isn't of any value? At what point do we get rid of it to free up resources?
Streamlining the Database Server Recovery Process
Are you tired of manually restoring each database on a new server when the original server has a melt down? Does the manual process seem slow, and prone to keystoke and mouse click errors? Would you like to have those restore scripts automatically built, so you only have to fire them off? Well this article will show you one possible method for speeding up and reducing errors will trying to perform a restore of all databases on a server.
Why Secure the Database?
You're behind a firewall, you have passwords. Why spend any great amount of time on extra database security? Steve thinks there are a few reasons why in this article.
SQL Server Notification Services Documentation
Microsoft has released the "Books Online" equivalent for Notification Services. Browse through and take a look to see if this service is useful to you.
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers