Source Code Security
The code you use may contain security information. Be extra careful in this case, especially when you use encryption.
2015-03-31
153 reads
Editorials
One Rule, Umpteen Constraints
Despite being deprecated for many years, Phil Factor explains why RULEs are still hanging on in there in SQL Server 2014.
2015-03-30
105 reads
Efficiency
This Friday Steve Jones asks about how you are tackling your career growth as you get older. Are you getting more efficient?
2015-03-26 (first published: 2010-10-22)
313 reads
Are There That Many GUIDs?
Steve Jones talks about a recent survey that showed more people use GUIDs as primary keys than identity values.
2015-03-24 (first published: 2010-10-12)
674 reads
First Episodes
Today we have a guest editorial from Andy Warren where he looks back at how things have changed.
2015-03-23
123 reads
Microservices, SOA and Service Broker
If you want to implement a service-oriented architecture on Windows, Service Broker is still your best choice, argues Phil Factor.
2015-03-23
458 reads
Microsoft and R
R is an interesting language and one that might become more important to data professionals in the future. Microsoft is also making an investment here.
2015-03-19
496 reads
2015-03-18
799 reads
Computational Biologist
A job Steve Jones has never heard of is using data to improve medical treatments.
2015-03-16
97 reads
2015-03-16
171 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