A SQLServerCentral DR Event
We had a disaster at SQLServerCentral this past weekend. It wasn’t a big disaster, but it was an event that...
2014-09-23
730 reads
Vote for Grant Fritchey
Just a brief note to say that I will be voting for Grant Fritchey for the PASS Board and I...
2014-09-23
1,139 reads
PASS Chapter Leaders - Remember To Talk About Elections With Your Chapters!
Last week before our monthly MagicPASS meeting I went through my usual routine of grabbing the PASS chapter deck and...
2014-09-23
539 reads
Why I’m Only Casting One Vote This Year in the PASS Election
First, a reminder/disclaimer that I am serving on the PASS NomCom this year. The four candidates in the election are...
2014-09-26 (first published: 2014-09-23)
6,532 reads
The Magic Alt Button
Lately I have been using more and more the awesomeness of the Alt-button in SQL Server Management Studio (SSMS). What...
2014-09-23
856 reads
SQL Server Query Performance Tuning
The latest update to my book, SQL Server Query Performance Tuning was released last week. This is the fourth edition...
2014-09-23
791 reads
SSIS ReportGenerator Task
Did you ever faced a situation when needing to generate dynamically a SQL Server Reporting Services Report on-demand, at some...
2014-09-22
416 reads
Launching PASSWatch
I’ve wanted to do this for a while, decided to make the time commitment and see what happens. See the...
2014-09-22
553 reads
The Mentoring Experiment – Closing Thoughts
Andy wrote a post today called The End of the Mentoring Experiment, which is something we’ve talked about for some...
2014-09-22
731 reads
SQL Server Cluster LooksAlive and IsAlive Check
Windows Cluster Service use the “heartbeat” process to check whether each node is alive at both the OS level and SQL Server level. Heartbeat signals works on UDP. Microsoft...
2014-09-22
25 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