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 249    Older >>
 

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,805 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,926 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,577 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,039 reads

Numeric Data Types

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

Extended Procs

By Dave 2013/10/01 | Category: development
Rating: (not yet rated) |  Discuss |   Briefcase | 2,250 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,405 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,871 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,234 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,537 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,234 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,851 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,324 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 | 318 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,324 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

Execute SQL Scripts in paralel for real performance tests

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.  Read more...
By Gustavo Maia 2009/09/30 | Source: SQLServerCentral.com | Category: development
Rating: |  Discuss |   Briefcase | 1,926 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,169 reads
   Items 1 to 20 of 249    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)    
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 design (1)    
database weekly (1)    
datatypes (1)    
ddl_events (1)    
dependencies (1)    
deployment (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)