SQL Server Denali adds a new conversion function trio: PARSE(), TRY_PARSE() and TRY_CONVERT(). Here are the differences, answered as questions.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Denali – Conversion Function – TRY_CONVERT() – A Quick Introduction
Meet the TRY_CONVERT function in SQL Server Denali. It behaves like CONVERT, except a failed conversion gives you NULL rather than an error.
SQL SERVER – Denali – Conversion Function – TRY_PARSE() – A Quick Introduction
A quick introduction to the TRY_PARSE function in SQL Server Denali: it converts a string to a number or date, and returns NULL when it cannot.
Converting XML Documents to JSON With FOR JSON PATH
A partner asks for JSON from your XML export. Build the nested shape, decide what an empty order looks like, and avoid the escaped-array surprise.
SQL SERVER – Denali – Conversion Function – PARSE() – A Quick Introduction
A quick introduction to the PARSE function in SQL Server Denali: convert a string to a number or a date and time, and see what happens when it fails.
What a Preview Build Is For, and What It Is Not
Use a SQL Server preview to test specific features and report reproducible issues while keeping production data and recovery paths separate.
What Is a Data Warehouse?
A data warehouse is built for questions, not transactions. Facts and dimensions in plain words, why the star schema reads the way people talk, what a date dimension is for, and when you do not need one.
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.