SQL Server Security Audit (Part 3) - Operating System Level Audit
The final part of the Security Audit series examines how to secure the Windows Server operating system.
Protecting the Encryption Keys
When you deal with encryption in your database, Steve Jones thinks you add a layer of complexity to your backup and recovery process. Do you agree? Answer today's poll.
Getting started with SQL Server Management Objects (SMO)
In this tip, I am going to discuss how you can get started with SMO and how you can programmatically manage a SQL Server instance with your choice of programming language.
How practical is a netbook?
I’ve I was having lunch with another SQL Geek and we were talking about netbooks and how practical they are....
Implementing a SQL Server Fast Track Data Warehouse
This paper defines a reference configuration model (known as SQL Server Fast Track Data Warehouse) and a CPU core-balanced approach to implementing a symmetric multiprocessor (SMP)-based SQL Server data warehouse with proven performance and scalability expectations for sequential I/O data workloads.
Protecting the Encryption Keys
When you deal with encryption in your database, Steve Jones thinks you add a layer of complexity to your backup and recovery process. Do you agree? Answer today's poll.
Protecting the Encryption Keys
When you deal with encryption in your database, Steve Jones thinks you add a layer of complexity to your backup and recovery process. Do you agree? Answer today's poll.
Protecting the Encryption Keys
When you deal with encryption in your database, Steve Jones thinks you add a layer of complexity to your backup and recovery process. Do you agree? Answer today's poll.
An interview with Josef Richberg - The Exceptional DBA of 2009
Josef Richberg, a DBA with HarperCollins Publishers, has been selected by judges and the DBA community as winner of 2009’s Exceptional DBA Awards, sponsored by Red Gate Software. Freelance writer Bob Cramblitt spoke to Richberg about the role of the DBA and the importance of sharing knowledge with the community.
FILESTREAM Setup and Testing without Visual Studio
A new article that shows a brief example of the FILESTREAM feature in SQL Server 2008 from new author Hugh Thomas. It looks at creating objects for testing, and importing a sample image.
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 SUBANG Telp:0817-866-887
WhatsApp:0817866887 Jl. Otto Iskandardinata No.37, Karanganyar, Kec. Subang, Kabupaten Subang, Jawa Barat 41211
Alamat kontak resmi BCA KCU KELAPA GADING Telp:0817-866-887
WhatsApp:0817866887 Menara Satu Sentra Klp. Gading, Jl. Boulevard Bar. Raya No.1 Lt. Dasar, 1,...
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
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