Roll on 2018!
Hey everyone, hope you all had a great Christmas and New Year!
I took December off from blogging as had started...
2018-01-08
364 reads
SQL Server – TRIM() function in SQL Server 2017
Hello friends, Please check the below link of my new article on TRIM() function in SQL Server 2017 – https://social.technet.microsoft.com/wiki/contents/articles/51047.introduction-to-trim-function-in-sql-server-2017.aspx
2018-01-08
406 reads
WITH DATA_PURITY (from recent experience, the key to knowing if patching to 14.0.3015.40 was okay)
So there I am, all keen on keeping ahead of the latest security issue, as usual, whilst handling my patching...
2018-01-07
501 reads
Template Variables (Day 7)
Do you have scripts that you need to run frequently, but every time you need to set some different parameters?...
2018-01-18 (first published: 2018-01-07)
1,566 reads
Why I am leaving a role/company I loved
This non-technical post is about why I am leaving a technical company after working there for 17 + years.
If you are...
2018-01-07
530 reads
Vertical Scroll Bar Map Mode (Day 6)
Have you ever had a long script that you are trying to scroll through? Do you wish that you could...
2018-01-06
581 reads
Common Tempdb Trace Flags – Back to Basics
In this article I introduce you to some basics in regards to default behaviors and settings in tempdb along with some best practices. It is advisable to investigate from...
2018-01-06
27 reads
Common Tempdb Trace Flags – Back to Basics
Once in a while I come across something that sounds fun or interesting and decide to dive a little deeper...
2018-01-06
564 reads
Columnstore Indexes – part 118 (“SQL Server 2017 Editions Limitations”)
Continuation from the previous 117 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
As a logical continuation from the blog...
2018-01-05
870 reads
Working with Query Files (Day 5)
So you’re working with a query that you have loaded from a saved file. And now you want to open...
2018-01-05
377 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Hyperscale Replicas III
Comments posted to this topic are about the item Hyperscale Replicas III
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers