SQLServerCentral.com Content tagged Development

iSpy (on your development)

Wed, 19 Jun 2013 06:00:00 UT

Using EventNotification (Service Broker - DDL_EVENTS) to audit Schema change on a Server, or any of it's databases

An Incremental Database Development and Deployment Framework

Tue, 05 Mar 2013 07:00:00 UT

Often, an existing database application must evolve rapidly by incremental steps. Alex describes a tried and tested system to provide an automated approach to deploying both new and existing database systems, whilst dealing with common security and configuration issues.

Generate C# class code for table

Thu, 06 Sep 2012 06:00:00 UT

For any supplied table, my proc, usp_TableToClass, generates class code in C#, including fields, properties, getters and setters.

Find Mismatched Views and Stored Procs

Mon, 03 Sep 2012 06:00:00 UT

Find missing and mismatched views and stored procs between 2 Databases

Generate C# class code for table

Thu, 06 Sep 2012 06:00:00 UT

For any supplied table, my proc, usp_TableToClass, generates class code in C#, including fields, properties, getters and setters.

Truncate All Tables

Thu, 02 Jun 2011 06:00:00 UT

Script to Truncate all tables part1

Column Size Checker

Thu, 30 Dec 2010 07:00:00 UT

A T-SQL script that reveals how appropriate your choice of column sizes is.

Decoupling the Database

Mon, 22 Nov 2010 07:00:00 UT

Database refactoring is a difficult proposition at the best of times, but is rendered more or less impossible if the database is close-coupled to the application's other components. In a guest editorial, Mladen Prajdic stresses the importance of a native SQL Server abstraction layer.

Column Size Checker

Thu, 30 Dec 2010 07:00:00 UT

A T-SQL script that reveals how appropriate your choice of column sizes is.

Database defintion from an Excel Spec?

Thu, 12 Nov 2009 07:00:00 UT

Have you ever been required to create a database with nothing but a specification in Excel?

Want to work faster with SQL Server?
If you want to work faster try out the SQL Toolbelt. "The SQL Toolbelt provides tools that database developers as well as DBAs should not live without." William Van Orden. Download the SQL Toolbelt here.

Execute SQL Scripts in paralel for real performance tests

Wed, 30 Sep 2009 06:00:00 UT

Ever tried to simulate a production environment in a development one but realized that you couldn't easily start 500 executions simultaneously ? This script will help you out.

Guide to MCITP: SQL Server 2008 Developer

Fri, 21 Aug 2009 06:00:00 UT

An overview of what's involved in the two exams you need to pass to become a Microsoft IT Professional in SQL Server 2008.

Agile Practices Meet Database Development: Intro

Thu, 06 Aug 2009 06:00:00 UT

I think the database developer role is on the rise and that it's better suited for agile practices - but guidance...

Prime Number Table Generator (new ver crunches to 1 Mil in <10.5 sec!)

Wed, 15 Jul 2009 06:00:00 UT

Generates prime numbers and puts them into a table for future reference by adhoc queries and database and application code. 100% set-based. DDL embedded.

SQL Server XML Schemas

Tue, 10 Feb 2009 19:35:38 UT

When information is exchanged in XML format, there needs to be an agreement between the sender and receiver about the structure and content of the XML document. An XSD (XML Schema Definition Language) Schema can be used to enforce this contract and validate the XML data being exchanged. Jacob Sebastian's book explains all.

Guest Editorial: That ain't a Database, it's a Spreadsheet

Thu, 18 Dec 2008 07:00:00 UT

Phil recently had to draw up a list of 'top ten' pieces of advice for programmers who were starting out as database developers. It is a difficult thing to do when one is immersed in the study of the intricacies and detail of the plumbing of SQL Server.

Delimited String Parsing Functions - TwoCol set

Mon, 03 Nov 2008 07:00:00 UT

Feed it two delimited strings of horizontal data and it returns it back as a vertical table with the two column data in the same synchronized position order.

Delimited String Parsing Functions - Big2D set

Wed, 22 Oct 2008 06:00:00 UT

Feed it large strings of double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.

Delimited String Parsing Functions - Basic Set

Mon, 20 Oct 2008 06:00:00 UT

Feed it delimited horizontal data and it returns it back as a vertical table.

Delimited String Parsing Functions - 2D set

Tue, 14 Oct 2008 06:00:00 UT

Feed it double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.

Introduction to DML Triggers

Tue, 14 Oct 2008 06:00:00 UT

This article by Jack Corbett explains what triggers are, the different types, and how to avoid common mistakes.

Delimited String Parsing Functions - Big Set

Wed, 06 Aug 2008 03:03:20 UT

Feed it large strings of delimited horizontal data and it returns it back as a vertical table.

Counter Table (table of numbers) Setter-Upper for SQL Server 2005

Wed, 06 Aug 2008 02:57:05 UT

Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 622, 386884, and 240641848 numbers.

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

Counter Table (table of numbers) Setter-Upper for SQL Server 2000

Wed, 06 Aug 2008 02:50:45 UT

Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 620, 384400, and 238328000 numbers.

Find Mismatched Views and Stored Procs

Mon, 03 Sep 2012 06:00:00 UT

Find missing and mismatched views and stored procs between 2 Databases

usp_addcolumns

Tue, 01 Jul 2008 06:00:00 UT

This is a stored procedure to add a columns to multiple tables, if column doesn't exist

usp_dependencytree

Wed, 25 Jun 2008 10:19:13 UT

displays a graphical tree of dependencies of an object

Truncate All Tables

Thu, 02 Jun 2011 06:00:00 UT

Script to Truncate all tables part1

Recursive Queries in SQL Server 2005

Fri, 18 Apr 2008 06:00:00 UT

Part 2 of new T-SQL enhancements from Srinivas Sampath. SQL Server 2005 contains a number of enhancements designed to allow you to write more powerful queries while keeping the code structured in a way that makes development and understanding it easier. Building on his first look at Common Table Expressions, Srinivas now looks at recursive queries with CTEs.

Dynamic Connection Strings in Reporting Services 2005

Thu, 03 Apr 2008 06:00:00 UT

Reporting Services is one of the most popular features of SQL Server 2005 and there have been a tremendous number of enhancements to this subsystem. New author Bilal Khawaja brings us a look at dynamic connection strings and how you can have one report pulling data from different servers.