dbantics.blogspot.com
DB Antics: August 2009
http://dbantics.blogspot.com/2009_08_01_archive.html
Ideas expressed in this blog are of mine alone. Solutions or technical content are not guaranteed to be flawless. Bouquets and brickbats are welcome with open mindedness. Thursday, August 13, 2009. Scheduling Backups in SQL Server 2005/2008 Express Edition. The steps I performed were:. Write a stored procedure which would create a backup. Write T-SQL code to execute the stored procedure and put it in a. Write a batch file to call the. Schedule the batch file using the Windows scheduler. Share this post :.
dbantics.blogspot.com
DB Antics: April 2009
http://dbantics.blogspot.com/2009_04_01_archive.html
Ideas expressed in this blog are of mine alone. Solutions or technical content are not guaranteed to be flawless. Bouquets and brickbats are welcome with open mindedness. Thursday, April 09, 2009. Slipstreaming SQL Server 2008 SP1. I just tried creating my own slipstreamed SQL Server 2008 with SP1. Drop ( following these steps. Coupling in the latest version of Books Online. Links to this post. Friday, April 03, 2009. To get Certified, or Not to get Certified. See, there's one thing that we Sri Lankans l...
dbantics.blogspot.com
DB Antics: Database Mail vs. McAfee VirusScan Enterprise
http://dbantics.blogspot.com/2009/10/database-mail-vs-mcafee-virusscan.html
Ideas expressed in this blog are of mine alone. Solutions or technical content are not guaranteed to be flawless. Bouquets and brickbats are welcome with open mindedness. Thursday, October 08, 2009. Database Mail vs. McAfee VirusScan Enterprise. SQL Server Database Mail a mass mailing worm? Well, you can turn it into one! Just uncheck the ‘Block’ for preventing mass mailing worms from sending mail. Under the Anti-virus Standard Protection. Category, and all shall work well. Share this post :. Madhawa Lea...
dbantics.blogspot.com
DB Antics: Splitting Delimited Strings
http://dbantics.blogspot.com/2009/11/splitting-delimited-strings.html
Ideas expressed in this blog are of mine alone. Solutions or technical content are not guaranteed to be flawless. Bouquets and brickbats are welcome with open mindedness. Wednesday, November 04, 2009. Return empty table if no string to split is supplied. ISNULL(LTRIM(RTRIM(@StringToSplit) , '. Return table populated with complete string to split if no delimeter is supplied. ISNULL(LTRIM(RTRIM(@Delimiter) , '. Iterate through string to split using delimiter, then return populated table. Or maybe like this:.
dbantics.blogspot.com
DB Antics: July 2009
http://dbantics.blogspot.com/2009_07_01_archive.html
Ideas expressed in this blog are of mine alone. Solutions or technical content are not guaranteed to be flawless. Bouquets and brickbats are welcome with open mindedness. Saturday, July 11, 2009. Unpivot Transformation with Multiple Destination Columns. Consider this scenario. A simple. Table (which I shall call. Needs to be transformed into the following. Table (which I shall call. Configuring the Unpivot transformation for this would be quite simple, and would look like this:. Whereas, for the Price de...
dbantics.blogspot.com
DB Antics: Unpivot Transformation with Multiple Destination Columns
http://dbantics.blogspot.com/2009/07/unpivot-transformation-with-multiple.html
Ideas expressed in this blog are of mine alone. Solutions or technical content are not guaranteed to be flawless. Bouquets and brickbats are welcome with open mindedness. Saturday, July 11, 2009. Unpivot Transformation with Multiple Destination Columns. Consider this scenario. A simple. Table (which I shall call. Needs to be transformed into the following. Table (which I shall call. Configuring the Unpivot transformation for this would be quite simple, and would look like this:. Whereas, for the Price de...
dbantics.blogspot.com
DB Antics: MVP Open Day 2010, Post #1
http://dbantics.blogspot.com/2010/01/mvp-open-day-2010-post-1.html
Ideas expressed in this blog are of mine alone. Solutions or technical content are not guaranteed to be flawless. Bouquets and brickbats are welcome with open mindedness. Thursday, January 21, 2010. MVP Open Day 2010, Post #1. We are up at the Ista Hotel. Very beautiful place. Cool pool. Very friendly people. And today was our first day at the Microsoft IDC (India Development Center) – Lots of interesting stuff were/are created here, including parts of my favorite Windows yet and parts of SQL Server.
dbantics.blogspot.com
DB Antics: September 2009
http://dbantics.blogspot.com/2009_09_01_archive.html
Ideas expressed in this blog are of mine alone. Solutions or technical content are not guaranteed to be flawless. Bouquets and brickbats are welcome with open mindedness. Saturday, September 26, 2009. Database Mail vs. McAfee VirusScan Enterprise. SQL Server Database Mail a mass mailing worm? Well, you can turn it into one! Just uncheck the ‘Block’ for preventing mass mailing worms from sending mail. Under the Anti-virus Standard Protection. Category, and all shall work well. Share this post :. SSDT 2012...
dbantics.blogspot.com
DB Antics: October 2009
http://dbantics.blogspot.com/2009_10_01_archive.html
Ideas expressed in this blog are of mine alone. Solutions or technical content are not guaranteed to be flawless. Bouquets and brickbats are welcome with open mindedness. Thursday, October 08, 2009. Database Mail vs. McAfee VirusScan Enterprise. SQL Server Database Mail a mass mailing worm? Well, you can turn it into one! Just uncheck the ‘Block’ for preventing mass mailing worms from sending mail. Under the Anti-virus Standard Protection. Category, and all shall work well. Share this post :. SSDT 2012 D...
SOCIAL ENGAGEMENT