Problems with Big Data
Today Steve Jones notes that Big Data isn't a panacea. It's not going to just solve all problems.
How much overhead does encryption add to a SQL Server query
If you have been in the information technology industry long enough, you have probably heard the expression "this adds overhead" when discussing any extra processing added on to what is considered normal processing. Dallas Snider answers the question of additional overhead caused by encryption.
Divide and Conquer - Performance Tuning
Sometimes we need to break down a complex problem into a multiple stage solution to achieve optimal performance
Lobbying for Change
The Connect system from Microsoft doesn't work that well, but that doesn't mean we shouldn't continue to press Microsoft for change.
14 SQL Server Indexing Questions You Were Too Shy To Ask
The first thing you need to understand about SQL Server is indexes, but somehow many of the basic questions don't often get asked or answered much on forums. Rob Sheldon answers some of these questions about SQL Server Indexes and indexing.
SQL Saturday #289 - Orange County, CA
SQL Saturday is coming to Huntington Beach, CA on April 26 2014. This is a free day of training and networking for SQL Server Professionals - there are also 2 paid-for precons on April 25 presented by Jason Horner and Bradley Bell. Register for SQL Saturday Orange County while space is available.
Short Stroking and Performance
Disk performance can make a difference to your SQL Server instance. Steve Jones discusses a few things this week.
Load Testing in a Big Data Environment
Load tests give the database administrator quite a lot of valuable information and may make the difference between poor and acceptable application performance. But are there any gotchas or traps associated with big data?
Getting Started in SQL Server
Preparing for your first (or next) interview or job in SQL Server. A good introduction from Craig Farrell.
Team Reputation
The way that various departments might view a team of technology employees can affect how we interact. Andy Warren remembers a few situations and notes it's always more fun to join a team with a good reputation.
Blogs
Data Engineering Books Worth Having on Your Shelf (or your tablet)
Good documentation gets you started. Good books get you deep. After years of working...
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...
Forums
SQL Server Showing Out of Space But Plenty of Drive Space
We have a SQL Server installed. We have a 500GB drive for the database....
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