Using the SSMS Web Browser (Day 25)
One of the things that I do with my code is to include reference links to what I was doing...
2018-01-25
315 reads
Using the SSMS Web Browser (Day 25)
One of the things that I do with my code is to include reference links to what I was doing...
2018-01-25
390 reads
Advent of Code 2017 Day 5–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-01-25
946 reads
How to write a PowerShell function to use Confirm, Verbose and WhatIf
In my last blog post I showed how to run a script with the WhatIf parameter. This assumes that the...
2018-02-05 (first published: 2018-01-25)
1,614 reads
Session Materials – Biml DataMinds
All of the materials for my Biml session for DataMinds.be can be downloaded from Github:
the slidedeck (it’s only 12MB :))a...
2018-01-25
351 reads
Extended Event Packages
I continue blogging on extended events. Today, I will discuss about the top level containers (Package) that gives access to...
2018-01-25
524 reads
Tinker as You Learn
In recent weeks I’ve seen my brother from another mother, Andy Leonard (twitter | blog), write or post about his learning...
2018-02-09 (first published: 2018-01-24)
1,941 reads
Using Bookmarks to navigate code in SSMS (Day 24)
Bookmarks are used in SSMS to have SSMS remember selected line positions, and to quickly move between the bookmarks. All...
2018-01-24
1,500 reads
Using Bookmarks to navigate code in SSMS (Day 24)
Bookmarks are used in SSMS to have SSMS remember selected line positions, and to quickly move between the bookmarks. All...
2018-01-24
366 reads
tSQLt tests for Day 5 Advent of Code 2017
This is day 5 of the Advent of Code 2017. If you want to read about the puzzles, start with...
2018-01-24
818 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