Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, Programming Rss

<< Newer    Items 21 to 40 of 70    Older >>
 

Stop SQL Injection Attacks Before They Stop You

A new article from MSDN magazine on stopping SQL Injection attacks by examining how the SQL can be exploited. It's a good basic article for developers as well as DBAs who might have to review code.  Read more...
By Additional Articles 2004/08/20 | Source: MSDN Communities | Category: security
Rating:  Rate this |   Briefcase | 2,389 reads

Think like a DBA

What do your programmers do with nulls? Do they know nullif, isnull, what about the powerful coalesce function? Do they think DBA's look at the world differently? Why, it's all code isn't it?   Read more...
By Andy Warren 2004/07/29 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 10,879 reads

The Bowling Challenge

Know anything about bowling? Or writing hard core TSQL? Or test driven development? Even if you don't, this might be a good way to build those skills. Write a stored procedure that can score a bowling game and you might win one of our books and a shirt!   Read more...
By Andy Warren 2004/07/22 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 9,200 reads

Reducing Round Trips - Working with HTML Checkboxes

Reducing the amount of round trips between a server and client is something that can give you a great boost in performance. David Poole looks at how he solved a problem with HTML checkboxes and the challenges they solve in a programming environment. Without Dynamic SQL!   Read more...
By David Poole 2004/06/11 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 9,209 reads

Speed up Development on Backend and Middle Tier with SQL Scripts

This article shows some options to retrieve all the metadata you'll need to write scripts that write scripts. No, that's not a goof, this article is about code generation.   Read more...
By Ameet Phadnis 2004/04/09 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,621 reads

Generate Next Numbers with SQL Server

Dinesh ran into a situation where a client had very specific requirements for generating keys. Take a look at the solution, can you better alternatives? Sometimes you just can't talk the client into changing!   Read more...
By Dinesh Asanka 2004/03/05 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 14,293 reads

Using Bits to Store Data

David recently worked on a project where it turned out storing the answers to a survey using bitmapping was a good approach. He was good enough to write some of it down and share. As he notes bitmapping isn't used as often as it used to be, but it can still be a useful technique to have around.   Read more...
By David Poole 2004/01/06 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,364 reads

Dealing With Changing Data

As Chris points out, in most applications these days you end up having to go with optimistic locking, which presents a few challenges. Chris works through the list of options. If you're building web/disconnected apps and need anything besides last update wins, this one is for you.   Read more...
By Christoffer Hedgate 2003/12/19 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 9,421 reads

Full Text Indexing - Text Parsing Routine

Full text indexing is interesting, but not always easy for the user to apply well. Chris has some ideas about to make that   Read more...
By Chris Kempster 2003/12/11 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 12,027 reads

Review of AdeptSQL

Another product review! Chris put AdeptSQL (a schema comparison and sync product) to work and wrote up the results. This article also includes some feedback from the vendor that is worth reading.   Read more...
By Chris Kempster 2003/11/03 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 4,399 reads

Creating a PDF from a Stored Procedure

A short but interesting article, the author has figured out a way to create a PDF from a stored procedure without using a third party library.   Read more...
By Masar Ivica 2005/09/02 (first published: 2003/08/26) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 55,070 reads

Review of Murachs SQL for SQL Server

Andy rates this one 4.5 out of 5 stars and likes it enough to recommend it's use at work. This is a book that should teach a developer how to use the key abilities of SQL. If you're looking for a book to guide your beginning/intermediate developers, this might be it.   Read more...
By Andy Warren 2003/08/06 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 3,603 reads

Finding and Deleting Duplicate Data

Bad data is almost a given, but true duplicate data can really cause you some headaches. How do you remove all the duplicates and still leave a 'keeper' record? If you think procedural code it's not too hard, but can you do a set based solution? Chris shows you show!   Read more...
By Chris Cubley 2003/07/25 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 19,827 reads

MSMQ Extended Stored Procedures For SQL Server

As you might guess from the title, this is an extended stored procedure that you can use to interact with MSMQ. It's supposed to be extremely fast, able to handle 4-5k messages per second and have a very small memory footprint. (Press Release)   Read more...
By Additional Articles 2003/07/17 | Source: Other | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,277 reads

Free BCP GUI

Pedro Estrada has published a free tool that according to his site "This is a complete application to have an easier interface to work with BCP against MSSQL servers. Just specify a server, database, table user name and password to BCP out or IN." Worth a try, and he has some other free utilities (some SQL, some not) on the site.  Read more...
By Additional Articles 2003/06/19 | Source: ASPToday | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,874 reads

COM+, SQL Server, Serializable isolation level and the issues!

This article shows you how to identify SQL Server performance problems and explains how the SERIALIZABLE transaction isolation level effected the performance of an OLTP application.  Read more...
By Additional Articles 2003/05/22 | Source: Other | Category: performance tuning
Rating:  Rate this |   Briefcase | 1,384 reads

Handling The Text Data Type

Robert is back this week with a look at the text data type. Not the easiest thing to work with, but sometimes a varchar just doesn't give you the range you need.   Read more...
By Robert Marda 2003/05/07 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 25,103 reads

An Automated Solution for Migrating Database Structures

This article by Simon Galbraith (from Red Gate software, maker of SQL Compare) discusses migrating changes from development to staging, QA, and on to production. If you've never seen the need for a schema compare tool (Steve Jones!), this is worth reading.  Read more...
By Additional Articles 2003/05/06 | Source: DevX | Category: administration
Rating:  Rate this |   Briefcase | 2,229 reads

Creating a Script from a Stored Procedure

Ryan demonstrates how he arrived at a solution that allows you to create scripts from a stored procedure using SQL-DMO. If you get interested in DMO, we've got quite a bit of additional content here on the site to help you get going! Ryan is a new author here on the site, please take a minute to read his article, add a comment, maybe just say hello.   Read more...
By Ryan Randall 2003/05/02 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 16,465 reads

New MDX Book Published

Fast Track to MDX gives readers all the necessary background information needed to write useful, powerful MDX expressions and introduces the most frequently used MDX functions and constructs. No prior knowledge is assumed and examples are used throughout the book to rapidly develop MDX skills to the point where a reader can solve real business problems. A CD containing examples from within the book, and a time-limited version of ProClarity, is included  Read more...
By Additional Articles 2003/05/01 | Source: Other | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,239 reads
<< Newer    Items 21 to 40 of 70    Older >>
 
Tags
miscellaneous (45)    
sql server 7 (18)    
stored procedures (18)    
visual basic 6 (14)    
administration (11)    
ado (11)    
strategies (9)    
performance tuning (8)    
advanced querying (7)    
database design (6)    
sql-dmo (6)    
configuring (5)    
.net (4)    
security (4)    
basics (3)    
sql puzzles (3)    
asp (2)    
best and worst practices (2)    
naming standards (2)    
worst practices (2)    
xml (2)    
analysis services (ssas) (1)    
backup / restore (1)    
common table expressions (cte) (1)    
data warehousing (1)    
indexing (1)    
installation (1)    
monitoring (1)    
semaphore (1)    
synonyms (1)    
updategrams (1)