24 Hours of PASS, Fall 2012
It’s time to get your learn on again. The schedule for the Fall 24 Hours of PASS is up and...
2012-08-22
708 reads
I Think I Need A Writing Table
I’m writing this Friday evening in Cleveland at the hotel, relaxing after the speaker dinner and getting ready for SQLSaturday...
2012-08-22
709 reads
I’m Speaking at SQLSaturday #156–Providence
I’m excited to be back on the speaking circuit. I was able to attend SQLSaturday #122 – Louisville thanks to Idera...
2012-08-22
745 reads
SQL Server:Understanding the Data Record Structure
In our last post, we have gone through the data page structure and we have noticed that there is an...
2012-08-22
7,353 reads
Disabling DDL Triggers
Suppose you want to stop using a DDL trigger for a short period of time, such as the login trigger...
2012-08-21
6,381 reads
Got A Pal in Kalamazoo (#SQLSat160)
It’s been a year already and it’s time to head back to Kalamazoo for their SQL Saturday. We’re heading back...
2012-08-21
927 reads
Webcast: The Art and Science of Handling Recruiters
Post-webcast update: The webcast went well! We talked, we QnA’ed, we gave out a free Roadmap, and all attendees got...
2012-08-21
830 reads
Delaying AV Definitions?
Auto-deploying AV definitions has become common place throughout the industry. However, this post from the SANS Internet Storm Center raises the...
2012-08-21
1,281 reads
Resources for Those Dealing with Security Patches
It's been a while since I was in the day-to-day business of security patches. However, I still keep up with...
2012-08-24 (first published: 2012-08-21)
2,582 reads
I have been appointed as PASS Regional Mentor for the Greater Southeast
I have been appointed as PASS Regional Mentor for the Greater Southeast by PASS (http://www.sqlpass.org). I am truly honored to...
2012-08-21
920 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