A friend was asked in an interview how to find the days in a year efficiently. Here are the T-SQL methods I tried, plus a small quiz for you.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Add Node in Cluster – Rule “Node and cluster edition match” failed
Running AddNode on the second cluster node failed with the rule Node and cluster edition match. Here is what the setup logs revealed and how to solve it.
SQL SERVER – Adding a Master Data Services to your Enterprise – Notes from the Field #072
Reeves Smith explains why you should add Master Data Services to your enterprise and why data governance is often overlooked in data warehouse projects.
SQL SERVER – Backup on mapped drive failing with error – Error 3201, Level 16, State 1
Backup on a mapped drive failing with Error 3201? The SQL Server service does not see the drive you mapped in Windows. Here is why, and what to do.
SQL SERVER – Marking Filegroup as ReadOnly with SQL Server
Readers asked how to mark a filegroup as ReadOnly. Here is a T-SQL script that creates a test database, adds a filegroup and marks it ReadOnly.
SQL SERVER – Interesting Observation with Currency Symbols
Did you know currency symbols like $ and £ are treated as money values in SQL Server? SELECT $ returns 0.00, and you can even use them in math.
Interview Question of the Week #011 – Script to Convert List to Table and Table to List
Convert a table to list with ordered STRING_AGG, split a list with STRING_SPLIT ordinals, and handle NULLs and empty tokens clearly.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.