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

Articles with tag development Rss

Search for any content tagged development

   Items 1 to 20 of 135    Older >>
 

Automated Database Provisioning for Development and Testing

If your development team needs to work on anonymised copies of the current production database, and if changes are being delivered rapidly as well, that could mean a lot of time and routine DevOps work copying databases. SQL Clone was designed for tasks like this. Grant Fritchey investigates whether you save time, effort and scripting over the more traditional approach, and at what point it makes sense to use it.  Read more...
By Additional Articles 2017/10/10 | Source: SimpleTalk | Category: provisioning
Rating:  Rate this |   Briefcase | 3,559 reads

Creating a Robust SSIS Development Environment using the SSIS Catalog

Discover how to integrate features of Visual Studio and the SSIS Catalog for an efficient development and deployment environment.  Read more...
Rating: |  Discuss |   Briefcase | 1,562 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,463 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 | 3,277 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,272 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,981 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,810 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,047 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,306 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 | 320 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

Guide to MCITP: SQL Server 2008 Developer

An overview of what's involved in the two exams you need to pass to become a Microsoft IT Professional in SQL Server 2008.  Read more...
By Mike McQuillan 2009/08/21 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 10,175 reads

Agile Practices Meet Database Development: Intro

I think the database developer role is on the rise and that it's better suited for agile practices - but guidance...  Read more...
By Bill Nicolich 2009/08/06 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 3,033 reads

SQL Server XML Schemas

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.  Read more...
By Jacob Sebastian 2009/02/10 | Source: SQLServerCentral.com | Category: books
Rating: (not yet rated) |  Discuss |   Briefcase | 5,123 reads

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

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.  Read more...
By Phil Factor 2008/12/18 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 418 reads

Introduction to DML Triggers

This article by Jack Corbett explains what triggers are, the different types, and how to avoid common mistakes.  Read more...
By Jack Corbett 2008/10/14 | Source: SQLServerCentral.com | Category: triggers
Rating: |  Discuss |   Briefcase | 13,702 reads

Recursive Queries in SQL Server 2005

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.   Read more...
By Srinivas Sampath 2008/04/18 (first published: 2005/03/03) | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 92,489 reads

Dynamic Connection Strings in Reporting Services 2005

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.   Read more...
By Bilal Khawaja 2007/05/03 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 19,238 reads

Reporting Services Makes Server Support Easier

Reporting Services is one of the most widely used subsystems in SQL Server and there have been some very creative solutions invented by DBAs around the world. New author Carolyn Richardson is one of those, bringing us a implementation that tracks uptime and disk space for her SQL Servers   Read more...
By Carolyn Richardson 2007/03/12 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,770 reads

Maximum Row Size in SQL Server 2005

What is the page size in SQL Server 2005? That's an easy question, but what is the maximum row size? They're not the same thing and ANdy Warren shows you why.   Read more...
By Andy Warren 2007/02/27 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 24,974 reads
   Items 1 to 20 of 135    Older >>