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
19,299 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
476 reads
2009-03-06 (first published: 2008-04-07)
30,538 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
435 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
422 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,454 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
11,812 reads
Blogs
Executing One Line in VSCode–#SQLNewBlogger
By Steve Jones
I wrote about arrays in PowerShell last week, but I realized one of the...
Friday Flyway Tips–Comparison Options
By Steve Jones
Recently a customer asked how they could get index changes to be captured in...
A New Word: Guiltwrights
By Steve Jones
giltwrights – n. the imaginary committee of elders that keeps a running log of...
Forums
Lake Database Performance Optimization
I recently created a synapse link for Dataverse. The resultant Lake Database in Synapse...
Selecting from a view, base table has a DENY on a column
This is something I've never seen before and I can't think of the right...
JSON data with Pivoted
Hi All, I need some assistance and not sure how to achieve the expected...
Ask SSC