2016-04-12 (first published: 2014-03-12)
2,389 reads
NULLs to Not NULLs
Script finds char types columns defined to allow NULL values but have non NULL values and generates the ALTER statements for the changes.
2016-02-22 (first published: 2016-02-08)
1,018 reads
2014-11-10 (first published: 2014-10-01)
1,351 reads
Shrinking all log files on SQL Server 2008R2
It shrinks all log files for the databases created by users.
2012-11-02 (first published: 2012-09-27)
3,922 reads
Blogs
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...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Forums
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...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Having a Little Fun at SQL Server Central
Comments posted to this topic are about the item Having a Little Fun at...
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