Often times, I work with a stored procedure that takes a complex input and does some work with it. By complex, I usually mean at least one value passed in that contains a non-specific number of values ...

Hello and thanks for MSSQL MCP, it's a really useful tool. It'd be nice to see more tools added, beyond CRUD. In particular, Stored Procedures calling/metadata retrieval. This would allow us to ...

Last time, we showed how to take advantage of a built-in stored to run a command against multiple tables. This time, we look at another for working against a bunch of databases. In my last post, I ...

I have a program that gets data from a website. That data is subsequently processed via Regex, and the data is inserted into a database.<br><br><pre class="ip-ubbcode ...

In a previous column, I talked about how a memory-optimized table can dramatically speed up the performance of the typical business application. But memory-optimized tables give you another tool to ...