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,584 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
478 reads
2009-03-06 (first published: 2008-04-07)
31,487 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
438 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
425 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,583 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,210 reads
Blogs
Sic Transit Gloria Community
When Covid took out the PASS organization, I had someone say to me, “Well,...
DATEADD Truncates the Number Parameter: #SQLNewBlogger
By Steve Jones
This was an interesting thing I saw in a Question of the Day submission....
Our SQL Server is Slow! What Do I Do First?
By Kevin3NF
Don’t Panic! It’s a vague but common complaint, frequently with no additional details. Before...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
ExecutionLog3 table in Reportserver Database
I have a SSRS report for which users are complaining to be slow, but...
SQL Server Maintenance Plan Feedback
Hi I set this up today. I wanted to get some feedback. I have...
Question of the Day
Counting Bits IV
What do these two selects return?
SELECT BIT_COUNT (CAST (-1 as smallint))
, BIT_COUNT (CAST (-1 as bigint))
See possible answers