Daily Coping 31 Jan 2022
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...
2022-01-31
22 reads
DP-900 Preparation Guide
This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can...
2022-01-31
54 reads
Data Pages – the Foundation of SQL Server
Last week we laid out the foundation for how SQL Server executes queries. I have also already talked here a little bit about pages that are buffers of 8kb....
2022-02-11 (first published: 2022-01-31)
808 reads
Creating Azure DB for MySQL – Single Server
Enough of the theory and text lets use the Azure Portal and create MySQL Single server. Navigate to the Azure Portal, find Azure Database for MySQL servers: Click create...
2022-01-31
42 reads
Ohio North Database Training User Group Presentation 1 Feb 2022
I am looking forward to presenting to the Ohio North Database Training User Group this Tuesday, February 1st, starting at 4:00pm CST. It is exciting for me to kickoff...
2022-01-29
42 reads
sp_GetRowcount: How to count the number of rows in any SQL Server table fast
Have you ever had to find the number of rows in a user table, and then wrote a little “SELECT COUNT(*) FROM tblWhatever” and hit execute…and waited…and waited…and waited...
2022-01-28
314 reads
Webinar with Pavilion Data 2022.02.09
Heraflux Technologies was invited to co-present on an “Ask the Experts” webinar with Pavilion Data featuring Costa Hasapopulous, Pavilion Data’s Chief Field Technology Officer, and myself! RSVP for this...
2022-01-28
18 reads
VS Live Cancelled
I got a note this week from the organizers of VS Live. They let me know the March event in Las Vegas was being cancelled. That was disappointing to...
2022-01-28
12 reads
Daily Coping 28 Jan 2022
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...
2022-01-28
36 reads
Get SQL Server Configuration using T-SQL
As a SQL architect or database administrator, it is required to know how to get SQL Server configuration using T-SQL. This post will share
2022-01-28
316 reads
Blogs
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Forums
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Finding Bad Queries
Comments posted to this topic are about the item Finding Bad Queries