Decryption and CASTing
In my last encryption post I showed how to encrypt and decrypt data with a symmetric key. However there was...
2012-07-11 (first published: 2012-07-03)
3,428 reads
SSIS SCD vs MERGE Statement – Performance Comparison
I wouldn’t class myself as an expert in SSIS but I certainly know my way around but came across something...
2012-07-03
8,714 reads
SQL Server 2008 Diagnostic Information Queries (July 2012)
Here is the latest version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements to...
2012-07-03
1,369 reads
Speaker Selection for SQLSaturday Orlando-Group #4
Ten speakers selected, and as we go into the July 4th holiday we’re going to add two more to that...
2012-07-03
323 reads
SQL Server Auditing – Getting started
In my organization, one of my jobs is auditing our database environment. I’ve been tasked with this responsibility for several...
2012-07-03
1,872 reads
July 2012 – Monthly SQL Server Checklist
The year is half over and for many of us, specifically those in the United States, it’s a tricky week...
2012-07-03
897 reads
Lunch is for Wimps
A real life DBA tale from the trenches with some awesome advice. That’s what one reader chose to share with...
2012-07-03
1,281 reads
SQL Server Get Identity after Insert using SP
I thought I will share my experience how you can get identity value after insert using SQL Server. I have...
2012-07-03
637 reads
RSS pubDate format in SQL Server
Today I had to write T-SQL code to convert date into very specific date format (Mon, 02 Jul 2012 19:24:05...
2012-07-02
403 reads
Colorado Wildfires
More than a few people have asked how I’m doing with all the fires in Colorado, so I wanted to...
2012-07-02
991 reads
Blogs
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
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
The first version of my accounting assistant could not find a single purchase of...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
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-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers