DBA best practices..from the DBA from Heaven
I met Tom Roush for the first time around 9 years ago – at a PASS Summit. If I recall right...
2018-02-01
703 reads
Why I cannot download .pbix files from powerbi.com
If like me you thought “Hey, it’s a new feature, I can finally create reports in powerbi.com service and then...
2018-02-01
976 reads
Considerations for dealing with big databases
Stress everywhere, user wants everything "Para ayer"Photo by Bernard Goldbach
If you are like me, and have SQL Server instances with...
2018-02-01
621 reads
DAX IF & Switch Statement Performance – Does Order Matter?
Intro
I’ve written a couple of article about IF & SWITCH in DAX over the past few years. Recently I noticed that...
2018-01-31
157 reads
SSMS Activity Monitor (Day 31)
SSMS provides an Activity Monitor, a process that displays various information about what all is going on with the instance....
2018-01-31
807 reads
Surround Code with Comments in SQL Prompt
I work for Redgate and write about products. I’ve got a series of SQL Prompt posts here on little things...
2018-01-31
1,587 reads
Speaking at SQLSaturday 725 in Victoria
Victoria is on an island off the coast of Vancouver, British Columbia. The island is wisely called Vancouver Island. It...
2018-01-31
531 reads
I’m a Speaking Mentor!
I am so excited to announce that I have been accepted as a speaking mentor on SpeakingMentors.com!
I struggled for so...
2018-01-31
499 reads
The difference between blogging about something you know, and something you are learning (Love blogging! Live!)
Close but you need to blog about learning while blogging about the difference of blogging when you are learning something...
2018-01-31
520 reads
Can You Hear It Now?
Here is a quick blog to show you something I discovered that I didn’t know existed.
I was on a Skype...
2018-01-31
395 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