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.
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.
A Brief History of SQL
Frank has been part of our community for a while now, posting more than 1000 times (wow!) in our discussion area. He's decided to contribute more of his time by putting together an article that discusses how SQL has evolved.
Automate DTS Logging
DTS logging is a pretty handy feature - if you've got it enabled. Got lots of packages and want to turn it on for all of them? Thats a lot of point and click using EM, but with the code Haidong has put together, it's a snap. Other possibilities to this code as well. After all, it uses a DTS package to modify other DTS packages.
Where Do I Want To Go Today? - Index Tuning Wizard
Where should SQL Server go in the future? Steve Jones continues to explore his wish list for future versions of SQL Server. This article looks at an area where much improvement is needed: the index tuning wizard.
Normalizing Dates
Jon has been off in the land of C# and web apps for a while, but a recent project has him investigating OLAP and then coming up with a custom solution that met his needs. Jon helped us get this site off the ground, good to have him back for a guest appearance!
Troubleshooting Dynamic SQL
Troubleshooting performance problems takes a lot of time and work. This article outlines the process the author uses - pretty interesting.
Stored Procedure Development Cycle
This month Robert covers the process he uses for developing stored procedures. In many ways it reflects how software is developed, but it does have it's minor differences. This is a high level process discussion, not a line by line example of the entire process - by design of course.
Where Do I Want To Go Today? - From the Field
Where should SQL Server go in the future? What enhancements are needed? Steve Jones takes a break from his wishes to include some 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.
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers