Welcome to AspAdvice Sign in | Join | Help

Browse by Tags

All Tags » SQL   (RSS)

Did you know Red Gate gives SQL Log Rescue for free?

I thought I mention this, since these types of tools are rarely needed, but when they are, they are also seriously saving your ass. :-) SQL Log Rescue is basically undo tool which analyzes transaction logs of your SQL Server database and allows you to
Posted by joteke | 4 Comments
Filed under:

Preventing dynamic SQL when using dynamic WHERE clause

I see surprisingly often people using dynamic SQL when their need is to filter data with WHERE clause, with varying fields fields used. Say I have a table CREATE TABLE [dbo].[SAMPLETABLE]( [id] [int] IDENTITY(1,1) NOT NULL, [somenumber] [int] NOT NULL,
Posted by joteke | 0 Comments
Filed under:

Red Gate announces SQL Prompt 3.5

Here's from email I got, Dear Friends, I am very pleased to announce the release of SQL Prompt 3.5. This is a major new release and a recommended upgrade for all current SQL Prompt 3.0/3.1 users. New features include: - Visual Studio 2005 database
Posted by joteke | 0 Comments
Filed under:

Red Gate's SQL Compare 6

It's available as beta version at: http://www.red-gate.com/MessageBoard/viewtopic.php?t=4836 One of the coolest new features is better integration with source control systems, although not perfect yet (missing SCCI), but it allows you to create database
Posted by joteke | 0 Comments
Filed under:

teemukeiski.net running on Community Server 2.1

My web site http://teemukeiski.net is now up and running. There's basically 0 content right now <grin>, but I'm going to correct that relatively soon. I have new blog & forum running there, so feel free to check that out. And of course, you
Posted by joteke | 0 Comments
Filed under: , , , ,

On Forums: Turning XML elements to SQL resultset rows in SQL2005

Chris asked on forums a question about using SQL2005's XQuery features. He had XML like this <? xml version = ' 1.0 ' standalone = ' yes ' ?> < marketingContent > < accessoryItemsHeading > ACCESSORY ITEMS </ accessoryItemsHeading
Posted by joteke | 0 Comments
Filed under: , ,

Red Gate's SQL Prompt

Via Steve's post ( http://www.promptsql.com/ ) Red Gate has announced beta version of SQL Prompt, tool which enables Intellisense for SQL tools such as Query analyzer and SQL Management Studio. Not a bad one. Wow! Share this post: email it! | bookmark
Posted by joteke | 0 Comments
Filed under:

Red Gate's SQL Dependency Tracker 2.0 in beta

From: http://www.red-gate.com/messageboard/viewtopic.php?t=2083 Hello all, I'm pleased to announce that the beta version of SQL Dependency Tracker 2.0 is now available. This is a chance for everyone to take an early look at this new product we'll be releasing
Posted by joteke | 0 Comments
Filed under:

SQLEXPR.EXE vs SQLEXPR32.EXE

In case you've installed SQL Server Express and found out that there are two executables for installation (for example when installing SSE bundled with VS2005) SQLEXPR.EXE and .SQLEXPR32.EXE, you might have wondered what's the difference. From: http://msdn2.microsoft.com/en-us/library/ms143680
Posted by joteke | 1 Comments
Filed under: ,

Simple SQL stuff: Hierarchies in SQL Server

One of my favorite subjects, hierarchical data :-) I thought to blog that I posted a while ago on ASP.NET Forums about dealing with a self-joining table on SQL Server, when you'd want to iterate from child rows to the parent rows e.g locate parent(s)
Posted by joteke | 0 Comments
Filed under:

T-SQL Coding Standards

From Greg Robinson's blog post http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsqlpro04/html/sp04l9.asp Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!
Posted by joteke | 1 Comments
Filed under:

SQl Server 2005 Build Uninstall Wizard

You've probably seen web being full of those uninstall instructions for SQL2005 betas & CTPs in conjuction with VS2005. This comes late, but there is also uninstall wizard included in SQL2005. See following post for details http://blogs.msdn.com/astebner/archive/2005/06/14/429194.aspx
Posted by joteke | 0 Comments
Filed under: ,

Deployment of SQL2005 assembly in VS.NET 2005

I've been playing extensively with SQL2005 for the last few days with VS 2005 beta 2. I was suprised to find out that VS.NET 2005's SQL Server Project does not seem to support ALTER ASSEMBLY-type of deploying properly, or that's how I see it. Is this
Posted by joteke | 0 Comments
Filed under: ,