Free SQL Functions & Stuff!
Wingenious is offering a free download of some add-in code you may find very useful! It's a subset of their DBAction product (which they you'll look at as well), but the free code is worth a look.
2003-09-24
48 reads
Articles
Using sp_addalias
SP_addalias isn't a well known stored procedure to most DBA's - do you know what it does? In what situations you might use it? This short article gives very quick and clean answers to both of those questions.
2003-09-23
9,637 reads
Where Do I Want To Go Today? - From the Field 2
Where should SQL Server go in the future? What enhancements are needed? Steve Jones takes another break from his wishes to include some more feedback from users who have some wishes of their own. Read about what real users of SQL Server would like to see included in future versions.
2003-09-22
3,566 reads
Best of SQLServerCentral.com 2002 Launch
We've had a soft launch under way for the past week, but now we'd like to sell the rest of the books stacked up at Andy's house! $15 plus shipping will get you a book that you'll be proud to put on your bookshelf. Read this to get latest pricing and answers to the most recent questions we've gotten.
2003-09-19
2,961 reads
Build a lot of DSN's in a hurry!
This article by Andy Warren offers a free utility that will generate DSN's for all or just a subset of the databases on a server in seconds.
2003-09-19
10,040 reads
Problem Solving With Information Schema Columns
Directly accessing system tables is discouraged - so what's the alternative? Using the Information Schema should allow you to create code that survives upgrades. Beyond that, what can you do with it? Joe has four great examples to get you started.
2003-09-18
14,662 reads
SQL and Java Go on a Date
Chris discusses some issues he had trying to use SQL dates from within Java. Interesting stuff and brings up the point that if you have dates stored in local time, having users in multiple time zones can be a large headache.
2003-09-17
12,499 reads
Where Do I Want To Go Today? - Included Indexes
Where should SQL Server go in the future? What enhancements are needed? Steve Jones continues to explore his wish list for future versions of SQL Server.
2003-09-15
4,135 reads
Review: Data Compare v3.01
Andy reviewed v1.51 almost two years ago, this week he looks at the latest release that includes one feature he really wanted - the ability to compare and sync text columns.
2003-09-12
8,547 reads
Upgrading to Windows 2003
Chris has been working through the process of upgrading to Win2003 and has the start of a great checklist along with few lessons learned - stuff that will come in handy it's time for you to do your own upgrade.
2003-09-11
10,926 reads
Blogs
The Benefits of Teaching
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
Power BI, Excel, OneLake – Dreams Do Come True!
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
The Book of Redgate: What Our Staff Says
By Steve Jones
This image is from 2010, and it goes along with my last post of...
Forums
Website Stability 2025/12/05
All week we've had issues with the site being up and down. There's been...
403 Forbidden
I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...
Question of the Day
Fabric Mirroring
In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?
See possible answers