Cluster Service Failed To Bring Clustered Role Online Or Offline
This weekend I was working, as usual, holding the on-call and listening to my favorite singer Kishor Kumar. And, my friend Rakesh call me in jeopardy. One of his...
2022-02-18
62 reads
Convert Local Datetime to UTC (pre-SQL Server 2016)
Recently I was working with a client who was still on SQL Server 2012. Support issues aside, there are some very useful T-SQL functions/clauses who didn’t exist in 2012,...
2022-02-17
38 reads
SQL Saturday Colorado Springs 2022
In just over a month, SQL Saturday comes back to Colorado Springs. On Mar 19, SQL Saturday Colorado Springs 2022 is taking place at the local library. This is...
2022-02-17
92 reads
Daily Coping 17 Feb 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-02-17
40 reads
Configure SQL Server Reporting Services with AWS RDS SQL Server
How do you set up SQL Server Reporting Services in AWS RDS? We will show you how to configure SQL Server Reporting Services in AWS and RDS.
2022-02-17
218 reads
DP-900: What’s a Region and an Availability Zone
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-03-04 (first published: 2022-02-16)
275 reads
Checking accessibility in your day-to-day work
Last year I wrote a series of posts about accessibility as it relates to presentations, and one aspect which I didn’t cover is within the documents themselves. We create...
2022-02-16
103 reads
Daily Coping 16 Feb 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-02-16
46 reads
Key (Lookup) in SQL Server Key Lookup performance
Learn about SQL Server key lookup performance and how to improve the performance of key lookup queries.
2022-02-16
274 reads
SQL Server Execution Plan - Displays Estimated and Actual number of rows
This article focuses on getting the Displays Estimated and Actual number of Rows from the SQL Server Execution Plan. Read More
2022-02-28 (first published: 2022-02-16)
571 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers