Rotating encryption keys for Always Encrypted
In my last post, I talked about the process of rotating your encryption keys. It’s just one of those routine maintenance tasks that need to be done from time...
2018-05-01
20 reads
Rotating encryption keys for Always Encrypted
In my last post, I talked about the process of rotating your encryption keys. It’s just one of those routine maintenance tasks that need to be done from time...
2018-05-01
24 reads
Rotating encryption keys for Always Encrypted
In my last post, I talked about the process of rotating your encryption keys. It’s just one of those routine maintenance tasks that need to be done from time...
2018-05-01
24 reads
Rotating encryption keys for Always Encrypted
In my last post, I talked about the process of rotating your encryption keys. It’s just one of those routine maintenance tasks that need to be done from time...
2018-05-01
53 reads
Rotating encryption keys for Always Encrypted
In my last post, I talked about the process of rotating your encryption keys. It’s just one of those routine...
2018-05-09 (first published: 2018-05-01)
3,046 reads
Day 1: MySQL History
Swedish Company: MySQL AB by – Michael Widenius (Monty), David Axmark and Allan Larsson Name Combination: Michael’s Daughter name –“My” and...
2018-05-01
231 reads
Ready for Houston Tech Fest 2018
Houston Tech Fest is this weekend!In 2016, there was a wedding. In 2017, rescheduled at the last minute because of Harvey, I couldn't reschedule. But prior to 2016, I...
2018-05-01
12 reads
Is It Possible To Conditionally Index JSON Data?
Check out this week’s episode on YouTube.
Recently I received a great question from an attendee to one of my sessions...
2018-05-07 (first published: 2018-05-01)
1,988 reads
Is It Possible To Conditionally Index JSON Data?
Watch this week's video on YouTube
Recently I received a great question from an attendee to one of my sessions on JSON (what's up Nam!):
At first glance it sounds like...
2018-05-01
18 reads
Is It Possible To Conditionally Index JSON Data?
Watch this week's video on YouTube
Recently I received a great question from an attendee to one of my sessions on JSON (what's up Nam!):
At first glance it sounds like...
2018-05-01
16 reads
Blogs
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers