Azure SQL Database and Long-Term Backups
There is a new (ish) interface to looking and configuring backups for your Azure SQL Database. This can be found within the settings section of the SQL Server. As...
2021-02-02
100 reads
Daily Coping 1 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-02
22 reads
What are Statistics in SQL Server?
Statistics are vitally important in allowing SQL Server to find the most efficient way to execute your queries. In this post we learn more about them, what they are...
2021-03-24 (first published: 2021-02-01)
402 reads
Power of Unlearning
(2021-Jan-31) Working on DIY home projects is always fun, choosing the right tools: whether I handle paperhanging scissors to cut my wallpapers, or create an opening and trim my drywall...
2021-02-10 (first published: 2021-02-01)
259 reads
Goal Progress–Jan 2021
I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2021. As I look at goal progress for 2021, I’m going...
2021-01-29
23 reads
Daily Coping 28 Jan 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-01-28
33 reads
3 new PowerShell functions for refreshing Power BI reports on a Power BI Report Server
I just wanted to give everyone a heads-up that a new version of the ReportingServicesTools module went out last week, and it includes 3 new PowerShell functions for working...
2021-01-28
25 reads
3 new PowerShell functions for refreshing Power BI reports on a Power BI Report Server
I just wanted to give everyone a heads-up that a new version of the ReportingServicesTools module went out last week, and it includes 3 new PowerShell functions for working...
2021-02-08 (first published: 2021-01-28)
745 reads
2020 Advent of Code–Day 1
This series looks at the Advent of Code challenges. I started the Advent of Code at the beginning of December 2020, but life quickly got in the way. Weekends...
2021-02-08 (first published: 2021-01-27)
269 reads
Server Review Essentials for Accidental and Junior DBAs—Setting Up (Part 2)
Welcome back to my Server Review Essentials for Accidental and Junior DBAs series. Last week, we took a closer look at the first steps of getting your environment set...
2021-02-03 (first published: 2021-01-27)
380 reads
Blogs
Project Management – Part 1
By Vinay Thakur
The soul of project management is Process Group(PG) and Knowledge Area(KA). they are related...
Install SQL Server 2025 Container on macOS Using OrbStack
My old Dell XPS that I used for personal stuff started to degrade; well,...
Flyway Tips: Immediate Code Review for Developers
By Steve Jones
At the Redgate Summits this year, we’ve highlighted a few things in the Flyway...
Forums
Impact of Single-Threaded PVS Cleanup on ADR in SQL Server 2019
We want to enable ADR on our SQL Server 2019 instances. I’ve heard that...
Forward Deployed Engineers
Comments posted to this topic are about the item Forward Deployed Engineers
TRY_PARSE vs TRY_CONVERT in SQL Server: From Basics to Practical Usage
Comments posted to this topic are about the item TRY_PARSE vs TRY_CONVERT in SQL...
Question of the Day
DBCC CHECKDB Limits II
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers