Speaking at dataMinds Connect 2022
I’m very excited to announce I’ll be giving a session at the 15th edition of dataMinds Connect (in the beginning it was called SQL Server Day(s)). It will be...
2022-06-17 (first published: 2022-06-16)
33 reads
Opening your SQL Backup Folder using Powershell
Sometimes I find remembering where a particular server sends its backups to a nightmare. You might have servers backing up to different locations, you might have different locations for...
2022-06-16
47 reads
Azure CLI – Deleting Resources
Azure CLI is really handy for all sorts of tasks. When I build solutions, POCs and environments and I want to tear down the resources I like to use...
2022-06-16
46 reads
Migrate Amazon RDS for SQL Server to Azure SQL Managed Instance.
Applications are closely dependent on the databases and application evolution is frequently connected with an upgrade of the application database. Database migration is process of moving customer’s database from...
2022-06-16
172 reads
DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS with Example
The T-SQL DBCC, acronym for “Database Console Command”, is a command that performs several types of tasks. These tasks are mainly of the validation and maintenance type. Some of the...
2022-06-16
9,756 reads
Using a Regular Expression to Detect a Number–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Here are some hints to get started. I...
2022-06-15
112 reads
Daily Coping 15 Jun 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-06-15
23 reads
Azure Storage Replication Types
Storage Accounts are pretty much integrated into so many different designs in Azure, whether you are using Azure Synapse, 3rd party product like Snowflake, or Event Streaming designs –...
2022-06-15
81 reads
Too many coding standards : T-SQL Tuesday #151
One of my favorite people, Malathi Mahadevan (blog|twitter), is our host this month and she’d like to talk about coding ... Continue reading
2022-06-14
94 reads
T-SQL Tuesday 151: T-SQL Coding Standards
It’s that time of the month again, the blog party, woohoo! This time Mala Mahadevan (b | t) has invited us to blog about our T-SQL coding standards. I...
2022-06-14
64 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