SQLibrium SQL Server on VMware training now free
I’m proud to be a part of the SQL Server communities globally. I do everything I can do to give back when I can. Too many times, I feel...
2022-12-02 (first published: 2022-11-15)
284 reads
Blog Posts
Daily Coping 1 Dec 2022
Today’s coping tip is to discover your artistic side. Design a friendly greeting card. A fun one for me today. I saw this just after returning from the PASS...
2022-12-01
14 reads
Daily Coping 29 Nov 2022
Today’s coping tip is to make a meal using a recipe or ingredient you’ve not tried before. It’s the holidays, and my daughter is home. She’s GF, so I’m...
2022-11-30
11 reads
Daily Coping 30 Nov 2022
Today’s coping tip is to learn a new skill from a friend or share one of yours with them. I like learning, so in this case, I took advantage...
2022-11-30
11 reads
In SQL Server 2022, set your transaction log file autogrowth rate to 64 MB
A late-breaking change that arrived in SQL Server 2022 is an important one that could be a new line item in your health checks.
The basics:
Starting with SQL Server 2022,...
2022-11-30 (first published: 2022-11-17)
573 reads
My adventures with speaking and what changed
I am writing this blog post as contribution to #NewStarNovember and what got me re-started as a tech speaker in 2020. I haven’t done a lot of tech speaking...
2022-11-30 (first published: 2022-11-29)
13 reads
PASS Summit 2022 - Day 2 In Pictures
Day 2 of Summit 2022 started earlier than usual with the "Breakfast with the Microsoft team: SQL Futures and Strategy" - the food was good and the conversations with...
2022-11-30 (first published: 2022-11-18)
215 reads
Query Store Hints in SQL Server 2022
Another neat little feature in SQL Server 2022 is Query Store Hints. This is the ability to apply a query hint through Query Store rather than having to modify...
2022-11-30
67 reads
User Group Meeting – Migrate your SSIS skills to ADF & More
This Monday (the 5th of December 2022), my employer AE hosts a user group meeting for dataminds. There will be two sessions: It’ll be a very interesting evening, and...
2022-11-30
17 reads
Automatically Take Missed Backups with Ola Hallengren’s Scripts
I blogged a few years ago about my configuration tables for Ola Hallengren’s maintenance solution that allows me to pull the configuration parameters from tables
The post Automatically Take Missed...
2022-11-29
50 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers