Azure Data Factory and the Case of the Missing JRE That Wasn’t
On a recent project I used Azure Data Factory (ADF) to retrieve data from an on premises SQL Server 2014...
2017-05-11 (first published: 2017-05-01)
1,303 reads
DAX calculations with hierarchies: Set the order straight.
[2017-Apr-30] If you have ever tried to create calculated measures in SSAS Tabular/ Power BI models where different levels of...
2017-05-10 (first published: 2017-04-30)
4,791 reads
Data Channel Interview - 06 - Manohar Punna on SQL Azure Migrations
Here we go for the 6th interview on #DataChannel. Manohar Punna, MVP and Data Platform Geeks President discusses "Migrations to SQL Azure" on #DataChannel. Manohar, in this interview provides...
2017-04-30
9 reads
Data Channel Interview - 06 - Manohar Punna on SQL Azure Migrations
Here we go for the 6th interview on #DataChannel. Manohar Punna, MVP and Data Platform Geeks President discusses "Migrations to SQL Azure" on #DataChannel. Manohar, in this interview provides...
2017-04-30
12 reads
Data Channel Interview - 06 - Manohar Punna on SQL Azure Migrations
Here we go for the 6th interview on #DataChannel. Manohar Punna, MVP and Data Platform Geeks President discusses "Migrations to...
2017-04-30
561 reads
Creating an App Service in Azure that connects to an Azure SQL Database.
Using the methodology listed in my previous blog post on creating an Azure SQL Database we now have a Continuous Integration...
2017-04-30
632 reads
Removing an Azure SQL Database using PowerShell..
In this post we will remove some databases located in Azure.
This related to my last post where I am cleaning...
2017-04-30
1,654 reads
Creating an Azure SQL Database via PowerShell
This post is about using the brilliance of PowerShell to script the creation of databases in Azure.
Background:
Apart from the obvious question...
2017-05-11 (first published: 2017-04-30)
1,368 reads
Multiple usage of functions to ensure “value” is not null? – NO
In this post I’m describing a piece of code that is not well written. The author (unknown) had applied three functions for a variable to ensure it never accepts...
2017-04-29
7 reads
Multiple usage of functions to ensure “value” is not null? – NO
In this post I’m describing a piece of code that is not well written. The author (unknown) had applied three functions for a variable to ensure it never accepts...
2017-04-29
31 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers