blogs.conchango.com

Browse by Tags

• Agile
• BI
• Business Intelligence
• Database Edition
• Database Unit Test
• Datadude
• Performance Point
• Spatial Data
• SQL
• SQL Server
• SQL Server 2005
• SQL Server 2008
• Team Edition for Database Professionals
• T-SQL

• Using a Bitmask - a practical example

  A colleague of mine asked for a simple example to get him up and running with the basics of bitmasking.  Since I had gone to the effort to create the example I thought I might as well blog it :o). This example uses the logical AND operator &. Read More... Posted 04 July 2008 23:28 by James.Rowland-Jones | 0 Comments Filed under: Database Development, SQL Server, SQL, T-SQL

• Spatial Data Eye Candy

  In an earlier post I mentioned the new visualisation functionality for spatial data.  Michael Rys kindly pointed me in the direction of Isaac's blog that has some pictures of the new "Spatial Data" tab and resulting visualisation.  Read More... Posted 04 July 2008 09:40 by James.Rowland-Jones | 0 Comments Filed under: Database Development, SQL Server, SQL Server 2008, Spatial Data

• T-SQL IDENTITY : Fun and Games with DBCC CHECKIDENT

  This issue caught me out today whilst putting together some build scripts for reference data. So I thought I’d share it. USE [tempdb] GO CREATE TABLE [dbo].[Table_1](       [Col1] [int] IDENTITY(1,1) NOT NULL,       Read More... Posted 03 July 2008 18:26 by James.Rowland-Jones | 0 Comments Filed under: SQL Server 2005, Database Development, Team Edition for Database Professionals, Datadude, Database Edition, SQL, T-SQL

• DB Pro: New Database Unit Testing Article on MSDN

  I found this new article written by Sachin Rekhi on Database Unit Testing with Team Edition for Database Professionals. I think it's an excellent read. The only thing I don't think it covers is what is not included in the product. The most notable piece Read More... Posted 03 May 2007 09:12 by James.Rowland-Jones | 0 Comments Filed under: SQL Server 2005, Database Development, Team Edition for Database Professionals, Database Unit Test, SQL Server, Datadude

• NOT FOR REPLICATION Database Unit Tests

  I recently put up a post with a unit test for check constraints validating all were defined with the NOT FOR REPLICATION option. I thought it might be helpful to put up a post with tests for all the other object types that can have this option set. select Read More... Posted 02 May 2007 15:40 by James.Rowland-Jones | 0 Comments Filed under: SQL Server 2005, Database Development, Team Edition for Database Professionals, SQL Server, Datadude

• Using SQL Assertions for Database Unit Testing

  Recently I had a need to create some unit tests for a change to the database that was under development. I needed to change the database so that the NOT FOR REPLICATION option was set on all keys, constraints, indexes and triggers. Following an agile Read More... Posted 01 May 2007 20:22 by James.Rowland-Jones | 3 Comments Filed under: SQL Server 2005, Database Development, Agile, Team Edition for Database Professionals, Database Unit Test, SQL Server, Datadude

• Conchango hosts London SQL Server User Group Meeting and London SQL Server BI User Group Meeting

  On Thursday 26th April Conchango hosted meetings of the London SQL Server User Group and the London SQL Server BI User Group . For those that aren't familiar with these groups they are external communities much like our own that are run independently Read More... Posted 29 April 2007 09:51 by James.Rowland-Jones | 3 Comments Filed under: SQL Server 2005, Database Development, Agile, Team Edition for Database Professionals, Business Intelligence, BI, Performance Point Attachment(s): Agile Development Presentation 2007 final.zip