What I Do When I'm NOT Writing SQL
This post is a response to this month's T-SQL Tuesday prompt created by Aaron Bertrand. Adam Machanic created T-SQL Tuesday as a way for SQL users to share ideas...
2018-02-13
20 reads
T-SQL Tuesday #99 – Door #2
This months T-SQL Tuesday is hosted by Aaron Bertrand and the topic is Dealer’s Choice. Aaron gives us the choice...
2018-02-13
332 reads
T-SQL Tuesday #99 – Door #1
This months T-SQL Tuesday is hosted by Aaron Bertrand and the topic is Dealer’s Choice. Aaron gives us the choice...
2018-02-13
511 reads
T-SQL Tuesday #99 - Dealer's Choice / sqlibrium
This month’s T-SQL Tuesday from Aaron Bertrand gives us a choice:
Life beyond the technical in a search for what Drew with the Burdensome Name calls #sqlibrium Your own T-SQL...
2018-02-13
17 reads
Migrating MySQL Databases
A little out of my area, but I need to move the tsqltuesday.com database to a new service. The company...
2018-02-12
878 reads
Kronothon2.0 – Accept the challenge
Kronothon2.0 – The only difference between Success and Failure is one’s attitude.
Register here to win cash prizes up to 5 Lakhs...
2018-02-12
474 reads
Automating Database Deployment: Part 1 Introduction to RoundhousE
Database Deployment in DevOps One of the many obstacles to database development and DevOps is how to deploy databases consistently and how to automate the process. Database deployments have...
2018-02-12
72 reads
How I Used Pragmatic Works Training to Pass the Power BI 70-778 Certification
Recently I took and passed the Microsoft certification exam 70-778 for Power BI called Analyzing and Visualizing Data with Microsoft...
2018-02-23 (first published: 2018-02-12)
2,369 reads
SQL# Version 4.1 is released!!
Version 4.1 of SQL# has just been released!
New functionality available only in Full version
Sys_LockResourceReturns the name of the specified Lock...
2018-02-12
1,356 reads
The SQLUndercover Inspector is now available!
The SQLUndercover Inspector is now available on GitHub, a quick run down of what it does can be found here:...
2018-02-11
1,044 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