Following on from Leo Pasta’s lead, I’ve created two stored procedures to make printing out a message without waiting for a batch or transaction to completed. InstantPrint and InstantPrintTime
SQL SNIPPET: Instant Print a Message from within a Batch
You are browsing archives for
Year: 2007
How To: Configure a For Loop Container
Start in the package Control Flow, with no object selected (Press ESC in the main window). Right click the background in the package, and select Variables Add a variable called LoopIteration with the Int32 data type in the package. Add a For Loop Container to the package Edit the For Loop Container by double-clicking it, […]
Answer: How do you create a byte with the value of 00000001 in SQL Server?
My team mate Pi asked me today: how do you create a byte with the value 00000001 in SQL Server? The answer is to create an integer representation of the byte’s value, and cast it to binary. SELECT CAST(CAST(1 AS TINYINT) AS BINARY(1)) The output in Management Studio is: 0x01 (Management Studio outputs binary fields […]
Hey Yo! SQLCMD may truncate your XML!
While trying to use SQLCMD to produce an app.config file, I encountered problems with the output being truncated. The script was similar to: DECLARE @appconfig XML SET @appconfig = ‘<configuration></configuration>’ … Insert configuration nodes — Output the config SELECT @appconfig as ApplicationConfiguration The default options for SQLCMD produced output like: ApplicationConfiguration ————————- <configuration><connecti (the value […]
Working Remotely: Disable Effects for a Better Working Experience
Working from home using a remote desktop has turned out to be surprisingly responsive. There’s little to no lag, and I can still do most things (except use some windows shortcuts). My current gripe is that Menus take a while to display because of fancy fade-ins and smooth expansion. It all looks nice when you […]
Julian!? Where are you?
Well I’ve definitely been "missing" on my blog lately. Between work commitments, a long daily commute, and personal projects, I’ve had no time to post much content on my website. As of last week, I started working some days remotely; from home. Its been quiet a good change, and now that I have less distractions: […]
How to Connect to a SQL Server Compact Edition Database with Management Studio
Open a new connection by choosing File menu -> Connect Object Explorer in SQL Server Management Studio. Change the Server Type to SQL Server Compact Edition. For Database file: put the full path to an existing SQL Server Compact Edition .sdf file; click the drop-down button, and select New Database or Browse to locate a […]
Permanently Redirecting Domain Pages with Geeklog
I have a number of domain names and previously blogged on how to make Geeklog work on all of them. I�ve decided now to concentrate on one domain name: julian-kuiters.id.au There is already a number of links to my other domains, so I needed to configure Geeklog to redirect people to the new domain. I […]
What I’m Reading 18 April 2007
International Considerations for Database and Database Engine Applications http://msdn2.microsoft.com/en-us/library/ms190245.aspx Strategies for Partitioning Relation Data Warehouses in SQL Server http://www.microsoft.com/technet/prodtechnol/sql/2005/spdw.mspx Physical Database Storage Design http://www.microsoft.com/technet/prodtechnol/sql/2005/physdbstor.mspx International Considerations for Notification Services http://msdn2.microsoft.com/en-us/library/ms172557.aspx How MSN Messenger and MSN Hotmail scales with SQL Server 2005 http://www.microsoft.com/technet/prodtechnol/sql/2005/scddrtng.mspx Scaling out SQL Server 2005 http://msdn2.microsoft.com/en-us/library/aa479364.aspx Database Mirroring FAQ http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirfaq.mspx Database Mirroring http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx […]
Updated SQL Server 2005 Books Online (help) Available Now (Feb 2007)
As SQL Server 2005 continues to grow and change, the Books Online / help files are also updated. Keep your help files up-to-date by downloading the latest copy. Download SQL Server 2005 Books Online Feb 2007 version.