Paul Hebhardt

I have been working with SQL Server for 15 years and have done everything from reporting to database design to ETL to architecture to administration. The way I see it, the cloud is the future, and SQL Azure is a great platform. Here are my musing on the subject.

Transparent Data Encryption in Azure SQL Database

by Paul Hebhardt

Pie in the Sky

Transparent Data Encryption in Azure SQL DatabaseJULY 26, 2015
Introduction
Transparent Data Encryption (TDE) is a security feature of SQL Server that...

2015-07-26

1,653 reads

Transparent Data Encryption in Azure SQL Database

by Paul Hebhardt

Pie in the Sky

Transparent Data Encryption in Azure SQL Database
JULY 26, 2015

IntroductionTransparent Data Encryption (TDE) is a security feature of SQL Server that has been around since SQL Server 2008. With TDE,...

2015-07-26

43 reads

SQL Azure has T-SQL Jobs - Well Almost

by Paul Hebhardt

Pie in the Sky

SQL Azure has T-SQL Jobs - Well AlmostJUNE 25, 2015
Introduction
One thing that has been lacking in Azure SQL Database is the...

2015-07-01 (first published: 2015-06-25)

2,861 reads

SQL Azure has T-SQL Jobs - Well Almost

by Paul Hebhardt

Pie in the Sky

SQL Azure has T-SQL Jobs - Well Almost
JUNE 25, 2015

IntroductionOne thing that has been lacking in Azure SQL Database is the ability to write database jobs in Transact-SQL. Recently,...

2015-06-25

25 reads

Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the Shards

by Paul Hebhardt

Pie in the Sky

Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the ShardsMAY 28, 2015
For those of you who have...

2015-06-05 (first published: 2015-05-28)

4,149 reads

Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the Shards

by Paul Hebhardt

Pie in the Sky

Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the Shards
MAY 28, 2015

For those of you who have been following along with this series of posts,...

2015-05-28

118 reads

Azure SQL Database Elastic Scale Part 2 - The Shard Map Manager Database

by Paul Hebhardt

Pie in the Sky

Azure SQL Database Elastic Scale Part 2 - The Shard Map Manager DatabaseMAY 1, 2015

In my last post, I discussed some...

2015-04-30

4,983 reads

Azure SQL Database Elastic Scale Part 2 - The Shard Map Manager Database

by Paul Hebhardt

Pie in the Sky

Azure SQL Database Elastic Scale Part 2 - The Shard Map Manager Database
MAY 1, 2015

In my last post, I discussed some of the concepts around Sharding and how we...

2015-04-30

139 reads

Azure SQL Database Elastic Scale Part 1 - What is Sharding?

by Paul Hebhardt

Pie in the Sky

Azure SQL Database Elastic Scale Part 1 - What is Sharding?MARCH 19, 2015

This week, Microsoft introduced an update to Azure SQL...

2015-03-26 (first published: 2015-03-19)

15,710 reads

Azure SQL Database Elastic Scale Part 1 - What is Sharding?

by Paul Hebhardt

Pie in the Sky

Azure SQL Database Elastic Scale Part 1 - What is Sharding?
MARCH 19, 2015

This week, Microsoft introduced an update to Azure SQL Database Elastic Scale Preview. This update is good...

2015-03-19

54 reads

Blogs

Are Blogs Still Relevant? - T-SQL Tuesday #204

T-SQL Tuesday is a monthly blog party hosted by a different community member each...

How I Built RAG for My Accounting App on Bedrock and pgvector

By Eduardo Pivaral

The first version of my accounting assistant could not find a single purchase of...

Why AI isn’t paying off yet, and what to invest in first

By Joyful-Craftsmen

Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...

Read the latest Blogs

Forums

Pay for Performance

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Pay for Performance, which is...

Layanan BCA KCU JOMBANG Hub/Wa. 0817-819-444

WhatsApp:0817819444 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415

Layanan BCA KCP Pemalang Hub/Wa. 0817-819-444

By layanan 24jam BCA

WhatsApp:0817819444 Jl. Jend. Sudirman No.6, Mulyoharjo, Kec. Pemalang, Kabupaten Pemalang, Jawa Tengah 52313

Visit the forum

Question of the Day

Too Many Choices

I have a table, dbo.MasterBrands, with this data:

BrandID OfficialName
1       Samsung
2       Apple
3       Microsoft
4       Adidas
5       Coca-Cola

I run this query. What is returned for Coca-Cola?

SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel')
FROM dbo.MasterBrands;

See possible answers