Updating a Cryptographic Provider for EKM with Azure Key Vault - Level 5 of the Stairway to TDE
This next level of the Stairway to TDE shows how to upgrade your EKM cryptographic provider.
Who is Irresponsible?
It can be irresponsible to use AI, but is it in many cases? Steve has a few thoughts.
How to Draw Line Graphs in SSMS
Ever just need a quick visualization of some numbers to get a rough idea of the trend, like this
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
What a DBA team actually deals with There are many issues a DBA team faces, from servers going down to login access not being requested on time. These are not glamorous problems, but they are the problems that stop everyone else doing their jobs. In a modern environment you would expect a lot of the […]
Everything you should know about the SQL Server Resource database
Every SQL Server instance contains a database that most people never query, never back up, and never even see in Object Explorer. Yet, without it, SQL Server would not start. Enter the SQL Server Resource database.
Don't Panic
And bring a towel. If you don't know what I'm talking about, you have homework. You know with that lead in I'm going to talk about AI. Sorry, can't help it. It's on my mind quite a lot. It's in the news, oh, a whole lot. The majority of those stories can be summed up […]
Acting with Confidence
Acting with confidence is great, but how do you decide when there are potential impacts and concerns about your actions? Steve has a few thoughts today.
Creating a Simple and Flexible Random Password Generator in SQL Server
Generating temporary passwords is a common requirement in many applications. Users may need to reset a forgotten password, new accounts may require an initial password, or developers may generate test credentials. While password generation is often implemented in application code, doing it directly in SQL Server provides clear advantages. It centralizes the logic, ensures consistency […]
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP Kedaton TLP/WA 08216977701
Jl. Teuku Umar No.49, RT.005/RW.001, Surabaya, Kec. Kedaton, Kota Bandar Lampung, Lampung 35141
BCA KCP Rawasari, Telpon/wa 0821-3111-159
Jl. Rawasari Sel. No.24 A, Rawasari, Kec. Cemp. Putih, Kota Jakarta Pusat, Daerah Khusus...
BCA KCU SCBD Wa 083179431656
Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E, Jl. Jenderal Sudirman...
Question of the Day
Creating a JSON Document III
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 TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers