A Viable IIS Alternative? Apache 2.0 on Windows 2000
Brief introduction to Apache v2.0 with links to performance/setup and installation and other information.
2002-05-03
692 reads
Articles
Making Dynamic Queries Static
Building and executing dynamic sql in a stored procedure - is it the only way to solve problems like supporting a simple search function? Leon offers a couple alternatives that let you continue to provide the functionality in a stored procedure without using dynamic sql. Interesting ideas worth exploring!
2002-05-02
13,072 reads
Hotek, Tripp Launch PASS Regional Seminars
SQL Server MVP Mike Hotek and industry expert Kimberly Tripp launch the latest SQL Server educational offering from PASS - one day seminars beginning this June in Chicago and August in Las Vegas. Join Mike and Kim as they demonstrate their expertise on SQL Server replication and tuning high performance SQL Server 2000 databases. Space is limited. Seminar details and convenient, secure online registration is available at http://www.sqlpass.org/events/seminars.
2002-05-02
3,246 reads
Press Release - RedGate Announces SQL Server Compare
RedGate software has announced their newest product, SQL Server Compare, a new tool for comparing and synchronizing SQL Servers. Read the press release!
2002-05-01
2,418 reads
Supplement to 'Converting Shaped Recordsets into XML'
Jon Winer further discusses some comparisons using ADO versus the XML DOM to parse shaped recordsets. This article is a supplement to his previous article titled: Converting Shaped Recordsets into XML.
2002-04-30
3,901 reads
SQL Server DMO Resources
As I work with a particular topic or problem, I often research on the Internet
different opinions, white papers, etc. Here is a list of resources that are located both
on SQL Server Central and other sites that I have found useful.
2002-04-29
6,347 reads
Multiple Monitors
Want to get more productive? Fit more work into normal working hours? Steve Jones found a relatively inexpensive hardware upgrade to help you.
2002-04-26
4,197 reads
Choosing an Edition of SQL Server 2000
Whether you are a developer, IT professional, or a database administrator, whether you are just developing and testing or are ready to deploy in production, there is a SQL Server 2000 edition for you and your organization. This paper will inform you about the differences among the various editions of SQL Server 2000, and how you can save time and money by choosing the right one for the job.
2002-04-24
1,375 reads
SQL Server DTS Resources
A list of DTS resources, including bugs, issues, books, and some good programming resources.
2002-04-18
13,755 reads
Tips for Performance Tuning SQL Server Transactional Replication
From this real-world case study, learn how you can boost SQL Server performance and scalability by off-loading reporting from your production SQL Server to a reporting server, using transactional replication.
2002-04-18
1,960 reads
Blogs
Parsing EXE Output in PowerShell
By Steve Jones
I saw a post internally that asked this question: Anyone have a handy powershell...
Connect With More Clients: Our Partner Directory Has Arrived
By Rob Sewell
The partner directory connects your agency with new customers.
Can You See Who Forced a Plan
I had an excellent group of people in Gothenburg Sweden when I taught there...
Forums
GIT Configuration and Automated Release for Azure Data Factory
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Output to flat file with no delimiter
Hello all, Is there an easy way to output my records to a flat...
Refactoring Databases: Evolutionary Database Design
Comments posted to this topic are about the item Refactoring Databases: Evolutionary Database Design
Question of the Day
Concat Addition
What is the result of this code?
SELECT CONCAT(1, 2, 3) + 4See possible answers