Using a Symmetric Key
In my Encryption Primer talk, I do demo on symmetric key use, and wanted to document it here. Encryption is...
2012-06-27
3,025 reads
Microsoft Data Quality Services in SQL Server 2012
SQL Server Data Quality Services (DQS) is a knowledge-driven data quality product that is new to SQL Server 2012. The...
2012-06-27
5,211 reads
Last Week to Enter the Exceptional DBA Contest
Just a reminder: you have until this Friday to enter the 2012 Exceptional DBA awards. I’m judging, and looking forward...
2012-06-27
1,624 reads
How to Create Reporting Services 2012 Report Templates
When I started writing this blog I realized it has been several months since my last post. I guess that...
2012-06-27
9,461 reads
How to Create Reporting Services 2012 Report Templates
When I started writing this blog I realized it has been several months since my last post. I guess that...
2012-06-27
1,749 reads
The New Phone Book Is Here!
I can’t help it. I get really terribly excited when I publish a book. Maybe it should be old hat....
2012-06-27
1,614 reads
The report execution has expired or cannot be found. [rsExecutionNotFound]
I ran across the following error in SQL Reporting Services 2008 R2 a few weeks ago:
The report execution has expired or...
2012-06-27
12,468 reads
Guest Post – DBAvolution
One of my favourite things about the SQL community is the exquisite diversity of talent of it’s members. Today for the “What’s it...
2012-06-27
2,017 reads
How Local Variable or Optimize for Unknown Resolve Parameter Sniffing
In my last post , we have gone through the parameter sniffing and possible solutions for parameter sniffing. In the possible...
2012-06-27
3,448 reads
Down and Dark
I came back from vacation to find the home DSL line bouncing up and down a bit. I wasn’t overly...
2012-06-26
1,571 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