Object Explorer Filtering (Day 20)
If you have a database with hundreds (or thousands) of objects, finding the one that you are looking for in...
2018-01-20
146 reads
Object Explorer Filtering (Day 20)
If you have a database with hundreds (or thousands) of objects, finding the one that you are looking for in...
2018-01-20
425 reads
I've been chosen to speak at SQL Saturday Guatemala
I'm thrilled to announce that one of my proposals has been chosen to be presented in Guatemala's SQL Saturday that will be held on February 3rd at the Francisco...
2018-01-20
12 reads
Power BI Custom Visuals Class (Module 86 – Bubble Chart by Akvelon)
In this module you will learn how to use the Bubble Chart Custom Visual by Akvelon. The Bubble chart allows...
2018-01-19
974 reads
Use Snippets in SSMS to insert blocks of code (Day 19)
Snippets allow you to store and easily reuse TSQL code snippets. To use a snippet, just right-click in the query...
2018-01-19
224 reads
Use Snippets in SSMS to insert blocks of code (Day 19)
Snippets allow you to store and easily reuse TSQL code snippets. To use a snippet, just right-click in the query...
2018-01-19
382 reads
I've been chosen to speak at SQL Saturday Guatemala
I'm thrilled to announce that one of my proposals has been chosen to be presented in Guatemala's SQL Saturday that...
2018-01-19
145 reads
tSQLt Tests for Advent of Code 2017 Day 4
This is day 4 of the Advent of Code 2017. If you want to read about the puzzles, start with...
2018-01-19
436 reads
Finding the Default Path with dbatools
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
2018-01-19
508 reads
Implementing SSL for Your Blog
With the announcement of the recent security issues, namely Meltdown and Spectre, we at Denny Cherry & Associates Consulting have been...
2018-01-19
533 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