Autoclose for Databases - Part II
In this quick article by Jon Reade, he shows you how to correct an unusual error in SQL Server that may occur when you create a database.
2003-03-12
5,628 reads
Articles
Managing Jobs Part 3
This week Andy looks at where, when, and how jobs should be run and why you need to think about those items before you build the job. Part of this is deciding what runs on production servers and what doesn't.
2003-03-11
7,148 reads
Migrating To A New Server : Moving Logins
The first article in a series about moving your data from one server to another. Steve Jones has some techniques he's used for upgrading hardware, replacing existing servers, or just moving to a different server.
2003-03-10
9,942 reads
Introduction to English Query and Speech Recognition
The first part of this series provides a road map for a very cool application using an under-utilized companion of the SQL Server 2000 database platform.
2003-03-07
8,261 reads
Analyzing and Optimizing T-SQL Query Performance Part 1
In this series by Quest Software's Kevin Kline, he shows you some tips to performance tuning T-SQL. This was contributed by Quest from their recent webcast. This white paper discusses various T-SQL discovery, optimization and tuning techniques using the SET and DBCC commands.
2003-03-06
2,669 reads
Who Owns That Database?
How many databases do you manage that have a NULL owner? Hopefully none, but if you have one, want to know how to fix it, or just need a few minutes break from work, dig in and read how I solved this annoying issue.
2003-03-04
8,817 reads
SQL Server Upgrade Recommendations and Best Practices - Part 1
This article is the first of a multi-part series detailing the SQL Server Upgrade process from the technical, logistical and business perspective.
2003-03-03
10,487 reads
Ways to Determine the Version and SP of SQL Server
There may be more ways than you realize to determine the version and service pack of SQL Server. This quick article by Dinesh Priyankara will show you 3 of those methods.
2003-02-28
22,119 reads
Freeware : DDL Source Safe Archive Utility
If your shop is even close to the typical Micosoft SQL Server environment there are several people that can (and do!) make changes to the production environment, a change management system is in place, that change management system uses Source Safe to store database scripts, and what's in Source Safe does not match what's on the SQL Server. This utility by Bill Wunder will archive your SQL scripts and DDL into Source Safe easily and efficiently. All for the price of $0 (yes, free!).
2003-02-26
285 reads
Pro Developer : This is Business
In his travels, Christopher Duncan has come to recognize a great many similarities between programmers and musicians. Both have the fire, passion and soul of the artist. And all too often, both are aweful when it comes to the business end of things. Business - you know, that aspect of your work where they actually pay you at the end of the day?
2003-02-25
3,502 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
SQL Server 2019 - Agent job PowerShell step issue
I have a couple of SQL Agent job steps which run PowerShell commands of...
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers