Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Authors
About us
Contact us
Newsletters
Write for us
Daily SQL Articles by email:
Sign up
Content with tags
T-SQL
,
Programming
,
Miscellaneous
Items 1 to 20 of 53
Older >>
Introduction to Bitmasking in SQL Server 2005
The use of bitmasking is usually limited to decoding values in the system views, but it can be useful in other places when you want to save space. New author Lee Everest brings us an introduction to bitmasking and its use in SQL Server 2005.
Read more...
By
Lee Everest
2006/12/13
|
Source:
SQLServerCentral.com
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
15,715 reads
Introduction to Bitmasking in SQL Server 2005
The use of bitmasking is usually limited to decoding values in the system views, but it can be useful in other places when you want to save space. New author Lee Everest brings us an introduction to bitmasking and its use in SQL Server 2005.
Read more...
By
Lee Everest
2006/12/13
|
Source:
SQLServerCentral.com
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
15,715 reads
Unit Testing With Visual Studio
Testing is an important part of programming and it is no different with SQL Server development. Longtime author Grant Fritchey brings us a look at the new testing features available in Visual Studio 2005.
Read more...
By
Grant Fritchey
2006/11/15
|
Source:
SQLServerCentral.com
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
9,079 reads
Implementing a T-SQL semaphore
SQL Server does a great job of handling concurrency & ensuring that users can make changes in multi-user systems without conflict. However there are times a strict calling order is needed.
Read more...
By
Robert Cary
2006/10/17
|
Source:
SQLServerCentral.com
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
11,190 reads
A Look at GUIDs
Not many people enjoy using Globally Unique Identifiers (GUIDs), partly because they are cumbersome to type and work with for humans. However they fill a need and can provide some interesting benefits. SQL Server expert Andy Warren takes us through what a GUID is and how you can use it easily in your code.
Read more...
By
Andy Warren
2006/07/27
|
Source:
SQLServerCentral.com
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
15,741 reads
Introduction to the ADO Connection Object
Part 1 of a 4 part series about ADO, this is a beginner level article designed to get you started using the ADO connection object. If you haven't used ADO so far, why not see what it's all about?
Read more...
By
Andy Warren
2006/05/26 (first published: 2001/11/08)
|
Source:
SQLServerCentral.com
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
30,985 reads
Generating a Sequential Pattern
For many of us, working with the identity property allows us to easily generate a sequential series of numbers. But what if you need to generate a sequence according to some pattern, like one that includes the year? New author Asif Sayed brings us a technique and the code for generating a patterned sequence.
Read more...
By
Asif Sayed
2006/05/17
|
Source:
SQLServerCentral.com
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
8,981 reads
How to Build Dynamic Stored Procedures
Robert is our expert on dynamic sql. This week he offers some good hints for planning the contruction of a proc that will use dynamic sql. He also adds some suggestions on how to format the code so that when you return to it later, you can figure out what you were doing!
Read more...
By
Robert Marda
2005/12/16 (first published: 2003/04/25)
|
Source:
SQLServerCentral.com
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
49,057 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
|
56,243 reads
Dynamic SQL or Stored Procedure
We've had a lot of coverage of dynamic sql (including another great one from Robert Marda later this week) but this one is a little different. Done in a question/answer format, Andy tries to explain to junior developers why dynamic sql is to be avoided, how to do so, what to do when you can't.
Read more...
By
Andy Warren
2005/08/26 (first published: 2003/04/23)
|
Source:
SQLServerCentral.com
|
Category:
performance tuning
Rating:
|
Discuss
|
Briefcase
|
47,291 reads
You Want To Do What, with MY Database?
SQL Server 2000 is an extremely powerful and flexible development platform, but if the users mess up the data, there's nothing you can do. Protecting the integrity sometimes means severely limiting access to users. Roy Carlson brings us a technique using sp_makewebtask that you can easily use to provide users with some data without giving them query access.
Read more...
By
Roy Carlson
2005/05/17
|
Source:
SQLServerCentral.com
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
15,027 reads
SQL Maintenance Plans
Do you use the maintenance plans or hate them? Wish they would do more? Curious about how they work under the hood? Cmon, you gotta read this one! Trust us, it's not another "how-to" article! Well, maybe just a little bit!
Read more...
By
Andy Warren
2005/03/04 (first published: 2002/04/11)
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
33,837 reads
Data Dictionary from within SQL Server 2000
Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!
Read more...
By
Mindy Curnutt
2005/02/04 (first published: 2002/02/11)
|
Source:
SQLServerCentral.com
|
Category:
installation
Rating:
|
Discuss
|
Briefcase
|
35,855 reads
Divide and Conquer
This is the first article by Steve Jones that examines a programming technique for handling operations that may be too large to run in a single query.
Read more...
By
Steve Jones
2004/11/05 (first published: 2001/05/09)
|
Source:
SQLServerCentral.com
|
Category:
miscellaneous
Rating:
|
Discuss
|
Briefcase
|
17,662 reads
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,695 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,891 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,231 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,213 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,624 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,320 reads
Items 1 to 20 of 53
Older >>
Tags
sql server 7
(16)
stored procedures
(12)
administration
(10)
strategies
(9)
visual basic 6
(9)
advanced querying
(6)
database design
(6)
performance tuning
(6)
configuring
(5)
ado
(4)
sql-dmo
(4)
.net
(3)
security
(3)
basics
(2)
best and worst practices
(2)
naming standards
(2)
sql puzzles
(2)
worst practices
(2)
analysis services (ssas)
(1)
asp
(1)
backup and restore
(1)
data warehousing
(1)
indexing
(1)
installation
(1)
monitoring
(1)
semaphore
(1)
xml
(1)
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.