Azure Every Day, Azure Data Week, and More Azure
As you likely know, I am a Principal Consultant at Pragmatic Works. This year we have been doing some great...
2018-08-25
401 reads
Bringing DevOps to #SQLSat Oslo
As my kids get older and I spend less time with them, I look forward to visiting new countries. While...
2018-08-24
475 reads
Leveraging on SQL Server metadata
I’m working on a project where I need to convert Firebird SQL code into T-SQL code.
No schema, just the modules....
2018-08-24
325 reads
Experimenting SysTools SQL Database Repair Tool by SQL MVP Shashank
Author Bio: Shashank is a TechNet Wiki Ninja who loves to work on SQL Server. He lives in Mumbai and...
2018-08-24
361 reads
Guatemala SQL Server local group
Good news for all the Guatemalan data professionals, starting from August 2018 you have an official PASS SQL Server local...
2018-08-23
305 reads
Remember the Default Window
I ran across a question recently from a user about why they had strange results from a windowing query. This...
2018-09-10 (first published: 2018-08-23)
2,689 reads
My Azure SQL Database Elastic Job is Broken!
I use elastic pools. They are a fabulous way of saving money when running many Azure SQL Databases, that is...
2018-08-23
346 reads
Power BI Custom Visuals Class (Module 116 – Scatter Chart by Akvelon)
In this module you will learn how to use the Scatter Chart by Akvelon. The Scatter Chart by Akvelon has...
2018-09-11 (first published: 2018-08-23)
2,635 reads
PSPowerHour v1.0 Wrap-Up
The first edition of the PSPowerHour is in the books and it looks like it was a big success. This one was dbatools-heavy but I chalk that up to...
2018-08-23
19 reads
Azure SQL Database high availability
In this blog I want to talk about how Azure SQL Database achieves high availability. One of the major benefits from moving from on-prem SQL Server to Azure SQL...
2018-08-22
180 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