DotNetKick.com is an open-source project. Please report any bugs and let us know your great suggestions. Currently running svn revision 620 (rss)

Kick Spy!, Kick Zeitgeist and Kick Widgets

spirit1 Subscribe to this feed
spirit1
Profile Kicked Submitted Comments Tags Friends Kicked By Friends Submitted By Friends

Stories submitted by spirit1
2
kicks
I KILL-ed you! Now can I go for a coffee break while you die?
submitted by spirit1 28 days, 6 hours ago

weblogs.sqlteam.com — Find out how long it will take for a rollback to complete in SQL Server with the help of a little know feature of the KILL keyword. read more...

Add a comment add a comment | category: | Views: 11
tags: , , , | tag it

1
kicks
Different ways how to escape an XML string in C#
submitted by spirit1 1 month, 10 days ago

weblogs.sqlteam.com — XML encoding is necessary if you have to save XML text in an XML document. If you don't escape special chars the XML to insert will become a part of the original XML DOM and not a value of a node. Here are 4 ways of doing this that you may or may not know. read more...

Add a comment add a comment | category: | Views: 17
tags: , | tag it

3
kicks
Custom user configurable SQL Server Profiler events
submitted by spirit1 1 month, 15 days ago

weblogs.sqlteam.com — SQL Server Profiler is a well known tool for tracing different activity that happens between your server and the clients connected to it. But very few people know that you can have custom events and trace them in the SQL Server Profiler. read more...

Add a comment add a comment | category: | Views: 3
tags: , , , , | tag it

10
kicks
SSMS Tools PACK 1.1 - now with SSMS 2008 support
published 1 month, 18 days ago, submitted by spirit1 1 month, 25 days ago

weblogs.sqlteam.com — With this new version you can use it for SQL Server Management Studio 2008 and SQL Server Management Studio 2008 Express. Plus some extra features. read more...

Add a comment add a comment | category: | Views: 198
tags: , , , | tag it

3
kicks
Normalization for databases is like Dependency Injection for code
submitted by spirit1 2 months, 14 days ago

weblogs.sqlteam.com — Dependency Injection and Database Normalization are two entirely different concepts that strive to achieve the same thing. Ability to make quick and stable changes. read more...

Add a comment add a comment | category: | Views: 10
tags: , , | tag it

5
kicks
SQL Server 2005 Express Job Scheduling - Part 1
submitted by spirit1 3 months, 3 days ago

weblogs.sqlteam.com — SQL Server 2005 Express Job Scheduling with the help of Sql Server service broker and without 3rd party products. read more...

Add a comment add a comment | category: | Views: 32
tags: , , , | tag it

3
kicks
SQL Server 2005 temporary tables bug, feature or expected behavior?
submitted by spirit1 3 months, 9 days ago

weblogs.sqlteam.com — Some unexpected SQL Server behaviour around temporary tables that is good to know about. If it can be explained... read more...

Add a comment 1 comment | category: | Views: 14
tags: , , | tag it

3
kicks
Number one advice to recruiters from an IT guy
submitted by spirit1 4 months, 6 days ago

weblogs.sqlteam.com — Every recruiter should be aware of what not do to loose a candidate. read more...

Add a comment add a comment | category: | Views: 13
| tag it

5
kicks
Immediate deadlock notifications without changing existing code
submitted by spirit1 4 months, 13 days ago

weblogs.sqlteam.com — In my previous post about immediate deadlock notifications in SQL Server 2005 I've shown a way to use a try catch block to get the deadlock error. The con of this method, although it uses best practice for error handling in SQL Server 2005, is that you have to change existing code and it doesn't work for non stored procedure code. And that IS a pretty BIG con! So here's a solution to this con. read more...

Add a comment add a comment | category: | Views: 9
tags: , , , | tag it

2
kicks
SQL Server 2005 bug when using LIKE searches
submitted by spirit1 4 months, 17 days ago

weblogs.sqlteam.com — Here's a demo of a nice little bug in SQL Server 2005 when using LIKE comparisons for searching. What is so "nice" about it is that it only manifests itself if your search ends in number 9 followed by a wildcard when selecting only columns covered by a nonclustered index. read more...

Add a comment add a comment | category: | Views: 13
tags: , , | tag it

2
kicks
Serious Visual Studio 2008 install bug that can break your builds
submitted by spirit1 6 months, 2 days ago

weblogs.sqlteam.com — When Visual Studio 2008 installs you can run the VS 2008 command prompt. But beware if you have already have ( or ) in your PATH system environment variable. The prompt won't load properly and csc.exe and msbuild.exe won't work. Here's how you fix it. read more...

Add a comment add a comment | category: | Views: 9
tags: , | tag it

6
kicks
SQL Server 2005: Immediate Deadlock notifications
submitted by spirit1 6 months, 10 days ago

weblogs.sqlteam.com — Deadlocks can be a pain to debug since they're so rare and unpredictable. The problem lies in repeating them in your dev environment. That's why it's crucial to have as much information about them from the production environment as possible. This is one way of getting it immediatly when it happens, read more...

Add a comment add a comment | category: | Views: 20
tags: , , , , | tag it

13
kicks
Ease your SSMS experience: SSMS Tools PACK 1.0 is out!
published 6 months, 12 days ago, submitted by spirit1 6 months, 23 days ago

weblogs.sqlteam.com — A popular free add-in for SQL Server Management Studio (SSMS) is now in release version 1.0. With many new and improved features it speeds up your SSMS development. read more...

Add a comment add a comment | category: | Views: 248
tags: , , , , | tag it

14
kicks
SQL Server 2005: Get full information about transaction locks
published 6 months, 24 days ago, submitted by spirit1 7 months, 1 day ago

weblogs.sqlteam.com — Get information about what locks are being held by the transaction, what SPID owns the transaction, on which objects the locks are being held, what SQL statement caused the locks, etc... read more...

Add a comment add a comment | category: | Views: 18
tags: , , , | tag it

12
kicks
How SQL Server short-circuits WHERE condition evaluation
published 9 months, 4 days ago, submitted by spirit1 9 months, 6 days ago

weblogs.sqlteam.com — As a developer you must be aware that SQL Server does not do short-circuiting like it is done in other programming languages and there's nothing you can do to force it to. read more...

Add a comment add a comment | category: | Views: 4
tags: , , , , | tag it

4
kicks
Bruce Schneier Facts
submitted by spirit1 9 months, 15 days ago

weblogs.sqlteam.com — If you're a fan of security you have to be familiar with Bruce Schneier and his excellent blog. What I didn't know is that he also has a collection of facts like Chuck Norris! Just how cool is that??? read more...

Add a comment add a comment | category: | Views: 0
tags: | tag it

 

Sponsored Link: www.carlist.ie

Search:

Ads via The Lounge