Peer-to-Peer Replication in SQL Server 2008 – Configure a two-node topology
The first installment of this series describes the steps to configure a two-node Peer-to-Peer replication topology.
Performing Hierarchical Restructuring Using ANSI SQL
Discover the flexibility and power of using ANSI SQL to reshape and transform hierarchical structures.
Secure Storage
How do you keep the passwords and keys for encrypted data safe? Steve Jones comments on the challenges of working with keys and passwords.
Accessing SQL Server Databases with PHP
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.
I Need a Backup and I Need It Now
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 ...
Inside the new replication features for SQL Server 2008
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.
Mistakes in April
Steve Jones has a blooper reel for today that shows some of the things that happen when shooting a daily podcast.
Comparison of Dates in SQL
This article discusses a common mistake while making date comparisons in T-SQL and its resolution. From new author Manish Sinha.
Setting Up Database Mail - SQL School Video
Learn how to get started integrating mail with your SQL Server in this SQL School video. MVP Andy Warren shows how to set up Database Mail.
Blogs
SSMS Evaluation – future ready
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
Claude.ai vs Claude API
By Arun Sirpal
You have used Claude. But which Claude? The Claude app (claude.ai, the desktop and...
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
Forums
Alamat kontak resmi BCA KCU PURWAKARTA Telp:0817866887
WhatsApp:0817866887 Bank Bca Kcu Purwakarta, Jl. Jendral Sudirman No.85, Nagri Tengah, Kec. Purwakarta, Kabupaten...
Alamat kontak resmi BCA KCU SIDOARJO Telp:0817866887
WhatsApp:0817866887 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa Timur...
Alamat kontak resmi BCA KCU SUBANG Telp:0817-866-887
WhatsApp:0817866887 Jl. Otto Iskandardinata No.37, Karanganyar, Kec. Subang, Kabupaten Subang, Jawa Barat 41211
Question of the Day
Creating a JSON Document IV
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers