Disk Performance Metrics in AWS and Azure
In the last two posts, we have discussed the different types of storage disks available in the AWS and Azure cloud platforms. We also discussed the characteristics that affect...
2020-04-19
15 reads
PracticalSQLDba
Disks performance in Azure
In our earliest post, we have discussed in detail about the factors that affect the disk performance and different types of disk offerings in the AWS platform. In this...
2020-04-14 (first published: 2020-04-05)
1,957 reads
Disks performance in Azure
In our earliest post, we have discussed in detail about the factors that affect the disk performance and different types of disk offerings in the AWS platform. In this...
2020-04-05
14 reads
Understanding Disk Performance and IOPS in cloud platform
In the past many years, apart from working as DBA, I was working with multiple cloud technologies and actively involved in the migration process to cloud infrastructure. In between,...
2020-04-06 (first published: 2020-03-29)
2,900 reads
Understanding Disk Performance and IOPS in cloud platform
In the past many years, apart from working as DBA, I was working with multiple cloud technologies and actively involved in the migration process to cloud infrastructure. In between,...
2020-03-29
20 reads
SQL Server Backup and Restore Strategy Step by Step
Introduction:
Who is not aware of a SQL Database? It was the first business language introduced for E.F Codd’s Relational Database management system. In addition, MySQL, Oracle, Informix, Sybase, MS...
2020-02-20 (first published: 2020-02-12)
1,458 reads
How to Fix SQL Database Logical Consistency Based I/O Error
There can be several reasons that cause Database Logical Consistency based I/O error:
Unexpected system shutdown/crash or forced shutdown
SQL administrator tries to query or modify SQL data
In both the circumstances,...
2019-11-26
34,472 reads
How to Reduce the Risk of SQL Database Corruption
Introduction:
Today we are going to learn how to prevent SQL database corruption. Let’s start with some facts about how database corruption can occur actually. The SQL database corruption could...
2019-10-09
364 reads
An Effective Solution to Resolve SQL Database Corruption
I am a SQL Administrator and today I will share my experience about an issue on SQL server, which corrupted the transaction logs and left the database in a...
2019-09-25 (first published: 2019-09-17)
2,871 reads
SQL Server :Part 1 : Architecture of Transaction Log
In our earlier post, we have discussed in detail about the architecture of the data file and different types of pages. In this post, we will be discussing about...
2013-10-01
184 reads
Blogs
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
KDA: Echoes of Deception - Case 4
By Zikato
Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...
EightKB 2026 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...
Forums
Displaying Money
Comments posted to this topic are about the item Displaying Money
The Slow Growing Problems
Comments posted to this topic are about the item The Slow Growing Problems
Calculating the Harmonic Mean in Power BI
Comments posted to this topic are about the item Calculating the Harmonic Mean in...
Question of the Day
Displaying Money
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers