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
212 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
445 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
136 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,375 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
159 reads
SQL Server Triggers and Transactions
In this post I’m going to detail with examples how triggers behave with transactions…
2018-05-19
63 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
373 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
265 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
409 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
21 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers