Editorials

SQLServerCentral Editorial

Why Billing Will Be Part of Our Job

I am old enough to remember when many large corporations implemented chargebacks. Essentially, each internal department was charged for their usage of IT systems, similar to how we are charged in the cloud. It was a mess, and individual departments had to answer for excessive charges. I don't know that any department ever lost service, […]

You rated this post out of 5. Change rating

2020-06-18

243 reads

SQLServerCentral Editorial

What is Azure SQL Database Serverless?

I remember when the first SQL databases were available on Azure. The size limits and missing features made them impractical for most uses at the time. Fast forward 10 years and you can you create a terabyte database and take advantage of configurations like Hyperscale, Elastic Pool, and Managed Instances. You get automatic high-availability and […]

You rated this post out of 5. Change rating

2020-06-13

694 reads

SQLServerCentral Editorial

Are You a Gatekeeper?

One of the problems that I've seen in many parts of life is the belief that things must proceed a certain way. I caught an article on ways teachers have made school less fun for kids because they adhered to some rule or belief too tightly. I think many of those stories are true because […]

You rated this post out of 5. Change rating

2020-06-12

189 reads

SQLServerCentral Editorial

What's a Normal SQL Server?

Many of us have worked in environments that have a number of SQL Server instances. Different versions, editions, and mostly different hardware profiles. We deal with different applications and software that places different demands and requirements on our database systems. Some of us are even dealing with multiple datastores, trying to integrate SQL Server with […]

You rated this post out of 5. Change rating

2020-06-09

199 reads

SQLServerCentral Editorial

Double Half and Quarter

I've worked in a a couple very high performing organizations that adapted to changing conditions and built software well. I've worked in more poorly performing organizations that struggled to release updates and patches, causing tremendous stress for the IT staff.  DevOps is designed to help improve our software delivery and quality, if you work on […]

(1)

You rated this post out of 5. Change rating

2020-06-08

111 reads

Blogs

Microsoft announces new cybersecurity AI multi-model

By

Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included...

Getting the SQL Server MCP Server Running

By

If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...

Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations

By

Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...

Read the latest Blogs

Forums

ALAMAT KONTAK BCA KCP Alaydrus Telp:08218154392

By Layanan_BCA_24jam

WA CS (08218154392) Jl. Alaydrus No.47 & 47 A, RT.8/RW.2, Petojo Utara, Kecamatan Gambir,...

ALAMAT BCA KCU RAWAMANGUN Telp:08218154392

By Layanan_24jam

WA CS (08218154392) Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur,...

Alamat Kantor BCA KCU City Tower Telp:08218200233

By layanan_Bca88

Wa:628218200233 Alamat. Jl. M.H. Thamrin No.81 Ground Floor, RT.1/RW.6, Dukuh Atas, Menteng, Kec. Menteng,...

Visit the forum

Question of the Day

Symmetric Key Encryption

If I run this statement in SQL Server 2025, how is the password encrypted?

CREATE SYMMETRIC KEY MySymmetricKey
WITH ALGORITHM = AES_256,
KEY_SOURCE = 'My secret key source passphrase',
IDENTITY_VALUE = 'My secret identity value'
ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7';
GO

See possible answers