Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Development Rss

   Items 1 to 20 of 251    Older >>
 

Generic, parameterised, create DB script

A script to be used as part of development deployments where new databases are required, so as to provide standardisation.  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 200 reads

Development Delusions: That it is Enough to Build a Better Mousetrap

You've written a superb, clever, application that you are trying to encourage your colleagues to use. They're not interested. Why? You've neglected the documentation. Surely, the saying goes 'Build a better mousetrap and the world will beat a path to your door'? Nope, not without comprehensive and complete documentation and marketing, it won't. Documentation is the secret of ensuring that good software will succeed.  Read more...
By Additional Articles 2017/01/20 | Source: SimpleTalk | Category: development
Rating:  Rate this |   Briefcase | 1,760 reads

The Exploratory Testing Chrome Plugin

If all your application testing is done by test experts, who know how to record images, do screen-capture, write issue-reports to TFS more appropriate and consistent format and so on, you probably don't need the 'Exploratory Testing' chrome plug-in. Otherwise, it is worth checking out Ambily KK's walkthrough.  Read more...
By Additional Articles 2016/09/05 | Source: SimpleTalk | Category: .net
Rating: (not yet rated)  Rate this |   Briefcase | 2,920 reads

Proper Storage and Handling of Personal Names

As database developers, we may need to rethink the way we store and handle personal names  Read more...
By Tung 2016/08/04 | Source: SQLServerCentral.com | Category: database design
Rating: |  Discuss |   Briefcase | 1,966 reads

Introduction to Row Level Security in SQL 2016

In SQL 2016 several new security features gets introduced which will help users to protect their data in many ways. New security feature Row Level Security (RLS) which implements the security inside the database itself, not at application level.  Read more...
By Kapil Singh 2016/07/14 | Source: SQLServerCentral.com | Category: sql server 2016
Rating: |  Discuss |   Briefcase | 1,676 reads

Do I Want to Design My Own Transaction Log?

The processing of the Transaction Log seems simple to reproduce, but be sure you consider all the possibilities.  Read more...
By Tim Wellman 2016/03/21 | Source: SQLServerCentral.com | Category: transaction log
Rating: |  Discuss |   Briefcase | 2,044 reads

Numeric Data Types

By Orlando Colamatteo 2015/05/05 | Category: data modeling
Rating: (not yet rated) |  Discuss |   Briefcase | 1,831 reads

Generate C# class code for table

For any supplied table, my proc, usp_TableToClass, generates class code in C#, including fields, properties, getters and setters.  Read more...
By Cade Bryant 2013/12/24 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 9,237 reads

Extended Procs

By Dave 2013/10/01 | Category: development
Rating: (not yet rated) |  Discuss |   Briefcase | 2,252 reads

usp_addcolumns

This is a stored procedure to add a columns to multiple tables, if column doesn't exist  Read more...
By Wilfred van Dijk 2013/07/09 | Category: t-sql
Rating: |  Discuss |   Briefcase | 931 reads

iSpy (on your development)

Using EventNotification (Service Broker - DDL_EVENTS) to audit Schema change on a Server, or any of it's databases  Read more...
By Rob Lobbe 2013/06/19 | Source: SQLServerCentral.com | Category: schemas
Rating: |  Discuss |   Briefcase | 1,412 reads

An Incremental Database Development and Deployment Framework

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.  Read more...
By Additional Articles 2013/03/05 | Source: SimpleTalk | Category: deployment
Rating: (not yet rated)  Rate this |   Briefcase | 2,950 reads

Generate C# class code for table

For any supplied table, my proc, usp_TableToClass, generates class code in C#, including fields, properties, getters and setters.  Read more...
By Cade Bryant 2013/12/24 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 9,237 reads

Find Mismatched Views and Stored Procs

Find missing and mismatched views and stored procs between 2 Databases  Read more...
By Pratap Prabhu 2012/09/03 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 1,538 reads

Generate C# class code for table

For any supplied table, my proc, usp_TableToClass, generates class code in C#, including fields, properties, getters and setters.  Read more...
By Cade Bryant 2013/12/24 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 9,237 reads

Truncate All Tables

Script to Truncate all tables part1  Read more...
By Jorge Novo-@ETLDEVDBA 2011/06/02 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 7,857 reads

Column Size Checker

A T-SQL script that reveals how appropriate your choice of column sizes is.  Read more...
By Richard Doering 2010/12/30 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,325 reads

Decoupling the Database

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.  Read more...
By MladenPrajdic 2010/11/22 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 319 reads

Column Size Checker

A T-SQL script that reveals how appropriate your choice of column sizes is.  Read more...
By Richard Doering 2010/12/30 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,325 reads

Database defintion from an Excel Spec?

Have you ever been required to create a database with nothing but a specification in Excel?  Read more...
By Ian Hadlington 2009/11/12 | Source: SQLServerCentral.com | Category: excel
Rating: |  Discuss |   Briefcase | 7,308 reads
   Items 1 to 20 of 251    Older >>
 
Tags
sql server 2005 (68)    
reporting services (ssrs) (46)    
t-sql (15)    
advanced querying (8)    
nums (8)    
sqlinsider scripts (8)    
table of numbers (8)    
tally (8)    
administration (7)    
counter (7)    
arrays (5)    
delimited strings (5)    
miscellaneous (5)    
parse (5)    
string manipulation (5)    
.net (4)    
programming (4)    
sql server 7 (4)    
security (3)    
stored procedures (3)    
2-dimensional arrays (2)    
data warehousing (2)    
deployment (2)    
editorial (2)    
sql server 2008 (2)    
strategies (2)    
table (2)    
agile (1)    
auditing (1)    
automation (1)    
blogs (1)    
books (1)    
c# (1)    
certifications (1)    
crystal clear (1)    
customer service (1)    
data mining (1)    
data modeling (1)    
database (1)    
database design (1)    
database weekly (1)    
datatypes (1)    
ddl_events (1)    
dependencies (1)    
design and theory (1)    
designing database solutions (1)    
developer (1)    
eventnotification (1)    
events (1)    
exams (1)    
excel (1)    
integration services (ssis) (1)    
internals (1)    
maintenance (1)    
mcitp (1)    
mcts (1)    
names (1)    
naming (1)    
notifications (1)    
palalelism (1)    
prime (1)    
prime number (1)    
replication (1)    
schemas (1)    
scrum (1)    
sieve (1)    
sql server (1)    
sql server 2008 r2 (1)    
sql server 2016 (1)    
sqlservercentral (1)    
staging (1)    
storage (1)    
stress test (1)    
studying (1)    
transaction log (1)    
triggers (1)    
truncate table (1)    
utility (1)    
xml (1)    
xsl (1)