Azure Data Architecture Guide (ADAG)
The Azure Data Architecture Guide has just been released! Check it out: http://aka.ms/ADAG
Think of it as a menu or syllabus for...
2018-02-15
142 reads
Azure Data Architecture Guide (ADAG)
The Azure Data Architecture Guide has just been released! Check it out: http://aka.ms/ADAG
Think of it as a menu or syllabus for...
2018-02-15
1,069 reads
Saving Costs in Azure
Nobody wants to waste money and being in the cloud is no exception! Luckily for us Azure is very efficient...
2018-02-27 (first published: 2018-02-15)
1,801 reads
Synonyms, how and why.
Did you know SQL Server has a thing called a synonym? It’s not something you see used very often even...
2018-02-26 (first published: 2018-02-15)
3,365 reads
Execute Multiple Files Using SQLCMD/SQLClient – Which Is Faster?
Hello!
I’ve been working on a PowerShell module that will migrate the schema of an Azure Data Warehouse from one database...
2018-02-26 (first published: 2018-02-15)
2,382 reads
Migrating or Recovering a TDE protected Database
When encrypting a database with Transparent Data Encryption(TDE), a vital consideration is to make sure we are prepared for the...
2018-02-14
573 reads
Join me for Masking, Privacy, Protection, and Clones at SQL in the City Feb 28
Registration is open for SQL in the City 2018. Our first event is Feb 28 and I’ll be heading back...
2018-02-14
367 reads
Why nested views are bad
Nested views are bad. Let’s get that out of the way. What is a nested view anyway? Imagine that you...
2018-02-14
2,394 reads
Performance Basics: Key lookup operator and query optimization
One of the most basic things to improve performance in our queries is using indexes, but this doesn't mean that...
2018-02-14
577 reads
Bloggers Should Have Reach
One of my goals for 2018 is to expand the reach of my blog.
As a blogger starting out I had...
2018-02-14
332 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