SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Development Rss

   Items 1 to 20 of 253    Older >>
 

Date Dimension Script

T-SQL script that creates Date_Dim & populates it for any date-range.  Read more...
By Dave Bunch 2017/05/08 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 359 reads

Automating the Setup of the Local Developer Machine

On both Windows and Linux, the chore of setting up a development workstation can take several days, and there always seem to be a few configuration settings that get missed. You can reduce the time and tedium dramatically by automating the process by using Vagrant to set up the operating system, followed by your choice of provisioning, configuration management and orchestration applications such as Puppet, Chef, Ansible, Salt, Docker, Chocolatey and Boxstarter. Vishwas shows how to make it easy to do with Vagrant, Chocolatey and Boxstarter.  Read more...
By Additional Articles 2017/01/24 | Source: SimpleTalk | Category: development
Rating:  Rate this |   Briefcase | 3,102 reads

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 | 340 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 | 2,965 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 | 3,042 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,971 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,739 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,046 reads

Numeric Data Types

By Orlando Colamatteo 2015/05/05 | Category: data modeling
Rating: (not yet rated) |  Discuss |   Briefcase | 1,842 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,246 reads

Extended Procs

By Dave 2013/10/01 | Category: development
Rating: (not yet rated) |  Discuss |   Briefcase | 2,255 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,420 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 | 3,065 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,246 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,539 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,246 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,863 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
   Items 1 to 20 of 253    Older >>
 
Tags
sql server 2005 (68)    
reporting services (ssrs) (46)    
t-sql (16)    
advanced querying (8)    
nums (8)    
sqlinsider scripts (8)    
table of numbers (8)    
tally (8)    
administration (7)    
counter (7)    
miscellaneous (6)    
arrays (5)    
delimited strings (5)    
parse (5)    
string manipulation (5)    
.net (4)    
programming (4)    
sql server 7 (4)    
data warehousing (3)    
security (3)    
stored procedures (3)    
2-dimensional arrays (2)    
database design (2)    
deployment (2)    
editorial (2)    
sql server (2)    
sql server 2008 (2)    
sql server 2016 (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 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)    
other (1)    
palalelism (1)    
prime (1)    
prime number (1)    
replication (1)    
schemas (1)    
scrum (1)    
sieve (1)    
sql server 2008 r2 (1)    
sql server 2012 (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)