Grant for President
Grant Fritchey is running for the PASS board. He’s not running for President, though I’m not sure why he shouldn’t...
2014-09-22
782 reads
Communication and the Board: #PASSVotes
The whole idea behind PASS is to build a community of people who can assist each other in their daily...
2014-09-22
563 reads
Changing configuration settings with sp_configure
I was recently asked where to go in Configuration Manager to change the settings for xp_cmdshell. It was then that...
2014-09-24 (first published: 2014-09-22)
8,059 reads
Resolving SSDT-BI Installation with IsVisualStudio2012ProInstalled() error
Recently I was building a new virtual machine for presentations, and loaded up my usual battery – Windows 7, SQL Server...
2014-09-24 (first published: 2014-09-22)
6,481 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...
2014-09-22
11,669 reads
SQLSaturday Orlando Marketing Plan-Part 45
It’s Saturday a week out and I’m trying to finish up messages for the week. A lot to send this...
2014-09-20
725 reads
Parameterization Part 5: Two Common Mistakes
This is the fifth post in my Parameterization series. In previous posts I wrote about parameter sniffing and when it is...
2014-09-23 (first published: 2014-09-20)
9,023 reads
The Student To IT Pro Seminar We’re Doing at SQLSaturday Orlando
Ever since SQLSaturday #1 our venue has been Seminole State College (Seminole Community College back then), provided graciously and perhaps...
2014-09-19
770 reads
Back from DevConnections
I spent a few days at DevConnections this week and really enjoyed the conference. The location was Aria in Las...
2014-09-19
778 reads
Reblog: September 12 to September 18
Photo credit – Jenn and Tony Bot
Sometimes old stuff is just as cool as new stuff. Over the past few years,...
2014-09-19
752 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