Quickly Change SQL Job Owners
It is not unusual to find a server where some random user created a bunch of jobs to be run...
2018-07-26 (first published: 2018-07-16)
2,497 reads
Understanding Data Sharing in SQL Server Docker Containers
This article talks about shared volumes and the preferred mechanism for data persistence using the Docker containers. This article covers...
2018-07-16
569 reads
Solving Ken’s FizzBuzz 3D–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-08-03 (first published: 2018-07-16)
1,915 reads
Databases and DevOps, Tools are the Easy Part
Moving your database development, deployment and management into a DevOps methodology does involve choosing and implementing tools and tooling. Tools...
2018-07-25 (first published: 2018-07-16)
2,074 reads
SQL Saturday Louisville–Bout That Time
SQL Saturday Louisville is less than a week away!! A lot of hard work has gone into putting on this...
2018-07-16
179 reads
Counting NULLs
Recently I was doing one of Kendra Little’s (b/t) SQL Server quizzes. Specifically the Quiz: COUNT() in SQL Server. As...
2018-07-16
1,106 reads
Downtime
I was speaking at a conference recently and when I bumped into a friend, the first thing she said to...
2018-07-16
252 reads
Another MVP Award – 2018-2019
Gladly sharing that I got the news of my MVP award on 1st July. I am happy, honored, and humbled...
2018-07-16
247 reads
Book Review – Factfulness by Hans Rosling
I recently bought the book Factfulness – Ten Reasons we’re wrong about the world – And why things are better than you...
2018-07-23 (first published: 2018-07-15)
2,672 reads
SQL Server data flow into Excel template with Power Query function-based parameter
(2018-July-15) Your case is to create an Excel template with data extracted from a backend SQL Server database; it takes a...
2018-07-24 (first published: 2018-07-15)
2,519 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