Quick Tip: Accurate Log Shipping Status
Here’s a quick reminder for those of you using log shipping, and checking the SSMS report “Transaction Log Shipping Status”...
2012-08-16
898 reads
2012-08-16
816 reads
Free Tools for Testing SQL Sever
You Need To Test Your SQL Server!
Its like screaming “TEST THE BREAKS ON YOUR CAR!” If you don’t have the...
2012-08-16
2,262 reads
Coming to Your Town
I can’t sing and I can’t play and I left the young generation behind a while ago, but I’m still...
2012-08-16
1,176 reads
Replication and TFS
So, we’ve had this issue lately at work with our TFS build/deploys causing a significant amount of contention and only...
2012-08-16
2,349 reads
SQL Saturday 151 BI Pre-con: Stacia Misner
Hello Dear Reader, SQL Saturday 151 Orlando is picking up steam. The Pre-Con’s have been named and they are fantastic. ...
2012-08-16
747 reads
Speaking at 24 Hours of Pass
24 Hours of PASS (24HOP) has been around a few years now, but this will be my first time participating...
2012-08-16
575 reads
Meme15: Top 5 Reasons I Like My Job
This month’s Meme15 topic is ‘Top 5 Reasons I Like My Job’. A little over a year ago, I started...
2012-08-16
1,341 reads
Unwanted dependency between different parts of the code
Small systems tend to grow with new functionality and new access points. When the system grows, the need for data...
2012-08-16
1,149 reads
Dealing with negative session ids
Hello? Mr. DBA? Have you got a moment?
So there you are, enjoying one of the few quiet moments of your...
2012-08-15
5,338 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