PASS Virtual Chapters Late April Presentations
To finish up the month of April we’ve got sessions from AppDev and DBA and I’m even including one from PASS on ‘Intro to Speaking At PASS’.
How to Evict a Failed Node and Add it Back to SQL Server 2005 Cluster
Adding and removing nodes in SQL Server Clusters is not so difficult, and instructions on how to do so abound on the internet. However, mismanagement when adding/removing nodes can quickly become a 'gotcha' that wastes time. Bo Chen offers insight into some of those scenarios that are not normally covered in the standard online documents.
Help, my database is corrupt. Now what?
The stuff of nightmares, a corrupt database. However Gail Shaw gives you some advice about how to handle this situation.
Row Oriented Security Using Triggers
Handling security in an application can be a bit cumbersome. R Glen Cooper brings us a database design technique from the real world that can help you.
Spring Cleaning
For a Friday poll this week, Steve Jones is looking at those spring cleaning or annual maintenance activities that you might perform on your systems.
Retrieve Default SQL Server Backup Folder using PowerShell
In a previous tip on creating a Function to Return Default SQL Server Backup Folder , you've seen how you can create a T-SQL function to query the registry and retrieve the default SQL Server Backup folder. Is there an easier way to do it in Windows PowerShell?
SQL Server 2008 Compression
Testing and analysis of new backup compression and table/index compression features of SQL Server 2008.
What Do We Want?
Today Steve Jones talks about the challenges of deciding what to include in that next software release. Something that likely isn't as easy as we might think it should be.
Basic Defensive Database Programming Techniques
We can all recognize good-quality database code: It doesn't break with every change in the server's configuration, or on upgrade. It isn't affected by concurrent usage, or high workload. In an extract from his forthcoming book, Alex explains just how to go about producing resilient TSQL code that works, and carries on working.
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