Deleting a Package from the SSIS Catalog
Among the new features of SSIS 2016, one of my favorite is incremental package deployment. This new functionality allows the...
2017-05-31
3,176 reads
Statistics Parser
In the last post we looked at using the STATISTICS IO and STATISTICS TIME commands to measure query performance.
If you’ve...
2017-06-14 (first published: 2017-05-31)
2,535 reads
Parsing Docker Commands
Bit of a powershell themed post this week as I haven’t had that much time to research so this one...
2017-06-13 (first published: 2017-05-31)
1,183 reads
SQL Server Parameter Sniffing In Depth
If you’ve ever searched for SQL Server parameter sniffing you’ve probably read all sorts of bad things about it. In...
2017-05-31
121 reads
Powershell Module Improvements for SQL Server in 2017
simple setup
A major improvement that seems to have quietly slipped into the sql developers world is an improved SQLServer powershell...
2017-06-19 (first published: 2017-05-31)
2,234 reads
Implementing Fuzzy Sets in SQL Server, Part 10.2: Measuring Uncertainty in Evidence Theory
By Steve Bolton
…………To avoid overloading readers with too many concepts at once, I split my discussion of Dempster-Shafer Evidence...
2017-05-31
768 reads
Log File Space Issue Monitoring Using SQL Server DMV
As a continuation of “Database Monitoring using DMV” series, this blog will cover how quickly you can address the log...
2017-06-14 (first published: 2017-05-31)
5,794 reads
Making Phone Calls from Azure Event Hub Messages
Recently I did a presentation at our local SQL Server User Group (SSUG) on Managing Streaming Data Pipelines Using Azure Data Services and as such wanted to build out...
2017-05-30
16 reads
Making Phone Calls from Azure Event Hub Messages
[read this post on Mr. Fox SQL blog]
Recently I did a presentation at our local SQL Server User Group (SSUG) on Managing...
2017-05-30
1,272 reads
Columnstore Indexes – part 106 (“Memory Requirements for Rebuild & Reorganize”)
Continuation from the previous 105 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
One of the most important and recurring...
2017-05-30
921 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
When the Token Meter is Zero
Comments posted to this topic are about the item When the Token Meter is...
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers