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
121 reads
Blog Posts
SQL Server Triggers and Transactions
In this post I’m going to detail with examples how triggers behave with transactions…
2018-05-19
56 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
128 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
360 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
257 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
391 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
6 reads
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...
2018-05-18 (first published: 2018-05-07)
3,154 reads
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...
2018-05-18 (first published: 2018-05-08)
1,814 reads
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...
2018-05-17 (first published: 2018-05-08)
4,667 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
SQL Server 2025 Backup Compression Algorithm
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers