SQL Server 2016 – whats new…lets see
Hey friends. I am here again with what’s new blog … Things are changing quite frequently and requirement is also changing....
2016-01-11
436 reads
Blog Posts
Viewpoints from CES 2016
While I never really enjoy a cross country flight back home my feet are very happy that I am finally...
2016-01-11
332 reads
What is SSDT all about aka Why should I bother?
I often get asked the questions “What is SSDT" and I have wanted to have a single reference as to...
2016-01-11 (first published: 2016-01-05)
4,371 reads
Sudoku by SQL Part 2 of 3
The Challenge
Since I came across the first sudoku I was wondering if it could by solved by SQL using queries...
2016-01-10
355 reads
Creating a Matrix in Power BI With Multiple Values on Rows
This week I was asked to create a matrix in a Power BI report that looks like this:
Matrix with Values on...
2016-01-09
1,310 reads
Sudoku by SQL Part 1 of 3
The Challenge
Since I came across the first sudoku I was wondering if it could by solved by SQL using queries...
2016-01-09
430 reads
Sudoku by SQL Part 3 of 3
The Challenge
Since I came across the first sudoku I was wondering if it could by solved by SQL using queries...
2016-01-09
362 reads
Advent of Code Day 1, Puzzle B
As I continue through the Advent of Code, albeit slowly, I’m solving each puzzle 3 days. I worked through 6...
2016-01-08
750 reads
Alter Event Session
Altering an Extended Event session is not necessarily a difficult task, but it is a very useful ability. Having this basic skill in your wheelhouse can be very positive...
2016-01-08
17 reads
TempDB memory leak?
I found a bug where I’m seeing TempDB use more memory than it should on multiple versions of SQL Server,...
2016-01-08 (first published: 2016-01-05)
3,363 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...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
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