PASS SQLSaturday’s I will be speaking at
I will be speaking at two upcoming PASS SQLSaturday’s. These are free events that you can attend virtually: Azure Synapse Analytics: A Data Lakehouse 12/5/20, 1:10pm EST, PASS SQL...
2020-12-02
31 reads
Blog Posts
Requesting Comments on the SQLOrlando Operations Manual
For the past couple weeks I’ve been trying to capture a lot of ideas about how and what and why we do things in Orlando and put them into...
2020-12-02
52 reads
Server-Level Roles – Back to Basics
In this article, I have shown how to use the power of custom server roles to help reduce your administration time. The custom security role is like using a...
2020-12-02 (first published: 2020-11-20)
383 reads
SQL Database Corruption, how to investigate root cause?
Introduction:
In this article, we will discuss the MS SQL Server database corruption.
So, first, we need to understand what the cause of corruption is. Usually, in all the scenarios of...
2020-12-02
21 reads
SQL Database Corruption, how to investigate root cause?
Introduction:
In this article, we will discuss the MS SQL Server database corruption.
So, first, we need to understand what the cause of corruption is. Usually, in all the scenarios of...
2020-12-02
216 reads
T-SQL Tuesday Retrospective #006: What about blob?
I am revisiting old T-SQL Tuesday invitations from the very beginning of the project. On May 3, 2010, Michael Coles invited us to write about how we use LOB...
2020-12-02
25 reads
Azure Stack and Azure Arc for data services
For those companies that can’t yet move to the cloud, have certain workloads that can’t move to the cloud, or have limited to no internet access, Microsoft has options...
2020-12-01 (first published: 2020-11-18)
552 reads
Daily Coping 1 Dec 2020
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...
2020-12-01
16 reads
Inspector 2.4 now available
All the changes for this release can be found in the Github Project page Mainly bug fixes this time around , but we have also added new functionality: Improvements...
2020-12-01
41 reads
PASS Summit 2020 Mental Health Presentation Eval Comments
I first starting presenting on mental health last December in Charlotte, NC on mental health. I got some backlash at a couple of events for a few people on...
2020-12-01
3 reads
Blogs
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Questions and Answers from Running a Local LLM
By Steve Jones
I had a few random questions from my Running a Local LLM on Your...
Overview of Claude AI Models: Which One to Choose?
By Arun Sirpal
For those entering the AI space whether professionally or personally I wanted to give...
Forums
A question about how to store the address in the database
I have an app that has an address field on the customer and the...
SSIS package failing intermittently on last Excel Component
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers