|
|
Browse by Tags
All Tags » SQL Server 2005 » Database Development
-
A couple of years ago I worked on an issue with my colleague Steve Wright about an issue with merge replication. You can read Steve’s original post here. However, in summary, the issue boiled down to a security check that merge replication was performing in a generated view called ...
-
AAAaaaaah...Yesterday was just one of those days. I was trying to do something very simple in a script task - assign the current datetime value to one of my variables - and was pulling my stubbly hair out trying to do it.
I am happy to confess to not being the strongest .netter in the world but we do also in SSIS get a pretty pony script ...
-
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,
[Col2] [char](1) NOT NULL
) ON [PRIMARY]
GO
delete from ...
-
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 of Team System Unit Testing functionality that isn't included with DB Pro is Code ...
-
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 object_id,name,is_not_for_replication from sys.foreign_keys where ...
-
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 engineering best practice I created a schema unit test for ...
-
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 by enthusiasts for the respective technology. Both groups emanate from Tony's ...
|
|
|