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.
2002-11-04
4,477 reads
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.
2002-11-04
4,477 reads
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.
2002-11-01
694 reads
Andy Jones recently faced a requirement to load several flat files on a nightly basis. In this article, Andy Jones shows you how he accomplished this and shows plenty of code!
2002-10-31
11,216 reads
Microsoft has formally clarified the support life cycles for it's products. See where your products fall in and be sure to plan for upgrades.
2002-10-30
3,333 reads
Ever have strange DTS errors after moving a package? You changed all the connection strings, but still get connection errors. Steve Jones did and tracked down one potential culprit.
2002-10-29
4,375 reads
All of do us regular backups. Ok, all of us SHOULD do regular backups. In this article Andy comments on why having a backup plan isn't enough and why you should look at some other options for when you need to fix data errors. This really speaks to the goal of minimizing down time using low tech, readily available solutions. If you're not interested yet, we'll add this - one of the alternatives he suggests is Microsoft Access!
2002-10-28
8,392 reads
This article explains how to use a simple batch file and script file to manage multiple databases on multiple servers.
2002-10-24
9,925 reads
Andy relates some info he got from Wes Grant about his freeware and open source project to build a web based admin tool for SQL that is currently in the design/initial coding phase. Get the scoop and maybe write some of the code too!
2002-10-22
4,819 reads
Ever have problems following something from Books Online? There may be a reason. Microsoft has noticed as well and there are updates for this valuable DBA tool. Here's a sample of the changes and a link to get the update.
2002-10-21
4,444 reads
In this short article by Jamie Voss, he shows you the data model behind much of his task tracking system and the reasoning behind it.
2002-10-17
7,040 reads
This article provides a comprehensive overview of the ORDER BY clause within SQL window...
Want to build a data analytics foundation that transforms raw data into valuable business...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I'm using the below connection string using providing UserID and password on their respective...
Comments posted to this topic are about the item Knowing Your Total Reward