Lately I've been doing some image processing work using the most amazing AForge.NET open source library written in C#.
This library contains a whole bunch of useful filters you can play with but unfortunately it doesn't contain any filter for segmentation.
Read more →
I've written an article here on SQL Team about Integrating Profiler and PerfMon Log Files.
Troubleshooting SQL Server requires the use of both PerfMon (Performance/System Monitor) and SQL Trace files created by SQL Profiler or directly by SQL Server trace.
Read more →
Probably everyone is familiar with the Count(*) function in SQL Server.
But there seems to be a great deal of confusion amongst youngsters (SQL wise) about how all its possible options work.
Read more →
I've written an article here on SQL Team about Application Locks in SQL Server 2005
Application locks aren't a well known area of locking in SQL Server, but they can be very useful for special scenarios.
Read more →
This is a very "serious" talk presented by legendary Israeli investor and community-builder Yossi Vardi. It talks about the dangers of blogging especially for males.
Direct video link here.
Read more →
In 2007 I've worked a lot with NUnitForms. It contains all major controls testers and you can easily create
your own ones for e.g. a Data Grid or a 3rd party control.
Read more →
I've written an article here on SQL Team Database Backups in SQL Server. It's a first of two articles on backups and backup strategy Backing up a database is one of the most important things you need to do when having a database driven application.
Read more →
it's my opinion that today we unfortunately live in a world that requires some kind of harder problem solving skills from maybe 20% of the population. And I'm being very very generous.
Read more →
I've written an article here on SQL Team about locking in SQL Server. It's an introductory article that shows lock modes, lock granularity and lock compatibility matrix
and it will be followed by a few more advanced ones on the topic of locking.
Read more →
I've released a new version of the add-in.
Most of the reported bugs are fixed and I've added two new main functionalities:
- Search Results in Grid Mode and through Execution Plans - Generate Insert statements for a single table, the whole database or current resultsets (yes all of them) in grids
Read more →
If you're a .Net developer aliases should be very familiar to you.
if they're not here is a reminder:
using MyAlias = This.Is.My.Full.Namespace.MyClass; MyAlias m = new MyAlias(); // MyAlias is of course of type MyClass Well it seems SQL Server 2005 added a similar functionality to T-SQL.
Read more →
Update: New Stuff from the latest update will be in RED.
This list will grow as I find new tools. So if you know of some not on this list do post them in the comments.
Read more →
Today I feel a bit evil minded so I thought I'd share this little prank-friendly function.
If you put this into a .Net Assembly you import to SQL Server as a function or a stored procedure
Read more →
If you've ever worked with SQL Server profiler then you're familiar with the EventClass column in the trace. It tells you what event is being monitored for each row. When you save this trace to a table you can see that the EventClass no longer has a description but an ID.
Read more →
We're having a contest over at SqlTeam.com. Go take a look it might be worth your while.
All you have to do is have a post in the forums. The more posts you have the better the chance you have of winning.
Read more →
UPDATE: After i've been proven wrong in the comments below I have to say this:
Go take a read of this article to see how circular references are really handled.
Read more →
Until recently i've been sure that there are 2 date formats that are completly locale insensitive.
Those 2 i thought were locale insensitive are yyyy-mm-dd HH:mm:ss.fff and yyyymmdd HH:mm:ss.fff.
And i was proven wrong a few days ago!
Read more →
I can't believe these properties aren't already natively implemented. Come on Microsoft... we do live in the year 2007 you know!!
I know that you can do this using P/Invoke and SendMessage but i wanted a nice managed way of finding the current line and column of the Caret position in a multiline TextBox.
Read more →
Often you can see a request made by people to help them separate data in thier character based columns to numeric and non-numeric part.
Most often the answer they get is very simple: Use IsNumeric built in function.
Read more →
First let's look at the difference assuming we want to delete the whole table like truncate does.
Truncate:
- deallocates the data pages in a table and only this deallocation is stored in transaction log
Read more →