Quick 2005/2008 Script to Export Permissions
I had a need to export permissions to be run against the database once an older version was restored (but which didn't...
2009-08-28
13,588 reads
Broken - Windows 7
I've been running the Windows 7 RC for a few months, and overall I like it. Many things work well,...
2009-08-28
978 reads
SQLSaturday #21 – Orlando Update
Event Record
This is the third year that Orlando has hosted a SQLSaturday. In 2007, I was an attendee; 2008, I...
2009-08-28
349 reads
SQLLunch.com – Looking for a Website Template
As most of you know I am hosting a bi-weekly Live Meeting event called SQLLunch. I recently purchased www.sqllunch.com and...
2009-08-28
742 reads
SQL Reporting Services 2008 Upgrade – The Call To Microsoft
I recently submitted an article to SQLServerCentral about my adventures in upgrading my existing SSRS 2005 instance to 2008. In...
2009-08-28
608 reads
Baking Cheesecake
Last Friday I discussed baking multiple batches of blueberry muffins so I thought I’d follow up with another baking post....
2009-08-27
599 reads
Upcoming Microsoft Gadgets
Microsoft has finally officially announced the long rumored price cuts for the XBox 360 Elite, which will go down from...
2009-08-27
654 reads
Shameless Self Promotion
NewsGator’s marketing department put up a nice post yesterday mentioning myself and Dan Larson, who are both Microsoft MVPs. I...
2009-08-27
687 reads
Top 5 reasons to run for the PASS Board of Directors
There have been quite a few posts in the SQL Server community recently announcing the Call for Nominations for the...
2009-08-27
479 reads
Pass Board of Directors
As you’ve no doubt heard or read, the call for nominations for the PASS Board of Directors is open until...
2009-08-27
601 reads
Blogs
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
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...
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