|
|
-
|
|
This post is inspired by a question in MSDN forum about disabling certain rendering formats when setting up SSRS subscriptions. This can be achieved by changing the SSRS configuration file as explained below. I never had a real-world scenario where I n...
|
|
-
|
|
FILESTREAM data can be accessed by TSQL as well as through the Win32/Managed APIs. Accessing FILESTREAM data using TSQL is not recommended for a number of reasons such as the inability to stream data when reading or writing through TSQL. The recommended...
|
|
-
|
|
This post is triggered by a question I recently saw in the BR Forum asking ideas for merging two XML documents. I thought of adding another installment to the XQuery Labs series to explain how this can be done from TSQL when required. The examples giv...
|
|
-
|
|
I have been helping a few people to migrate their blogs from blogger.com to beyondrelational.com. As part of this, I had to deal with the XML export file generated by blogger.com which contains information of all the posts, comments etc. I wrote a...
|
|
-
|
|
This post is inspired by a question asked in my blog this morning, about handling file-not-found errors from an SSIS package. A typical use case is as follows. An SSIS package is scheduled to run at every X minutes which processes files coming into a fo...
|
|
-
|
|
This is a follow-up post to my previous blog post on Generating scripts for schema and data. While the method we discussed in the previous post was very much standard, in this post we will examine a few not-so-common tricks that may be helpful in some s...
|
|
-
|
|
Recently a friend asked me steps/instructions to scripting schema and data of tables from a SQL Server database. I thought of writing a post and sharing the link rather than writing the process in an email, because I think this may benefit more people. ...
|
|
-
|
|
Monitoring the size of data files and available disk space on each of the drives (where the data files are placed), is one of the key activities of every database administrator. Depending upon the environment and requirements, people rely on different m...
|
|
-
|
|
This post is inspired by a question raised by a reader in the What is New in SQL Server 2012 section where I posted a note that the system stored procedure sp_dboption is not available in SQL Server 2012 anymore. Books online says the recommended altern...
|
|
-
|
|
This post is inspired by a question I saw in the forum this morning. The requirement is to be able to read the attributes belonging to a particular namespace. I thought of writing an XQuery lab to explain this. Here is the sample XML we have for this la...
|
|