Followup for the Kansas City SQL Server User Group
I had a great time speaking at the Kansas City SQL Server User Group on Thursday, February 18th. The more I present my Backup Basics with PowerShell and dbatools...
2021-02-20
6 reads
Daily Coping 19 Feb 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-02-19
19 reads
Daily Coping 18 Feb 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-02-18
28 reads
Azure SQL Database F and M series
Taking a screen shot from my Azure Portal, you will see the available hardware configurations available for Azure SQL Database. I wrote about Generation 4 and 5 in the...
2021-02-18
56 reads
Azure Data Factory Activity Failures and Pipeline Outcomes
Question: When an activity in a Data Factory pipeline fails, does the entire pipeline fail?Answer: It depends In Azure Data Factory, a pipeline is a logical grouping of activities...
2021-02-25 (first published: 2021-02-18)
705 reads
2020 Advent of Code–Day 2
This series looks at the Advent of Code challenges. As one of my goals, I’m working through challenges. This post looks at day 2. Part 1 This problem is...
2021-02-17
32 reads
Announcing the Azure Data Community from Microsoft
You can see an announcement from Buck Woody (b | t) of Microsoft on Data Exposed. Essentially, Microsoft is providing a number of free resources to help local user...
2021-02-24 (first published: 2021-02-17)
519 reads
How does the buffer pool handle low memory conditions?
(Thanks to Erik Darling for reviewing this post. Check out his training materials.) One of the bigger clichés in the data professional vocabulary (behind “it depends”) is that you...
2021-04-20 (first published: 2021-02-17)
546 reads
Daily Coping 17 Feb 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-02-17
25 reads
SQL Index Creation Using DROP EXISTING= ON
When you are making changes to an existing Non-Clustered index SQL Server provides a wide variety of options. One of the more frequently used methods is DROP EXISTING; in...
2021-02-17
29 reads
Blogs
TRY_PARSE Limitations: #SQLNewBlogger
By Steve Jones
I got a notification from a question I’d posted at SQL Server Central: Getting...
SQL Server sa Account Security: Rename, Disable & Best Practices
By SQLPals
SQL Server sa Account Security: Rename, Disable & Best Practices In...
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
Forums
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
A Limited Startup
Comments posted to this topic are about the item A Limited Startup
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers