Transparent Data Encryption (TDE) SQL Server 2008
Transparent data encryption, otherwise known as TDE is one of the new features introduced in SQL Server 2008.
2009-05-04
20,960 reads
Roy Ernest
What a fortnight I had
This has been one of the most stressful fortnight in this company. I did not feel this stressed when our...
2009-03-25
483 reads
2009-03-06 (first published: 2008-04-07)
31,904 reads
How Humans Behave
It is strange how people react in different circumstances. Yesterday while going through the forums, there was an interesting post....
2009-01-15
444 reads
What a day to start Blogging
I have been thinking of writting a blog for the past 6 months but never had time or could I...
2009-01-13
433 reads
Why Object Qualification is important.
You have all read about why object qualification is important. You also must have heard of why stored Proc should not have sp_ as prefix to the name. Now let us proove if this is all true.
2008-03-10
9,648 reads
Importance of UPSERT
A simple UPSERT can reduce reads on tables. This in turn will increase the performance of a DB.
2008-01-29
12,349 reads
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
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
How do I explain that SQL Server should not be used as a code repository?
This week my BI Developer colleague proudly showed me a new Power BI report...
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