X-XMLA: v. Creating XMLA Script from Visual Studio and Deploy the Database
This will be the easiest entry in this series. This is a reblog of an article I wrote last year....
2012-06-26
1,186 reads
Want to lose #20PoundsBeforeTheSummit? Join the #GetHawt competition!
We here in the IT community are clearly concerned about our weight. More specifically, we’re concerned about our weight going...
2012-06-26
973 reads
Problems with my new book
First off, I apologize. As if writing a book wasn’t hard enough, now we get new problems because of on-demand...
2012-06-26
841 reads
Locking Behavior – Foreign Keys
With Snapshot (read committed snapshot and snapshot isolation level) enabled, when data reading on a table takes place, if any...
2012-06-26
2,792 reads
A Fire Drill and Voter Registration
I avoid politics here, a discussion best done in other places, but hope you’ll enjoy some thoughts about a recent...
2012-06-26
801 reads
SQL Rally 2012 Nordic
The Nordic SQL Server event of the year is getting closer and closer. YES it is SQL Rally Nordic that...
2012-06-26
898 reads
SQLBif Gets A Job - SQLCommunity Redeemed...
Back in May, I had a conversation with a sql friend in the community, and well, my friend (who I...
2012-06-26
1,460 reads
Preach The Gospel Always, If Necessary Use Words
I’ll be honest, I contemplated a lot about whether to write this blog or not for fear that it may...
2012-06-26
288 reads
I’m speaking at the PASS Summit 2012
The PASS Summit 2012 schedule has been released, and I’m proud to announce that I’ve been selected to present a...
2012-06-25
691 reads
SQLRally 2012 Eval Scores
I was just browsing the results of the presentations at SQLRally 2012. I ended up with a evaluation average of...
2012-06-25
648 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