SQL Server is one of the best products to come out of Microsoft, but not every professional knows how to use it effectively. For example, some might find it difficult to create a stored procedure but ...

Recently I encountered a problem in a stored procedure that was caused by an unexpected result from the SQL Server ISNUMERIC() function. I was using SQL Server 2008 R2 but the issue has long been ...

Most of the popular relational database systems, SQL Server, Oracle, MySQL and the like, support stored procedures. A stored procedure is nothing more than a piece of code that performs some ...

no documentation and lots of stored procedures transforming data. At some point I wanted a tool that would analyse all the stored procedures and generate a lineage that I would be able to send to a ...

We are excited to announce that you can now directly call SQL Server stored procedures in Power Fx. You no longer need to call a Power Automate Flow to use a stored procedure. This feature is in ...

The annual PASS Summit, the industry’s largest gathering of SQL Server professionals, hosted more than 4,000 attendees in Seattle recently recently. PASS (www.pass.org) has grown to more than 300 ...

We are excited to announce that calling SQL Server stored procedures in Power Fx is now generally available in all regions. You do not need to call a Power Automate Flow to use a stored procedure ...