How to write an INSERT query
My First INSERT Statement Last week we covered how to get information out of a table, using a SELECT query....
2017-05-31
403 reads
SQL Crossword
I thought I’d do another crossword. Enjoy! If you need any help with it feel free to let me know...
2017-06-16 (first published: 2017-05-31)
2,809 reads
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,196 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,569 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,188 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
128 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,237 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
777 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,801 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
21 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