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.
2002-11-12
10,012 reads
Administration
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?
2002-11-11
9,228 reads
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.
2002-11-01
694 reads
Hidden Connections
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,384 reads
Alternatives to SQL Backups
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,420 reads
Open Source ASP Enterprise Manager in Design Phase
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,826 reads
Conflicting Instructions
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,449 reads
Using Check Constraints
Check constraints can be added to a table to enforce specific rules on one or more columns. This article shows you how to use them to enforce simple and more complex rules.
2002-10-03
16,268 reads
Worst Practice - Sorting by Ordinal
If you've been with us for a while you know that Andy started a series last year on worst practices. As he says, maybe you can't always do best practices, but at least dont do the worst ones. Read the article and add a comment, participate!
2002-10-01
7,468 reads
Push Those Logs Away!
Steve found a gaping hole in his backup process. One that he plugged with this script to move log files around the network in the event of a server failure. If you can't afford to lose a day of work, read about his solution.
2002-09-30
6,272 reads
Blogs
Andreas Wolter on Evading Data Access Auditing
By Brian Kelley
There are always bad actors who will seek to get access to and, likely,...
Adding a Named Default Constraint to a Table: #SQLNewBlogger
By Steve Jones
As part of a demo recently I was adding a default value to a...
Using Python Code in SSIS
By Tim Mitchell
SQL Server Integration Services (SSIS) is a mature, proven tool for ETL orchestration and...
Forums
NKTg Law on Varying Inertia – A Different Way to Think About Motion
Hi everyone, I’d like to share something from the science side of life rather...
How to create your custom GPT SQL Expert
Comments posted to this topic are about the item How to create your custom...
Storage Enhancements
Comments posted to this topic are about the item Storage Enhancements
Question of the Day
Getting Azure SQL Database Permissions
When I run this on Azure SQL Database, what is returned?
SELECT * FROM sys.fn_builtin_permissions('Server') AS fbp See possible answers