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

Stories recently tagged with 'SQLServer' Subscribe to this feed
3
kicks
submitted by spirit1 1 day, 8 hours 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: 3
tags: , , , | tag it

1
kicks
submitted by spirit1 5 days, 8 hours 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: 9
tags: , , | tag it

3
kicks
submitted by thaisold 7 days, 10 hours ago

sqlblog.net — Shows you the steps you need to take to setup an alias for a sql server instance on windows server (or desktop). read more...

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

24
kicks
published 7 days, 19 hours ago, submitted by Jemm Jemm 8 days, 9 hours ago

blogs.msdn.com — "We were recently in a review where the ISV was using both SQL Server and MySQL. Of course working for Microsoft my first question was to ask why they had chosen to use MySQL." read more...

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

5
kicks
submitted by Marlonr 9 days, 9 hours ago

dbalink.wordpress.com — For some reasons, DBA’s need to rename their Databases. One of the reasons might be to comply to Best Practices Policy changes. Here we are going to rename our Database named “Bad_Ass_DB” into “Best_Practice_DB”. This is how Database renaming with TSQL is done in SQL Server 2005.... read more...

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

2
kicks
submitted by StatisticsIO 10 days, 3 hours ago

blog.jemm.net — Gotcha to watch out for with the SQL security update. read more...

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

1
kicks
submitted by Askeeto 11 days, 7 hours ago

foxtricks.blogspot.com — Using temp tables in Microsoft SQL Server is tricky when your databases don't follow the server collation. This post explains how to create temp tables while avoiding the use of explicit COLLATE statements in your TSQL code. read more...

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

2
kicks
submitted by 52coding 12 days, 5 hours ago

52coding.com — XML into SQL Server a number of ways, here one of three kinds: read more...

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

1
kicks
submitted by Marlonr 14 days, 8 hours ago

dbalink.wordpress.com — SSMS Tools PACK is an Add-In (Add-On) for Microsoft SQL Server Management Studio and Microsoft SQL Server Management Studio Express. read more...

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

1
kicks
submitted by wisemx wisemx 14 days, 22 hours ago

msdn2.microsoft.com — The Microsoft data platform is made up of a rich set of products and technologies for all types of data, from unstructured binary data on one end of the spectrum to highly structured online analytical processing (OLAP) cubes on the other. While these technologies address any application scenarios you may have, typically it involves an up-front investment of time and hardware resources before you are able to start coding your solution. read more...

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

24
kicks
published 14 days ago, submitted by justin_etheredge justin_etheredge 16 days, 3 hours ago

codethinked.com — Sure, SQL Server 2008 is getting ready to drop, but are you familiar with all of the new features that 2005 gave you? Or maybe you haven't used 2005, well, this is a good article to introduce to you several of the new features in SQL Server 2005. read more...

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

3
kicks
submitted by StatisticsIO 16 days, 21 hours ago

statisticsio.com — "Microsoft has told several large database shops to expect their final SQL Server 2008 bits this week. That means it's possible, in an ideal world, that the company will announce RTM (release to manufacturing) of the new database next week at the Microsoft Worldwide Partner Conference. (Microsoft is holding to its official "it'll ship in Q3" story.)" read more...

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

2
kicks
submitted by paul_houle 19 days, 4 hours ago

gen5.info — This article presents a simple stored procedure which makes it possible to delete a stored procedure in SQL Server without knowing it's name, an important tool when automating the maintainance of database schemas in Microsoft SQL Server read more...

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

3
kicks
submitted by croland 20 days, 15 hours ago

statisticsio.com — Good overview of the upcoming 71-432 SQL Server 2008 Implementation and Maintenance exam. With the constant stream of exams being pumped by Microsoft it's great to have an idea of what's coming down the pipeline. read more...

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

3
kicks
submitted by hwaheed 21 days, 19 hours ago

weblogs.asp.net — The article provide a breif introduction of new data compression feature in SQL Server 2008. read more...

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

3
kicks
submitted by crpietschmann crpietschmann 22 days, 20 hours ago

pietschsoft.com — The Community Coding Contest will run from July 1 through Sept. 30, 2008. The community will vote to decide the winners. The top 3 entries will each be awarded 1 MSDN Premium Subscription with Visual Studio Team Suite, and the 4th place entry will be awarded Windows Vista Ultimate SP1 and Visual Studio 2008 Professional. Here's an awesome chance to write some code and win some awesome prizes! I am also looking for sponsors to donate additional prizes to give away. read more...

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

 

Sponsored Link: www.carlist.ie

Search:

Ads via The Lounge