Audit Webinar Tomorrow (4 September 2014)
I will be given a webinar on how to audit SQL Server through MSSQLTips.com.
Webinar Registration Link
The abstract:
Don’t become a statistic....
2014-09-03
512 reads
Off to Flowcon 2014
With all of the work on a deployment pipeline and Continuous Integration (CI) and Continuous Delivery (CD) I’ve worked on,...
2014-09-03
815 reads
Left or Right?
No, this is not about politics. It’s about your WHERE clause… and your JOIN criteria… and your HAVING clause. It’s about a...
2014-09-08 (first published: 2014-09-03)
6,781 reads
Analysis Services Dynamic Security
Imagine you have a requirement to capture the user accounts that log into your cube and based on their username...
2014-09-03
3,061 reads
Analysis Services Dynamic Security
Imagine you have a requirement to capture the user accounts that log into your cube and based on their username...
2014-09-03
794 reads
PASS Summit 2014 Announcements
In case you do not receive the PASS connector, here are some announcements for this year’s summit on Nov 3rd...
2014-09-03
821 reads
Restoring Toggle Results Window as Ctrl+R in SSMS
Recent versions of SQL Server Management Studio have unmapped Control+R as the toggle for the Results window in a typical...
2014-09-03
1,881 reads
4 Things I Wish I Knew Sooner
I was recently called out by Tim Costello on a blog series started by Mike Walsh. http://www.interworks.com/blogs/tcostello/2014/08/27/4-things-i-wish-i-knew-sooner-bi-consultant
The series calls for...
2014-09-02
1,338 reads
SQLSaturday Orlando Marketing Plan-Part 40
Last week we were at 332, this morning at about the same time we’re at 356. Not bad for a...
2014-09-02
555 reads
Upcoming Events
My summer event hiatus is coming to a close, and we’re now back into the conference and event season! I’ve...
2014-09-02
742 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