I've written quite a few posts lately on networking and a very common question is - where's the results? What do I get out of all the effort, and so far my best (if lame) answer is that networking is an investment based on faith that...
The first installment of this series describes the steps to configure a two-node Peer-to-Peer replication topology.
Discover the flexibility and power of using ANSI SQL to reshape and transform hierarchical structures.
How do you keep the passwords and keys for encrypted data safe? Steve Jones comments on the challenges of working with keys and passwords.
The SQL Server 2005 Driver for PHP is a Microsoft-supported extension of PHP 5 that provides data access to SQL Server 2005 and SQL Server 2008. The extension provides a procedural interface for accessing data in all editions of SQL Server 2005 and SQL Server 2008. The SQL Server 2005 Driver for PHP API provides a comprehensive data access solution from PHP, and includes support for many features including Windows Authentication, transactions, parameter binding, streaming, metadata access, connection pooling, and error handling.
Have you ever wished that creating a backup on the fly was easier and quicker? Whether you do it with the GUI or with T-SQL, you still have to open up Management Studio, connect to the database, and go through the steps. You have to figure out ...
SQL Server 2008 features several replication improvements, and some are more compelling than others. Learn what's new with peer-to-peer topologies, merge replication and more.
Steve Jones has a blooper reel for today that shows some of the things that happen when shooting a daily podcast.
This article discusses a common mistake while making date comparisons in T-SQL and its resolution. From new author Manish Sinha.
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
Hello experts, An application team has asked us to modify a SQL Agent job....
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Comments posted to this topic are about the item Finding Bad Queries