2012-08-17
3,534 reads
Jack Hummer
XML Argument Protocols for SQL 2005 Stored Procedures
SQL Server 2005 has made it much easier to work with XML data in your database applications than ever before. In this article, new author Jack Hummer examines how you can use XML to move data through stored procedures.
2006-10-02
9,376 reads
Blogs
Updated Pluralsight Course – Kubernetes Installation and Configuration Fundamentals
My updated course “Kubernetes Installation and Configuration Fundamentals” in now available on Pluralsight here! If you want...
Power BI and a Star Schema
By James-Serra
I sometimes get asked from customers if they should use a star schema or...
A New Git Default Branch
By Steve Jones
I learned a new trick from Andrew Pruski. In a blog on avoiding PowerPoint,...
Forums
xp_cmdshell
how to check which job or stored procedure using xp_cmdshell in sql server ?
consolidate error logs
i need to configure job to consolidate sql error log sizes from multiple servers...
How to write update query to check exist column by value 1 where it exist on tab
How to update check exist column by value 1 where partid exist on table...
Ask SSC