The Value of Your Time
DBAs are expensive, so isn't their time valuable? Are you aware of what you cost the company and use your time wisely? Steve Jones talks a bit about how to choose on what you should be working.
The Value of Your Time
DBAs are expensive, so isn't their time valuable? Are you aware of what you cost the company and use your time wisely? Steve Jones talks a bit about how to choose on what you should be working.
The Value of Your Time
DBAs are expensive, so isn't their time valuable? Are you aware of what you cost the company and use your time wisely? Steve Jones talks a bit about how to choose on what you should be working.
Happy President's Day 2009
Steve Jones takes a break today and gives you a fun reel of mistakes and bloopers.
SQLBits IV and a Day of Training
SQLBits IV is taking place this March in Manchester. Read on about where to register and how to get some training the day before as well.
State Models - Database Weekly (Feb 16, 2009)
Testing software is important, and the use of state models can help. This week Steve Jones talks about a new book that exposes software testing at Microsoft.
Securing SQL with access control and login monitoring
SQL Server login monitoring and access control are important elements of SQL database security. Learn how DDL triggers can help alert you to security issues.
SQL Server 2008 Installation Process
I have heard that the installation process for SQL Server 2008 differs from previous installation processes. So, how much different is the installation process? In this three-part tip series, we will review the installation process for SQL Server 2008, which differs quite a bit from SQL Server 2000 and SQL Server 2005 installations.
Things I Wish I Had Known
I was tagged by Grant Fritchey (aka Scary DBA) in the latest get-to-know-you question. This one asks, “What do you wish you had known when you started?” I could go on for hours about the things I wish I hadn’t had to learn the hard way, but..
Things You Know Now…
Someone tagged me, and I’ve lost the email in all the pile up from vacation where I was very, very unwired from work, despite being wired to the world. Actually I’ll make that one my first thing: Know When to Walk Away Not quit, not stop progressing on...
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 SOLO BARU
Tlp/Wa_Cs: 0817866887 Kawasan Terpadu The Park, Jl. Ir. Sukarno, Solo Baru, Madegondo, Kec. Grogol,...
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
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