Updating tsqlt
I was looking to write a new test with the tsqlt framework recently. I wanted to isolate a stored procedure’s...
2014-08-20
1,246 reads
ISPACs – Got To Love Em
Being a DBA and working with various teams, I have become accustomed to deploying SSIS packages. I’ll even go back...
2014-08-20
605 reads
The End of The Professional Association Of SQL Server? It Should Be More Than Just An Acronym
I read with a bit of despair this post by Denise McInerney this morning. Going forward, it’s just “PASS”. Somehow...
2014-08-20
810 reads
The Red Gate Way…
As companies go, Red Gate is a little different. That is readily apparent in our tools and the philosophy behind...
2014-08-20
761 reads
Two years!
Two years ago today I began my blog with a post about the DEFAULT keyword. I set out with the...
2014-08-20
954 reads
SQL in the City 2014
It’s official, we have a couple 2014 SQL in the City events scheduled, covering two countries this fall. Both events...
2014-08-19
1,338 reads
Joint oPASS/MagicPASS Meeting Scheduled for October 15, 2014- Featuring Mark Souza In Person!
Big news for us in Orlando! On October 15th Mark Souza, General Manager – Data Platform Group at Microsoft, is going...
2014-08-19
588 reads
Getting the Word Out
A discussion that I’ve frequently had with organizers of SQL Saturday events, our own people here at Red Gate, authors,...
2014-08-19
575 reads
Export a SSMS Query Result Set to CSV
Once you have a query that is returning the data you like in SSMS you have a few options to...
2014-08-19
846 reads
Export a SSMS Query Result Set to CSV
Once you have a query that is returning the data you like in SSMS you have a few options to...
2014-08-19
40,464 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