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...

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...

SQL Server Triggers and Transactions

In this post I’m going to detail with examples how triggers behave with transactions…

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...

Day 18 Storage engine

MySQL is special compare to all the other RDBMs System because of its special architecture, the STORAGE Engine. MySQL has...

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...

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,...

Randomizing Names with Data Masker

Data Masker for SQL Server is pretty cool. It can reduce your attack surface area and exposure under the GDPR...

Why I blog: TSQL Tuesday #102

It’s TSQL Tuesday again! This month our host is Riley Major (b/t) and the subject is Giving Back. He’s given...

Automate SQL Server Database Restoration using bacpac with PowerShell or Batch techniques

Data is the key to your organization’s future, but if it’s outdated, irrelevant, or hidden then it’s no good. Maintenance...