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
258 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
761 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
SQL Server Management Studio Reports
Today’s tip is a very basic functionality that comes with any SSMS (SQL Server Management studio), we are talking about...
2017-11-07
183 reads
Analytics Platform System (APS) AU6 released
Better late than never: The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), released an appliance update...
2017-11-07
1,055 reads
Extended Events and Profiler: XE Profiler
There’s a war on in the SQL Server world. On the one side is Profiler (although, really, everyone uses Trace...
2017-11-07
452 reads
4 Common Misconceptions About SQL Injection Attacks
Photo by Jaanus Jagomägi on UnsplashInterested in learning more about SQL injection attacks, including how to prevent them? Attend my online webcast on...
2017-11-07
344 reads
4 Common Misconceptions About SQL Injection Attacks
Photo by Jaanus Jagomägi on Unsplash
Interested in learning more about SQL injection attacks, including how to prevent them? Attend my online webcast on Tuesday November 14, 2017 at 1PM Eastern at the...
2017-11-07
13 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers