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

Content with tags Programming, Miscellaneous Rss

<< Newer    Items 41 to 60 of 169    Older >>
 

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,015 reads

SQL Server Scripting and WMI

Ever been paged while out with your family for some SQL Server problem that had you cutting an evening short? New author Anthony Loera has and he brings us some scripts that he uses to handle some of those crisis from any email device, PDA, phone, and keep him in front of his kids on the weekends.   Read more...
By Anthony Loera 2005/04/11 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 23,108 reads

Using VBScript to Automate Tasks

This article discusses why VBScript should be one of the tools you use to manage your server. Sample scripts show how to remove files over x days old and how to FTP files.   Read more...
By Haidong Ji 2008/03/07 (first published: 2003/11/04) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 100,315 reads

Part 2: Mapping XML from SQL Server to a Single Cell in Excel 2003

In the second of this three-part series, learn how to map well-formed XML from a standard SQL Server query to a single cell in a worksheet. The resulting output is an XML tree with non-repeating elements.   Read more...
By Additional Articles 2005/04/06 | Source: MSDN Communities | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,609 reads

Part 1: Automating the XML Data Mapping Process in Excel 2003

In the first of a three-part series, learn how to use XML maps to customize Excel as a data input and display system.   Read more...
By Additional Articles 2005/04/05 | Source: MSDN Communities | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,615 reads

COM Without Registration

When .NET first appeared it wasn't unusual to hear the question "Is COM dead?" In fact COM seems to be alive and well, and in this article I'll look at the way that Windows XP and Windows Server 2003 allow you to use COM in a side-by-side way without installing the usual registration entries – you won't need to use the Windows Registry to use side-by-side COM components.   Read more...
By Additional Articles 2005/03/08 | Source: Red-Gate | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,318 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,813 reads

Review: Access Workbench

For some years, I have been asked to review a product that I have only just gotten around to looking at. It was developed by Garry Robinson, who publishes a very useful web resource called vb123.com and who recently wrote one of the best books on Access security, Real World Microsoft Access Database Protection and Security. The product is called The Access Workbench (TAW)   Read more...
By Additional Articles 2005/02/25 | Source: Database Journal | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,883 reads

Performance Tuning Tips for Using Microsoft Access

If you are really interested in the fastest performance, don't use Access as a front-end to a SQL Server database. While Access is relatively easy to learn and fast to develop in, its performance if poor when compared to other front-end options. But if you like to develop in Access, or don't have any choice, then the tips on this page will help a little to boost your application's performance.   Read more...
By Additional Articles 2005/02/22 | Source: SQL Server Performance | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,687 reads

Data Driven Architecture

Most SQL Server developers and DBAs are familiar with the concept of using a database as a back end to a web site or other application. However the database can be used to store more than just the data that users will edit. An interesting approach to application design begins with some knowledge of the metadata about the underlying data structures and using this to drive the application's behavior. New author Jim Craddock has utilized just such a concept in one if his applications and he brings us a look at how this works.   Read more...
By Jim Craddock 2005/02/17 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,902 reads

Writing to a File Using the sp_OACreate Stored Procedure and OSQL: The

SQL Server has extensions to allow one to call COM based objects from within the server using T-SQL. While this is an interesting feature, it's may not be the best way to structure your applications due to performance reasons. New author Zach Nichter of ScalabilityExperts.com brings us an analysis of different ways of writing out to a file from within SQL Server. Read on to see the most efficient method of generating files on your server.   Read more...
By Zach Nichter 2006/11/10 (first published: 2005/02/07) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 33,948 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,789 reads

Microsoft Wants to Hear From You

A short survey from Microsoft looking for feedback from users in order to try and improve the application development process. If you build applications with MS technolgies, especially SQL Server, take a moment and respond.   Read more...
By Press Release 2004/12/10 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: (not yet rated) |  Discuss |   Briefcase | 2,808 reads

Worst Practices - Part 1 of a Very Long Series!

Andy starts a new series about Worst Practices - come find out why and read about the first one on his list - using Hungarian Notation for column names!   Read more...
By Andy Warren 2004/12/03 (first published: 2001/10/09) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 33,727 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,589 reads

Searching the FileSystem

SQL Server excels at storing and retrieving data, especially in the area of reporting on this data. Chris Cathers has come up with a great solution for gathering and reporting on the filesystem on his network, enabling him to help out his local sysadmins.   Read more...
By Chris Cathers 2004/10/25 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,481 reads

Working with Image Objects in InfoPath 2003 and SQL Server 2000

You can use features in Microsoft Office InfoPath 2003 Service Pack (SP) 1 to work more efficiently with image objects and other data. Learn how to use BLOB data types to work with data stored in a Microsoft SQL Server 2000 database from an InfoPath form. InfoPath 2003 provides a robust and rich interface to store and access data in SQL Server databases. Learn about best practices for integrating SQL Server databases and InfoPath form data, with an illustrative example.  Read more...
By Additional Articles 2004/10/22 | Source: MSDN Communities | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,114 reads

Versioning

How many times has an application exploded because you upgraded or patched SQL Server? How many people were aware that a patch was applied? New author Andre Vigneau has dealt with this and gives us some code that our applications can use to check to see if anything has changed. It doesn't keep the code working, but it does allow you to inform users that something has changed.   Read more...
By Andre Vigneau 2004/10/21 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 5,672 reads

Architecting Disconnected Mobile Applications Using a Service Oriented

The Windows Mobile platform, which includes Microsoft .NET Compact Framework and Microsoft SQL Server CE, encapsulates the complex tasks of communication management and data exchange while your device is in a disconnected state. (16 printed pages)  Read more...
By Additional Articles 2004/10/13 | Source: ASPToday | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,391 reads

Exchange from SQL Server

SQL Server allows data access from many sources, probably any that you could want. Some, however, are easier than others. Have you ever tried to update information in Exchange from SQL Server? Not that easy, but new author Steve Boriotti has written code as well as a short article on how you can make this happen.   Read more...
By Steve Boriotti 2004/10/04 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 10,863 reads
<< Newer    Items 41 to 60 of 169    Older >>
 
Tags
sql server 7 (45)    
t-sql (45)    
strategies (24)    
administration (23)    
visual basic 6 (22)    
database design (14)    
ado (13)    
stored procedures (12)    
configuring (11)    
performance tuning (10)    
.net (9)    
security (8)    
advanced querying (6)    
sql-dmo (6)    
basics (4)    
career (4)    
data warehousing (4)    
dts (4)    
naming standards (4)    
replication (4)    
reviews (4)    
xml (4)    
asp (3)    
backup / restore (3)    
best and worst practices (3)    
book reviews (3)    
certifications (3)    
indexing (3)    
monitoring (3)    
system development life cycle (3)    
worst practices (3)    
access (2)    
analysis services (ssas) (2)    
availability (2)    
olap server (2)    
sql puzzles (2)    
sql server 6.5 (2)    
advanced (1)    
c++ (1)    
disaster recovery (dr) (1)    
english query (1)    
installation (1)    
other (1)    
product reviews (1)    
rants (1)    
semaphore (1)    
state of the business (1)