Azure Robots – Index Performance Recommendation
They are watching me and my Azure SQL Database and recently I noticed a low impact performance recommendation was made....
2017-06-01
439 reads
Database Fundamentals
One of my favorite things about being a technologist is constantly learning new things, but, this can lead us to...
2017-06-15 (first published: 2017-05-31)
2,793 reads
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
398 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,807 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,171 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,528 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
766 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers