Column-Level Encryption in SQL Server
Beginning with SQL Server 2005, column-level encryption and decryption capabilities were made available within the database, providing a solution for situations where one-off types of data need to be secured beyond your existing authorization, authentication or firewall settings. This article provides an overview and example of securing a column using native SQL Server cryptography functions.
Corporate Culture
One of the things I enjoy about work is seeing the various cultures that evolve. Some companies are rigid, some...
The Stairway Series
Today we launch a new series of content aimed at providing basic knowledge to people new to a section of SQL Server. Steve Jones comments on the way this series came about.
The Stairway Series
SQLServerCentral launches a new series of content today, aimed at helping you bootstrap your knowledge in specific areas of SQL Server.
StreamInsight: A new way to think about analyzing data
Last night’s Oregon SQL user
group meeting was very enlightening. Mark Simms form the SQLCAT team came
down from Redmond to talk...
Using SQL Server Integration Services and StreamInsight Together
The purpose of this paper is to provide guidance
for enriching data integration scenarios by integrating StreamInsight with SQL
Server Integration Services. Specifically, we looked at the technical challenges
and solutions for such integration, by using a case study based on a customer
scenarios in the telecommunications sector.
What Sarbanes-Oxley Won't Do
Today we have a reprint of an editorial from Dec 4, 2005 as Steve is on vacation.
MDX Performance - burdens of IIF
I used to think naively that IIF is an innocent little function that can only do good and help me...
Working with SQL Server Profiler Trace Files
In a previous tip we looked at the steps to Create a Trace Template in Profiler. In this tip we will look at a few more tips such as creating a trace template from an existing trace file and saving a trace file to a SQL Server table.
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
Alamat kantor resmi BCA KCU BOGOR Telp: 0817.82.5533
WhatsApp: 0817825533, Jl. Ir. H. Juanda No.28, RT.03/RW.02, Paledang, Kecamatan Bogor Tengah, Kota Bogor,...
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
BCA KCP RADEN SALEH TLP/WA 083800119009
Jl. Raden Saleh No. 13, 15, 17A, Daerah Khusus Ibukota Jakarta 10430
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