RDP - session hanging

In some cases on some systems I have experienced that my RDP session hangs, and the only thing I can see when logging in on the server is a black screen.

When this happens I have 2 options:

1. Complain, complain and complain
2. Call some support fellow, or disturb a colleague who might happen to have access to the same server, and let him kill my RDP session

But this was until today, when I thought to myself: Myself, there must be another way, and there is. Using the commands: quser.exe /server:[servername] from a different server actually tells you which users logged on to the target server. Read out the session-id from the user you want to "kill" and use: logout [session-id] /server:[servername]. This will do the trick.

Thanks Dan Rigsby for sharing this [http://www.danrigsby.com/blog/index.php/2008/08/26/remotely-log-off-remote-desktop-users/]

Are your SQL Server Queries slow?

Run this query to see if any of your indexes needs a rebuild or reorganize:
(linked back from this site: http://weblogs.asp.net/okloeten/archive/2009/01/05/6819737.aspx)

SELECT 'ALTER INDEX [' + ix.name + '] ON [' + s.name + '].[' + t.name + '] ' +
       CASE WHEN ps.avg_fragmentation_in_percent > 40 THEN 'REBUILD' ELSE 'REORGANIZE' END +
       CASE WHEN pc.partition_count > 1 THEN ' PARTITION = ' + cast(ps.partition_number as nvarchar(max)) ELSE '' END
FROM   sys.indexes AS ix INNER JOIN sys.tables t
           ON t.object_id = ix.object_id
       INNER JOIN sys.schemas s
           ON t.schema_id = s.schema_id
       INNER JOIN (SELECT object_id, index_id, avg_fragmentation_in_percent, partition_number
                   FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL)) ps
           ON t.object_id = ps.object_id AND ix.index_id = ps.index_id
       INNER JOIN (SELECT object_id, index_id, COUNT(DISTINCT partition_number) AS partition_count
                   FROM sys.partitions
                   GROUP BY object_id, index_id) pc
           ON t.object_id = pc.object_id AND ix.index_id = pc.index_id
WHERE  ps.avg_fragmentation_in_percent > 10 AND
       ix.name IS NOT NULL

SQL Server Bulk Insert

How to insert bulk data into a SQL Server Table from a CSV file:

BULK
INSERT TugLookup
FROM 'c:\temp\tuglookup.csv'
WITH
(
FIELDTERMINATOR = ';',
ROWTERMINATOR = '\n'
)
GO
--Check the content of the table.
SELECT *
FROM TugLookup
GO

Notes on BizTalk 2010

Some notes around installing and configuration of BizTalk 2010

The installation was done on a virtualized Win 2008R2. Follow this document from Microsoft:

http://www.microsoft.com/en-us/download/details.aspx?id=11503

The installation consists of following components:

- SQL Server 2008R2 with SSAS,SSRS and SSIS installed. But be sure to read the installation guide

- Visual Studio 2010 (download the trial version from Microsoft)

- Configuration of the SQL Server (deactivate shared memory on the instance)

- Installation of BizTalk 2010

- Configuration of BizTalk 2010

After this, launch the Administration application.

Tutorial for developing your first BizTalk solution:

http://msdn.microsoft.com/en-us/library/aa560270

Create multiple scheduled tasks across n-servers

Needed to create the same scheduled task on several servers. Using a bit of Powershell made the task a bit easier. Below functions can be used to create, delete and view scheduled tasks on a specific server:

Function Get-ScheduledTask
 {
 param([string]$ComputerName = "localhost")
 Write-Host "Computer: $ComputerName"
 $Command = "schtasks.exe /query /s $ComputerName"
 Invoke-Expression $Command
 Clear-Variable Command -ErrorAction SilentlyContinue
 Write-Host "`n"
 }
 
# EXAMPLE: Get-ScheduledTask -ComputerName Server01
 
Function Remove-ScheduledTask
 {
 param(
 [string]$ComputerName = "localhost",
 [string]$TaskName = "blank"
 )
 If ((Get-ScheduledTask -ComputerName $ComputerName) -match $TaskName)
  {
  If ((Read-Host "Are you sure you want to remove task $TaskName from $ComputerName(y/n)") -eq "y")
   {
   $Command = "schtasks.exe /delete /s $ComputerName /tn $TaskName /F"
   Invoke-Expression $Command
   Clear-Variable Command -ErrorAction SilentlyContinue
   }
  }
 Else
  {
  Write-Warning "Task $TaskName not found on $ComputerName"
  }
 }
 
# EXAMPLE: Remove-ScheduledTask -ComputerName Server01 -TaskName MyTask
 
Function Create-ScheduledTask
 {
 param(
 [string]$ComputerName = "localhost",
 [string]$RunAsUser = "System",
 [string]$TaskName = "MyTask",
 [string]$TaskRun = '"C:\Program Files\Scripts\Script.vbs"',
 [string]$Schedule = "Monthly",
 [string]$Modifier = "second",
 [string]$Days = "SUN",
 [string]$Months = '"MAR,JUN,SEP,DEC"',
 [string]$StartTime = "13:00",
 [string]$EndTime = "17:00",
 [string]$Interval = "60" 
 )
 Write-Host "Computer: $ComputerName"
 $Command = "schtasks.exe /create /s $ComputerName /ru $RunAsUser /tn $TaskName /tr $TaskRun /sc $Schedule /mo $Modifier /d $Days /m $Months /st $StartTime /et $EndTime /ri $Interval /F"
 Invoke-Expression $Command
 Clear-Variable Command -ErrorAction SilentlyContinue
 Write-Host "`n"
 }
 
# EXAMPLE: Create-ScheduledTask -ComputerName MyServer -TaskName MyTask02 -TaskRun "D:\scripts\script2.vbs"

Borrowed from: this link 

Doing the BI Certification with Koenig-Solutions in Dubai - Part I

Going to Dubai from Copenhagen is quite easy. I found a flight with Qatar Airways. A quick stop in Doha before arrival in Dubai (1 hour) was OK. Landed in Dubai at 2.10am local time and was kind of tired. Unfortunately many people had choosen to go to Dubai, so getting through customs took about an hour. From here it should be painless, but my suitcase was apparently forgotten in Doha. Luckily many flights go from Doha to Dubai so only 30 minutes of waiting and of to the Koenig Apartment. But now the local time was 4.15am. A quick call to Koenig caretakers to tell them I was coming resultet in a quick welcome and showing to my flat and room. A nice big flat with 2 rooms and 2 bedrooms. Breakfast was at 8am, so not much time to sleep.

A quick shower and rushing to the breakfast which includes eggs, toast, fresh fruit, juice and several types of cerials. Even the ones my kids are not allowed to eat. Then off to the Koenig Office for starting the course, using the Koenig Bus which transports all people, including instructors, to the office. A nice blend of indian, oman, american and danish blend in that bus. At the office the manager at the office welcomed me, informed about the reimbursement of taxi trip and daily cost for lunch. The lunch at the office is done at "food court" where several fast-food stores are present, including KFC and Subway, but also indian and italian style food. Pretty ok selection. Back to what I came for, the SQL 2008 BI course. The instructor - Prakash - introduced to the course, with a overview of the different elements in the course and then we startet. Being the only one on the team is pretty ok. The instruction is a mix of using the traditional (...veryyyyy traditional) Microsoft stuff, with slides and some pretty boring lab exercises. But Prakash also uses a simple whiteboard for introducting the subjects and explaning what the comming module would contain. And this is actually ok. At least when the lab exercies are spiced up with improvised exercises where things not goes as the theory says. And most often, this is where the potential and skills of the instructor becomes visible. But so far its going well. At 13 o'clock it's time for a 1 hour lunch break, which seams like appropriate. Getting some lunch and some rest in the sun is nice. At 17 o'clock the instruction is done, and around 17:15 the bus takes us back to the apartment.

So to sum it up, the experience so far has been positive. The course is going well, so far almost covered the SSAS area in 2 days, been to the pool twice, ran 5 kilometers and had some interesting conversations with the two caretakers.

Doing the BI Certification with Koenig-Solutions in Dubai - background

This blogentry is something complete different compared to the little bit of other stuff I've put on the blog. This is about my journey to Dubai for a 12 fast-track course on MS SQL 2008 Business Intelligence. For some time ago I was supposed to attend a course back in Denmark over a couple of months, with a weekly meetup with instructors and fellow students. The course never got off the air and was canceled. This was back in late 2009. Suddenly a opportunity came up for trying to go again, but this time I had heard about Koenig-Solutions, an Indian based course supplier. After a quick check I signed up for a 12 days fast-track course, with base out of Dubai. What this also meant was actually 14 days away from my family, including 3 small kids.

Signing up with Koenig-Solutions was inspired from this guy's blog-post who went to Goa for a course. Going to India is cheaper than going to Dubai, on the contrary Dubai is a shorter flight from Denmark, and no Visa or vaccines is required. Dubai is of course also more western kind-of. So the sum of all is, that I booked 12 days in Dubai with MS SQL 2008 BI Maintain & Development, including 2 MS certifications. The booking and communication with Koenig before the trip has been good, with quick answers on all kinds of questions. Even a question just before scheduled departure because of illness to a family member was handled very well. It turned out that up to start of the course start you can actually cancel and get a almost fully refund. Try that with a european company.

All for now, next blog post will be about the first couple of days in Dubai.