Day 19 MyIASM Storage engine
MyIASM storage engine is available from the early stage of MySQL this engine is developed from IASM language and it...
2018-05-19
207 reads
Blog Posts
Helper function to convert binary to decimal and back
In this post you will find two small functions that convert binary value to a decimal one and vice versa.
2018-05-19
422 reads
How to Extract last name or first name(s) from a combined field
Extracting pieces of information from a string can be a daunting task. This is an example of a REVERSE technique.
The...
2018-05-19
1,362 reads
How to Extract last name or first name(s) from a combined field
Extracting pieces of information from a string can be a daunting task. This is an example of a REVERSE technique.
The...
2018-05-19
123 reads
SQL Server Triggers and Transactions
In this post I’m going to detail with examples how triggers behave with transactions…
How Do Triggers Behave With Transactions?
To demo...
2018-05-19
134 reads
SQL Server Triggers and Transactions
In this post I’m going to detail with examples how triggers behave with transactions…
2018-05-19
57 reads
Data Recovery : Page level restore in SQL Server
In this article, we shall discuss the importance of understanding the internals of the page restoration for a database administrator. Most...
2018-05-18
361 reads
Day 18 Storage engine
MySQL is special compare to all the other RDBMs System because of its special architecture, the STORAGE Engine. MySQL has...
2018-05-18
259 reads
New Article: Return SQL Server Connections Information Using sys.dm_exec_connections
I’ve started a new series at MSSQLTips.com walking through the various Dynamic Management Objects we have available to us in SQL...
2018-05-18
396 reads
Quick Table Info Export with PowerShell
This week I had a user come to me asking about how fields were defined on a few tables he was using in writing some reports. Long story short,...
2018-05-18
7 reads
Blogs
Redgate and Rome
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
PowerShell Newbie – Variables
By gbargsley
This is Week 2 of PowerShell Strikes Back – a four-week May series for...
Forums
SSRS Is Dead. Here Are Your Real Options
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
The Distance Metric
Comments posted to this topic are about the item The Distance Metric
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers