January 2005 - Posts

Virtual Server with dual screens

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Virtual Server with dual screens
The new RSS feed is here

I am fortunate to have a new laptop that has supports dual screens. What is nice is to have a dev environment in one screen and use the other for word, outlook etc.

What would be nice would be for the virtual server console, when in full screen mode, to only occupy one screen and leave the other screen as normal. Unfortunately running in full screen does only fill one monitor but it also blanks the other monitor to your wallpaper :(

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Virtual Server with dual screens

posted Monday, January 10, 2005 6:31 PM by SimonSabin with 1 Comments

Dynamic SQL Good articles

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Dynamic SQL Good articles
The new RSS feed is here

Here is some info I have posted elsewhere but thought I should repost here,

Dynamic SQL (very good article)

http://www.sommarskog.se/dyn-search.html

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Dynamic SQL Good articles

posted Thursday, January 20, 2005 6:44 PM by SimonSabin with 0 Comments

Screen Clipping

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Screen Clipping
The new RSS feed is here

So you've found a bug and you need a screen dump, we've all used the print screen to capture the screen of the window. Then used word to print the picture. How often have you

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Screen Clipping

posted Thursday, January 20, 2005 6:10 PM by SimonSabin with 0 Comments

SQL Mobile

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SQL Mobile
The new RSS feed is here

http://www.microsoft.com/downloads/details.aspx?FamilyID=0a6174a4-c009-4768-8284-698c32ec84e3&DisplayLang=en

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Mobile

posted Thursday, January 20, 2005 5:53 PM by SimonSabin with 0 Comments

SQL Server User Defined Function performance follow up

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SQL Server User Defined Function performance follow up
The new RSS feed is here

http://www.luschny.de/math/factorial/SrcCsharp/index.html

http://sqljunkies.com/WebLog/amachanic/articles/PatternSplitString.aspx

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Server User Defined Function performance follow up

posted Thursday, January 20, 2005 3:32 AM by SimonSabin with 0 Comments

Ultimate RAID Performance

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Ultimate RAID Performance
The new RSS feed is here

Well you get the performance but not quite the capacity for SQL Server databases

http://ohlssonvox.8k.com/fdd_raid.htm

Very amusing.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Ultimate RAID Performance

posted Thursday, January 20, 2005 3:23 AM by SimonSabin with 0 Comments

User Defined Function performance comparison

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/User Defined Function performance comparison
The new RSS feed is here

For some time now I wanted a basic example that showed the impact of using functions (UDFs), I was looking at SQLServerCentral and saw a new piece on an LPAD function

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/User Defined Function performance comparison

posted Monday, January 17, 2005 10:43 PM by SimonSabin with 4 Comments

Auto Recovery in SQL Workbench???

Whats auto recovery, seemed to crash work bench when it kicked in

posted Sunday, January 16, 2005 8:46 PM by SimonSabin with 0 Comments

Virtual Server performance figures

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Virtual Server performance figures
The new RSS feed is here

I am trying to put together some stats on difference between different ways of doing something in SQL 2005, TSQL, SQLCLR etc and find some interesting results.

If the host machine (the one running Virtual Server) is doing something then the guest machine (i.e. the virtual server) doesn't get all its CPU cycles this therefore throws out any results. Occasionally I have had results that seem to defy time.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Virtual Server performance figures

posted Monday, January 17, 2005 12:35 AM by SimonSabin with 0 Comments

Itzik overview of TSQL in Yukon

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Itzik overview of TSQL in Yukon
The new RSS feed is here

Great overview of TSQL enhancements in SQL 2005

http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsql90/html/sql_05TSQLEnhance.asp

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Itzik overview of TSQL in Yukon

posted Monday, January 10, 2005 7:26 PM by SimonSabin with 0 Comments

SQL Server 2000 SP4 Beta

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SQL Server 2000 SP4 Beta
The new RSS feed is here

You can enrole for SP4 beta at http://support.microsoft.com/kb/290211/EN-US/

230+ is a lot of fixes

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Server 2000 SP4 Beta

posted Monday, January 10, 2005 6:58 PM by SimonSabin with 0 Comments

Virtual Server with dual screens

I am fortunate to have a new laptop that has supports dual screens. What is nice is to have a dev environment in one screen and use the other for word, outlook etc.

What would be nice would be for the virtual server console, when in full screen mode, to only occupy one screen and leave the other screen as normal. Unfortunately running in full screen does only fill one monitor but it also blanks the other monitor to your wallpaper :(

If anyones got a work around would love to know it.

Interestingly the remote desktop client does go full screen on just one of the 2 monitors.

Hope that the virtual server client adopts this in the future.

 

posted Monday, January 10, 2005 1:31 PM by SimonSabin with 1 Comments