SSIS and Data Quality Webcast
On Thursday the 2nd of May, I’ll be giving a webcast for MSSQLTips.com about data quality and SSIS. The abstract: SQL Server Integration Services (SSIS) has been around for...
2019-04-10
30 reads
Blog Posts
Uppercase All String Columns (and in a Single Query!)
(last updated: 2019-03-21 @ 15:00 EST / 2019-03-21 @ 19:00 UTC )
Intro
The other day, Steve Jones published a short post with a quick...
2019-04-10 (first published: 2019-03-20)
1,536 reads
Using a home-grown Azure Blob Storage solution for SQL Server backups
I’m here for the small organizations, the shops that can’t afford expensive solutions to maintain their environments. I’m here for them because that’s me: the one-person consultancy. I’ve built...
2019-04-10
34 reads
Data Type Precedence and Implicit Conversions
Watch this week's video on YouTube
SQL Server needs to make sure data types match when performing operations that involve multiple pieces of data.
When the data types do not match,...
2019-04-09
16 reads
Data Type Precedence and Implicit Conversions
Watch this week's video on YouTube
SQL Server needs to make sure data types match when performing operations that involve multiple pieces of data.
When the data types do not match,...
2019-04-09
24 reads
Delete activity in Azure Data Factory - Cleaning up your data files
(2019-Mar-20) File management may not be at the top of my list of priorities during data integration projects. I assume that...
2019-04-09 (first published: 2019-03-20)
4,562 reads
Making Databases Personal
If you can use a database to create automation routines to help sustain your work life, you can certainly do the same to sustain your personal life. Databases are...
2019-04-09
6 reads
Making Databases Personal
If you can use a database to create automation routines to help sustain your work life, you can certainly do the same to sustain your personal life. Databases are...
2019-04-09
133 reads
T-SQL Tuesday #113 – What Do I Use MY Databases For?
This month’s T-SQL Tuesday blog is brought to us by Todd Kleinhans (b | t) and this month topic is about what you use databases in your personal life. ...
2019-04-09
9 reads
T-SQL Tuesday #113 – What Do I Use MY Databases For?
This month’s T-SQL Tuesday blog is brought to us by Todd Kleinhans (b | t) and this month topic is about what you use databases in your personally life. ...
2019-04-09
27 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers