|
|
-
|
|
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...
|
|
-
|
|
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. ...
|
|
-
|
|
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...
|
|
-
|
|
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 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...
|
|
-
|
|
I found this question in this SSC forum thread requesting help to shape the XML document. Here is the input XML document.
Jhon
Luka
1
2
The expected output is as follows.
Jhon
Luka
1
2
This type of formatting can be achieved through a......
|
|
-
|
|
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...
|
|
-
|
|
SQL Server Wait Types are important factors to consider while analyzing performance problems of SQL Server databases. If you notice a particular wait type is occurring too often or for too long, it indicates a problem in most cases. There are several dozens of different wait types and it is quite i......
|
|
-
|
|
I have done several domain transfers from one registrar to another, however, never did an account change. I wanted to transfer a domain from my personal account to beyondrelational.com account at Godaddy and was trying to do a domain transfer (whooops!)...
|
|
-
|
|
Pinal Dave is an inspiration for a large number of SQL Server professionals all over the world. He is a great teacher who knows how to explain any complex stuff in very simple words and examples that everyone understands. That is the reason why his blog is considered to be one of the best source of ......
|
|