Microsoft SQL Server 2005 provides nonlocking, nonblocking read consistency to your users through snapshot isolation and read committed isolation using row versioning. Find out when you can use these features to improve performance and reduce latency in your applications.
This is the introductory module for the SSC Online Video Training course, Becoming a Profiler Master. In it, MVP Brad McGeHee will discuss some of the critical factors that might persuade you of the need to master this powerful SQL Server profiling tool.
Steve Jones has a blooper reel for today that shows some of the things that happen when shooting a daily podcast.
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.
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Jl. Sultan Hasanuddin Dalam No.43/48, Melawai, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah Khusus...
Jl. Ir. H. Juanda No.66, Lb. Siliwangi, Kecamatan Coblong, Kota Bandung, Jawa Barat 40132
BCA KCP Klender Tlpn:CS.0853•5504•2311 Jl. I Gusti Ngurah Rai No.8 A-B, RT.8/RW.6, Wil, Kec....
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers