Regular expressions (or simply regex for short) have long been used by system administrators and data professionals for searching and manipulating text. Regular expressions allow the user to find,...
2019-12-16
62 reads
I want to wrap up the notes on SQLSaturday by writing about my approach to managing events that I’ve evolved at SQLSaturday but definitely applies to most events and...
2020-01-03 (first published: 2019-12-16)
268 reads
A little over a week ago, I got a new laptop. This was late on a Sunday afternoon, and I went home to spend time with me wife. After...
2019-12-16
219 reads
(2019-Dec-15) While working on data integration projects and using Azure Data Factory as your main orchestration tool will help you to develop strategic forward thinking about your development tasks: to...
2019-12-31 (first published: 2019-12-16)
5,601 reads
I’m a creature of habit. With the software tools that I use, I like to have everything in the same place every time, even if I’m working on a...
2019-12-15
295 reads
Don’t know about you, but one of my least favourite data pipeline errors is
the age-old failure caused by schema changes in the data source, especially
when these don’t...
2019-12-15
28 reads
Don’t know about you, but one of my least favourite data pipeline errors is
the age-old failure caused by schema changes in the data source, especially
when these don’t...
2019-12-15
127 reads
Don’t know about you, but one of my least favourite data pipeline errors is
the age-old failure caused by schema changes in the data source, especially
when these don’t...
2019-12-31 (first published: 2019-12-15)
1,382 reads
Did you know that SQL Server Management Studio can help you arrange your SQL scripts into logical groupings? SSMS includes the ability to associate multiple code files together into...
2019-12-14
48 reads
While at PASS Summit 2019, I gave a session on designing Azure Disaster Recovery Strategies for the Data Platform. In that session, I talked about Azure storage and the...
2019-12-13
31 reads
The STIG is detailed, which is a good thing, but I found myself wanting...
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Referrals have never been more important in the job market. They’re no longer nice...
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers