More Than One Way to Skin a Cat
There are many ways to accomplish a task in SQL Server, and almost every technology. But too much choice might not be the best thing for beginners.
2008-02-12
48 reads
Articles
More Than One Way to Skin a Cat
There are many ways to accomplish a task in SQL Server, and almost every technology. But too much choice might not be the best thing for beginners.
2008-02-12
44 reads
Taking the Temperature of Your Data
Enhanced model performance comes from extracting as much information content as possible… relative to the specific performance metrics you are using to measure success.
2008-02-12
2,257 reads
Implementing a Generic Data Access Layer in ADO.NET Part 1
In Part 1 of a 3 Part Series Joydip Kanjilal discusses the implementation of a provider independent Data Access Layer in ADO.NET.
2008-02-11
3,554 reads
RegexClean Transformation
Use the power of regular expressions to cleanse your data right there inside the Data Flow. This transformation includes a full user interface for simple configuration, as well as advanced features such as error output configuration.
2008-02-11
1,704 reads
And Then There Was One - iPod
Windows 2008 RTMs, a change from the SQL Server support team, and a Jump Start for Katmai.
2008-02-09
38 reads
And Then There Was One - MP3
Windows 2008 RTMs, a change from the SQL Server support team, and a Jump Start for Katmai.
2008-02-09
44 reads
And Then There Was One - WMV
Windows 2008 RTMs, a change from the SQL Server support team, and a Jump Start for Katmai.
2008-02-09
43 reads
The Identity Debate
Using the Identity Property might be one of the more debated features of SQL Server.
2008-02-09
51 reads
The Identity Debate
Using the Identity Property might be one of the more debated features of SQL Server.
2008-02-09
45 reads
Blogs
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022
By SQLPals
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022 ...
Looking Back at the Redgate 2026 Company Kickoff
By Steve Jones
Last week I spent a few days in Cambridge, UK for the Redgate Company...
PASS Data Community Summit 2025 Recap
By alevyinroc
This is long overdue but life and distractions happened. It’s been a little over...
Forums
Microsoft no longer being supported?
The word is finally out that Microsoft is no longer supporting SSRS. I just...
SQL Agent job running gMSA cannot backup to NAS target
I'm running a group MSA for the database engine and SQL Agent in a...
sys.query_store_query question
All, My query is as follows: SET DATEFORMAT dmy SELECT p.query_id, DATEADD(MICROSECOND,-rs.max_duration,rs.first_execution_time) AS starttime,...
Question of the Day
Encoding Strings
I have this code in SQL Server 2025. What is the result?
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(@message); SELECT @encoded AS EncodedResult;See possible answers