What collation variables take on in T-SQL
I was asked an interesting question about collations in sql server recently about where variables in a script got their...
2014-10-22
41 reads
Ed Elliott's Sql Developer Blog
What collation variables take on in T-SQL
I was asked an interesting question about collations in sql server recently about where variables in a script got their collation's from. I really wasn't too sure of the...
2014-10-22
8 reads
DBAs - Step away from production
I have worked as a DBA and also as a Sql Server developer and in many roles had full access...
2014-10-21
40 reads
DBAs - Step away from production
I have worked as a DBA and also as a Sql Server developer and in many roles had full access...
2014-10-21
40 reads
DBAs - Step away from production
I have worked as a DBA and also as a Sql Server developer and in many roles had full access...
2014-10-21
15 reads
DBAs - Step away from production
I have worked as a DBA and also as a Sql Server developer and in many roles had full access to production, it is OK though I know what...
2014-10-21
3 reads
DevDev
There has been a gigantic shift in attitudes between development and operations, the devops movement, to create a streamlined, automated...
2014-10-20
51 reads
DevDev
There has been a gigantic shift in attitudes between development and operations, the devops movement, to create a streamlined, automated...
2014-10-20
38 reads
DevDev
There has been a gigantic shift in attitudes between development and operations, the devops movement, to create a streamlined, automated and high performing team of developers and infrastructure techs...
2014-10-20
6 reads
Blog Redirected
I have moved my blog over to here, expect exciting posts about the things that interest me my previous blog...
2014-10-20
55 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers