SQLServerCentral Article

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!

Technical Article

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.

Technical Article

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.

Blogs

A New Word: Dorgone

By

dorgone– adj. wondering if you could slip away from an event or group conversation...

Tell It Once: Setting Up Claude With Skills and MCP Servers

By

Many of us use AI the same way every single day. Open a tab....

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident

By

SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...

Read the latest Blogs

Forums

does anyone used https://github.com/ktaranov/sqlserver-kit

By ARUN KUMAR AGUNURU

Could you please let me know if anyone is used https://github.com/ktaranov/sqlserver-kit github for deployment...

How Can Database Performance Improve the Overall Website Experience?

By Brooks-Hayward

I’ve been looking into ways to improve the connection between a website and its...

When And How to Automate?

By AndrewGuard

Comments posted to this topic are about the item When And How to Automate?

Visit the forum

Question of the Day

Hyperscale Replicas II

How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?

See possible answers