SSIS Alpha Splits using the CODEPOINT() Function
A relatively common requirement in ETL processing is to break records into disparate outputs based on an alphabetical split on...
2010-02-12
1,423 reads
A relatively common requirement in ETL processing is to break records into disparate outputs based on an alphabetical split on...
2010-02-12
1,423 reads
I’d like to share a networking success story. Last year, I blogged about my experience at the PASS Summit of...
2010-02-05
1,191 reads
A relatively common requirement in ETL processing is to break records into disparate outputs based on an alphabetical split on...
2010-02-04
4,410 reads
If you’re anywhere from the southwest to the deep south, you’re probably aware of the impending winter weather bearing down...
2010-01-28
1,403 reads
This weekend, I’ll be headed for the east coast to speak at the SQL Saturday in Richmond, VA on Saturday. ...
2010-01-25
717 reads
Last weekend (January 15-17) found me at the third annual GiveCamp Dallas event, known locally as We Are Microsoft. This...
2010-01-23
741 reads
There is something to be said for helping others. However it isn't necessarily a selfless act. Guest writer Tim Mitchell talks a little about how helping others has helped him.
2010-01-20
230 reads
So for the latest database geek meme, Paul Randal started this thing off and tagged Tom LaRock, who enlisted Grant...
2010-01-19
2,443 reads
So the question came up earlier today about the RIGHT() and LEFT() functions in the SSIS expression language. Like the...
2010-01-13
670 reads
I got the opportunity to present to the PASS DBA Virtual Chapter today, discussing the properties and practical uses of...
2010-01-13
929 reads
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Comments posted to this topic are about the item Squared Values
Comments posted to this topic are about the item I Don't Want To Do...
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers