Azure SQL database SKU selection
When migrating on-premise SQL Server database to Azure SQL environment, identifying the right compute capacity of the target environment to match the resource consumption of(more...)
2021-05-08
136 reads
Thanks Kathi and Mala
I have to thank Kathi and Mala for putting on the WIT Mental Health and Wellness today today. I was honored to present, but I was more glad that...
2021-05-08
22 reads
Understanding NUMA in SQL Server VMs
Last Updated on January 8, 2022 by John Morehouse What really is NUMA and why do we as database administrators care? NUMA stands for “Non-uniform Memory Access” and allows...
2021-05-07
361 reads
Goal Progress for April 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-05-07
13 reads
Daily Coping 7 May 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-05-07
30 reads
A notebook, a guideline, and a workshop
I've come to the conclusion that most of us need to hear this: You cannot do Bullet Journaling wrong; your journal is a tool that's there for you, not...
2021-05-06
29 reads
A notebook, a guideline, and a workshop
I've come to the conclusion that most of us need to hear this: You cannot do Bullet Journaling wrong; your journal is a tool that's there for you, not...
2021-05-06
41 reads
Daily Coping 6 May 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-05-06
15 reads
All jobs that ran during a given time frame.
Short post today. Simple query that will tell you every job that ran between two datetime stamps. Note: this of ... Continue reading
2021-05-17 (first published: 2021-05-06)
683 reads
Instructions for Handling Errors of MySQL and PHPMyAdmin
One of my clients, Justin Williams, is a blogger. He owns a website named TheDehumidifierExperts which is all about dehumidifier reviews of all types, including both large dehumidifiers for...
2021-05-06
12 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
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...
Forums
Alamat BCA KCP Iskandar Muda Telp/Wa:0821-8200-233
Hub CS 08218200233 Jl. Sultan Iskandar Muda No.Kav. 80/1-2, RT.2/RW.3, Kby. Lama Utara, Kec....
BCA KCP Panglima Polim Raya Tlp:0821-8200-203
Telp/Wa 628218200203 Ruko Grand Panglima Polim, Jl. Panglima Polim No.16-17, RT.2/RW.1, Pulo, Kec. Kby....
Alamat BCA KCP Kota Kasablanka Tlp/Wa:0821-8200-174
Hub CS 08218200174 1st Floor – Unit B EightyEight@kasablanka, Jl. Raya Casablanca No.Kav. 88,...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers