Monday Coffee 2017-05-08
Asking stupid questions
Oh boy have I asked some stupid questions in my time. Most recent was this question that I...
2017-05-08
335 reads
Using The SQL Server Merge Statement
Note : Since publishing this I’ve been notified that there are a number of outstanding issues with the SQL Server merge...
2017-05-08
61 reads
SQL Azure Databases - Active Secondary - How to configure? - Part 1
Dear all,I have taken the azure dive at last 🙂
In case if you are new to azure, azure is the Microsoft cloud platform service, offering lots of services for...
2017-05-07
8 reads
SQL Azure Databases - Active Secondary - How to configure? - Part 1
Dear all,I have taken the azure dive at last 🙂
In case if you are new to azure, azure is the Microsoft cloud platform service, offering lots of services for...
2017-05-07
70 reads
SQL Server Dynamic Pivot
Often when trying to pivot data you wont know what the possible values that you need to pivot on, in...
2017-05-07
68 reads
SQL Azure Databases - Active Secondary - How to configure? - Part 1
Dear all,
I have taken the azure dive at last 🙂
In case if you are new to azure, azure is the Microsoft...
2017-05-22 (first published: 2017-05-07)
1,265 reads
Removing an App Service Plan in Azure
In my previous postI adhered to my O-OCD (Operational OCD) and standardised my App Service Plan name to fit in...
2017-05-18 (first published: 2017-05-07)
1,589 reads
Configure Distribution Database
In this blog, we are going to learn about the Distribution database, how to configure the Distribution database, and how...
2017-05-18 (first published: 2017-05-06)
12,263 reads
Using JSON In SQL Server 2016
The new JSON bits in SQL Server 2016 give you the ability to pull stuff out of JSON and to...
2017-05-06
97 reads
GroupBy conference recording of Introducing the SQL Server 2016 Query Store available now!
Good news!
The recording of my session “Introducing the SQL Server 2016 Query Store” at the GroupBy conference 2 weeks ago...
2017-05-19 (first published: 2017-05-05)
1,414 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