Browse by Tags -

Browse by Tags

Ibmdadb2.1 provider is not registered on the local machine – the quick solution

The last couple of days I have been working with IBM connectivity. We use standard IBM components to bridge SQL Server SSIS and DB2. The component has been working 100% in all but one environment. So, everything is installed and seems to be configured correctly. The package is installed and every possible...

Posted to Mikael Sand - Trying to be different (Weblog) by Mikael Sand on Wed, Aug 24 2011
SQL Server Trace Flags - why and how to use them

Trace flags are very powerful settings that allow you to customize SQL Server behaviour. Most of the trace flags are undocumented in Books Online and there does not exist any official list of them. Some have been mentioned in Knowledge Base articles and presentation from Microsoft employees making them...

Posted to Johan Åhlén (Weblog) by jahlen on Sat, Dec 18 2010
SQLug.se challenge 2010 - the Swedish national championship for SQL Server developers

The Swedish national championship for SQL Server developers, SQLug.se challenge 2010 , is now finished. The competition has been running on the Swedish SQL Server User Group's website, but I publish the competition problem also on my blog in case you want to test your skills on it! The problem comes...

Posted to Johan Åhlén (Weblog) by jahlen on Mon, Dec 6 2010
SQL Azure - why use it and what makes it different from SQL Server?

I've so far not seen any article on why anyone should use SQL Azure so I thought it is time someone writes about that. This article is an introduction to why you might be interested in a cloud database and a summary of the differences compared to "ordinary" SQL Server. Finally I've...

Posted to Johan Åhlén (Weblog) by jahlen on Tue, Nov 23 2010
Search all SPs for a string

Ever asked this question: “I wonder if we access this table from any stored procedures?”. Well here is how to find out: SELECT distinct so.name, so.xtype FROM syscomments sc INNER JOIN sysobjects so ON sc.id=so.id WHERE sc.TEXT LIKE '%TABLE/COLUMN/string%' Nice! So now you can search all the...

Posted to Mikael Sand - Trying to be different (Weblog) by Mikael Sand on Tue, Nov 16 2010
Minesweeper in T-SQL

Who said that coding T-SQL should not be fun? Minesweeper is a real old classic (that's still being shipped with Windows). Truly creative of Auke Teeninga to implement Minesweeper in T-SQL... Keep on playing!

Posted to Johan Åhlén (Weblog) by jahlen on Sun, Sep 5 2010
SQL Azure new user interface - Project Houston

"Project Houston" is the new user interface for SQL Azure. If you have tried SQL Azure you know that the user interface on the web portal is very brief. You can't do almost anything from there (except create new database and setup security). To do anything with your SQL Azure database you...

Posted to Johan Åhlén (Weblog) by jahlen on Thu, Sep 2 2010
Try your SQL optimizing skills and win great honor

As winner of the previous round, I’ve been given the honor to write the problem for Phil Factor Speed Phreak Challenge #6. This problem is from the real world (algorithmic trading) and the sample data is real. The challenge is to reproduce highest buy and lowest sell prices from data captured from a...

Posted to Johan Åhlén (Weblog) by jahlen on Mon, Aug 16 2010
Exploring SQL Server under the hood using undocumented DBCC commands

Have you ever wanted to see the details on how data is organised in a SQL Server database? Exactly how tables, indexes, blogs, etc are stored. How SQL Server can find a specific row in a table. This is possible through two undocumented DBCC commands: DBCC IND and DBCC PAGE. Here's a description of...

Posted to Johan Åhlén (Weblog) by jahlen on Sun, Aug 15 2010
My StreamInsight samples have been moved

I've decided to move my samples to the "official" StreamInsight sample site on Codeplex, http://streaminsight.codeplex.com . The advantage is that there they will be co-located with other useful StreamInsight samples. My currently published samples are: Twitter input adapter Yahoo Finance...

Posted to Johan Åhlén (Weblog) by jahlen on Sun, Jun 27 2010

Page 1 of 2 (20 items) 1 2 Next >