Server blocked access to XP_CMDSHELL
XP_CMDSHELL is one of those features that is turned off by default on SQL Server and needs to be turned on to function. If xp_cmdshell… Read More »Server blocked access to XP_CMDSHELL
TSQL
Using TSQL to Read an RSS Feed
Most blogs have a RSS feed of some kind. The RSS feed is usually comprised of XML with a list of the most recent posts.… Read More »Using TSQL to Read an RSS Feed
Ask a question about Database Corruption
Now is your chance to ask a question about corruption in SQL Server databases. We will do our best job of answering those questions on… Read More »Ask a question about Database Corruption
Performance: Faster way to concatenate longer string
After my post yesterday on the performance implications of concatenating long strings with the + operator and the CONCAT function, today I am following up… Read More »Performance: Faster way to concatenate longer string
Performance: String Concatenation in SQL Server
String Concatenation SQL Server is one of these things that might be sound until you try to concate longer strings. That is where it gets… Read More »Performance: String Concatenation in SQL Server
Checking job history log size with TSQL
One of the important settings on SQL Server is the job history log size and the maximum rows per job. Without these set accurately you… Read More »Checking job history log size with TSQL
TSQL Query to find the user the SQL services run as
Occasionally I need to look up what user the SQL Server services are running as, and when this happens, you can either run a quick… Read More »TSQL Query to find the user the SQL services run as
How many files are in your SQL Error log directory?
I was investigating a slow sever recently and discovered almost a million files in the sql server error log directory. This contained job history and… Read More »How many files are in your SQL Error log directory?
XML and JSON making simple changes
As part of the XML and JSON month of blog posts, this post is going to cover how to make changes to XML and JSON… Read More »XML and JSON making simple changes
Iterating over JSON and XML values
One handy thing when working with JSON or XML is to take part of the data and represent it as tabular data, since everything in… Read More »Iterating over JSON and XML values