...

Learn to dynamically backup all of your databases using an ssis package....

So to start, I just want to let you know that I will be posting here from time to time, but at my website, www.unglesbee.com/wordpress, often. If you like the article, check out my blog. Also, the attachments are going to be at my site only. Most DBA’...

...

...

How do you want the dates? Do you want datetime format or varchar with the date format like what you show in the expected results?

SQL Server 2012 enhanced the `EXECUTE` statement with an additional clause `WITH RESULT SETS` which allows you to convert/alter the columns and data types of the results produced by the `EXECUTE` statement. Assume that your stored procedure returns ...

In SQL Server 2008, We have a feature to select multiple lines with specific characters. In SQL Server 2012, we can append the same text to multiple lines. Below images will give the clear picture to understand this feature. Some times we need to ad...

In SQL Server 2008, We have a feature to select multiple lines with specific characters. In SQL Server 2012, we can append the same text to multiple lines. Below images will give the clear picture to understand this feature. Some times we need to ad...

In SQL Server 2008, We have a feature to select multiple lines with specific characters. In SQL Server 2012, we can append the same text to multiple lines. Below images will give the clear picture to understand this feature. Some times we need to ad...