Restore Database In SQL 2012
In the post below I mentioned a store procedure which can generate the database restore script based on the msdb...
2012-08-21
8,340 reads
PASS Summit Code of Conduct – my thoughts
The big furor today is over PASS‘s new written Code of Conduct. I’m going to crib unashamedly from Nic Cain’s blog post...
2012-08-21
1,180 reads
August #Meme15 Round-Up
The August round of #meme15 finished up last week with a good number of people participating. The aim of the...
2012-08-21
760 reads
JSSUG Speaker Idol 2012 Review
Last Wednesday at Jacksonville SQL Server User Group (JSSUG) we held our annual Speaker Idol event. Read more about what...
2012-08-21
1,167 reads
Internal error: Invalid enumeration value. Please call customer support! is not a valid value for this element.
If you have done a lot of work with SQL Server Analysis Services (SSAS) you may have seen this message:
We’ve...
2012-08-21
1,189 reads
My upcoming speaking schedule
The summer goes by and in a few weeks the conference season starts over again. The last weeks were a...
2012-08-21
353 reads
My upcoming speaking schedule
The summer goes by and in a few weeks the conference season starts over again. The
last weeks were a little...
2012-08-21
765 reads
Celebrity DBA–West Coast Time
At the end of July I was fortunate enough to visit the City of Angels, Los Angeles, or simply LA....
2012-08-21
944 reads
keyword DEFAULT
In 12 years of working with SQL it was only last year that I came across the keyword DEFAULT and...
2012-08-20
1,360 reads
Please VOTE for Me: PASS Summit 2012 Lightening Talks
http://www.flickr.com/photos/cyndydoty/2087680308/Hello Dear Reader the PASS Summit is approaching and with that the program committee sent out a request for Lightening...
2012-08-20
1,063 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