More Collation Confusion. (tempdb)
I’ve talked about Collation Confusion before. We had the dev and test instances at one collation and the production instance...
2017-11-08
434 reads
Connecting to an Azure SQL Databases
Connecting to an Azure SQL Databases is pretty simple and straight forward,as long as you know what you need in...
2017-11-08
346 reads
What Are These Backup Settings All About?
I ran across a client the other day that had these Backup and Recovery options set like the picture below...
2017-11-08
874 reads
Why do you want to use SQL Service Broker
Why use SQL Service Broker It enables you to execute SQL Statements faster and do the real work later. SQL Server...
2017-11-08
385 reads
Columnstore Indexes – part 115 (“Bulk Load API and Pressure”)
Continuation from the previous 114 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is dedicated to the...
2017-11-08
401 reads
Contained Databases setup
Last weekI wrote about what is a contained database, the benefits and challenges, today as promised I'll show you how...
2017-11-08
260 reads
Tuning Throughput from Azure Event Hub to Azure Stream Analytics
[read this post on Mr. Fox SQL blog] Recently I had a requirement to load streaming JSON data to provide a data feed for near real-time reporting. The solution streamed...
2017-11-07
19 reads
Tuning Throughput from Azure Event Hub to Azure Stream Analytics
[read this post on Mr. Fox SQL blog]
Recently I had a requirement to load streaming JSON data to provide a...
2017-11-07
764 reads
Improving instead-of-insert cardinality estimates for inserted and deleted pseudotables in SQL 2014+
Tricky triggers
In my last entry I noted that the performance of "instead-of" triggers can be tricky.
One of the reasons for...
2017-11-07
596 reads
dbatools with SQL on Docker and running SQL queries
I had a question from my good friend Andrew Pruski dbafromthecold on twitter or SQL Container Man as I call...
2017-11-07
653 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
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
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...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers