UDP vs TCP
If you’ve worked much with named instances you’ve probably had to deal with the question “What port is that instance...
2017-06-07
546 reads
Unable To Call Into C Compiler !?
Following on from my previous blog post I mentioned that I had to find a solution to the “unable to...
2017-06-07
436 reads
SQL Puzzle 1: Magic Squares
This is the first in what I hope will be a semi-regular series of recreational puzzles where SQL can be...
2017-06-07
1,649 reads
Identifying failed queries with extended events
Back to some core SQL this week and one of my favourite features, extended events.
Introduced in SQL Server 2008...
2017-06-07
6,184 reads
SQL Server 2016 Row Level Security In Action
Row Level security was introduced with SQL Server 2016 and allows us to specify predicates for what rows can be...
2017-06-07
48 reads
Best Practices: Defining Explicit Length for Varchar/Nvarchar
SA0080 : Do not use VARCHAR or NVARCHAR data types without specifying length. Level: Warning
When using varchar/nvarchar it should be explicitly...
2017-06-07
794 reads
Random Advance C# FAQs
Difference between const, readlonly and static readonly? const: const variable value is set as constant value at compile time. it can not...
2017-06-07
371 reads
5 Things You Need to Do When Performance Testing JSON in SQL and C#
Watch this week's video on YouTube
Want to learn more about using JSON in SQL Server? Watch me present at the online GroupBy conference on June 9, 2017 at 8am.
I've...
2017-06-06
33 reads
T-SQL Tuesday #091 – Databases and DevOps
Implementing DevOps with databases presents a unique set of challenges. However, just because something might be hard doesn’t mean that...
2017-06-06
427 reads
Power BI Custom Visuals Class (Module 54 – Route Map)
In this module you will learn how to use the Route Map Power BI Custom Visual. The Route Map uses...
2017-06-06
765 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