T/SQL Code to remove SQL Injection Values from your tables
With SQL Injection Attacks being all the rage these days, I’ve been asked a couple of times for T/SQL code to clean up the database. So I threw this code together to clean up the data. This code will clean all the character and uni-code columns in all the user defined tables in the system. […]
SQL Server consolidation: Why it’s an optimization technique
This morning I released another tip on SearchSQLServer.com called “SQL Server consolidation: Why it’s an optimization technique“. It’s a quick overview on consolidating SQL Server Instances onto a single server along with some of the gotchas. Denny
Decreasing Network Traffic and Network Latency When Using Replication
When dealing with a high load replication environment network latency and network traffic can become as issue. There are a few settings you can play with, within the subscription agents themselves such as the –PacketSize, -UseInprocLoader, and –SubscriptionStreams. While working with these settings may or may not help (personally I’ve had very limited success getting […]
A Load Balanced Federated Database Solution
If you have a very high load on your database, but no specifically massive tables you may want to look into a fully load balanced solution for your database. This solution falls somewhere between your normal replication solution, and a federation solution. It’s not truly a federation as no one table is spread across several […]