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

Content with tags Miscellaneous, Strategies Rss

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

Selecting a Web Host for your SQL Server Driven Website Part 2

Many of us have SQL Servers at work that we learn on, test with work, etc. But getting your own SQL Server for a website can be a tricky thing. Especially on a budget. Or maybe your company wants to have their website hosted. Before you spend any hard earned money, read part 2 of this two part series by Jon Reade on what to look for when setting up a SQL Server hosting company.   Read more...
By Jon Reade 2005/04/20 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 5,271 reads

Selecting a Web Host for your SQL Server Driven Website Part 1

Many of us have SQL Servers at work that we learn on, test with work, etc. But getting your own SQL Server for a website can be a tricky thing. Especially on a budget. Or maybe your company wants to have their website hosted. Before you spend any hard earned money, read this two part series by Jon Reade on what to look for when setting up a SQL Server hosting company.   Read more...
By Jon Reade 2005/04/19 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,104 reads

Estimating Your Space Needs

How many times have you had to estimate space for a new SQL Server database? How much time did you spend on it? Was it a thumb-in-the-wind guess or did you actually examine a schema and calculate some values. If you have asked someone to estimate the space their database will need, they probably guess more than compute, but now Andre Vigneau gives us an easy way we can teach those developers to put some thought into the process.   Read more...
By Andre Vigneau 2005/01/25 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 11,500 reads

A Look at MYSQL

SQL Server is the best RDBMS, at least according to the current thinking at SQLServerCentral.com, and is fully capable of meeting all of your database needs. However that does not mean you should ignore other platforms. A good DBA will be aware of and perhaps skilled in other platforms and tools, including competing database systems. There has been a lot of buzz about the open source MySQL RDBMS this past year and David Poole takes a look at this server, giving you some points of comparison with   Read more...
By David Poole 2005/01/04 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 11,368 reads

SQL Server Hardware Performance Checklist

We take a look at each of the major components of a SQL Server's hardware, and examine what can be done to help maximize the performance of your hardware.  Read more...
By Additional Articles 2004/12/27 | Source: Other | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,804 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,748 reads

Data Sanitization Techniques

Data Sanitization is the process of making sensitive information in non-production databases safe for wider visibility. This White Paper is an overview of various techniques which can be used to sanitize sensitive production data in test and development databases.   Read more...
By Additional Articles 2004/11/29 | Source: Other | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,845 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,400 reads

Innovation

Andy has some examples of not very high tech solutions that involve some technology behind the scenes, but the binding factor was that someone had to see the problem first. Not about SQL, but we think it is on topic.   Read more...
By Andy Warren 2004/10/08 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 4,448 reads

Messaging Patterns in Service-Oriented Architecture, Part 1

A service oriented architecture seeks to decouple some of the tight connections normally built between systems and components. Here's a great overview on how messaging between systems can be setup from MSDN.  Read more...
By Additional Articles 2004/09/20 | Source: MSDN Communities | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,185 reads

Disaster in the Real World - Hurricane

Hurricane Charlie had a pretty substantial impact on residents and businesses in Central Florida. Andy lives in the Orlando area and wrote up some notes on the various challenges he ran into it. Out of it you might find a couple things worth thinking about adding into your DR plan.   Read more...
By Andy Warren 2004/08/24 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,253 reads

Data Migration : Step by Step

This article by Chris Kempster covers a wide variety of areas concerned with data migration. Primarily, it focuses on process, standards and some of the many issues to consider when undertaking this role.   Read more...
By Chris Kempster 2005/11/25 (first published: 2004/03/24) | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 47,768 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,422 reads

Best Practices in an Adhoc Environment

This short article looks at some mistakes developers should avoid when they also have the task of designing the database, database objects, or TSQL used to access it.   Read more...
By Sharad Nandwani 2003/12/16 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 7,908 reads

Custom Log Shipping

One of our favorite authors is back with a great how-to on log shipping. This isn't the baked in log shipping, this is a code your own solution that gives you a starting point for your situation. Even if you don't need it now, it's worth looking at to gain a better understanding of how shipping works.   Read more...
By Chris Kempster 2003/11/26 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 24,343 reads

Is XML the Answer?

New Author! Don Peterson writes his first article for us and explores why he considers XML to be...bad! There are some interesting points made here and if you've haven't thought about what XML means to you as a DBA, it's a subject worth spending some time on.   Read more...
By Don Peterson 2008/05/02 (first published: 2003/10/07) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 64,217 reads

Managing Jobs - Part 4

Andy has been busy lately on a project you'll be hearing more about soon (!), but he did manage to get part four of his managing jobs series done. This article discusses ideas for patterns to follow when building jobs, including writing to the console, setting errorlevels, and how to get them installed on the server. DBA's, if you're not developers, look at this article - this is stuff you can take to your development team and get better/more manageable jobs.   Read more...
By Andy Warren 2003/06/25 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,980 reads

Lessons from my first Project as a Project Manager

David tries his hand at Project Management and what follows is a list of tips and problems from that experience. As David points out, it's interesting to see things from the other (not developer or DBA) point of view.   Read more...
By David Poole 2003/06/04 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 5,728 reads

Customers Don't Know What They Want

This article on the JoelonSoftware site discusses project management and customer expectations. It has a great discussion of why non-technical users place so much value on what they can see (the GUI) while developers place so much value in what can't be seen (yeah, the code!). It's actually more interesting than that, take a look!  Read more...
By Additional Articles 2003/06/03 | Source: ASPToday | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,007 reads

Comparison of Business Intelligence Strategies between SQL and Oracle

Dinesh does a good write up on research he did investigating the BI market and doing a feature comparison between Oracle 9i and SQL 2000. Simple bullet point format, worth a look.   Read more...
By Dinesh Priyankara 2003/05/19 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 19,235 reads
<< Newer    Items 41 to 60 of 91    Older >>
 
Tags
sql server 7 (29)    
programming (24)    
administration (20)    
t-sql (14)    
database design (9)    
configuring (7)    
security (6)    
system development life cycle (6)    
visual basic 6 (6)    
availability (5)    
.net (4)    
best and worst practices (4)    
career (4)    
naming standards (4)    
performance tuning (4)    
stored procedures (4)    
backup / restore (3)    
disaster recovery (dr) (3)    
sql server 2005 (3)    
worst practices (3)    
book reviews (2)    
certifications (2)    
indexing (2)    
monitoring (2)    
replication (2)    
reviews (2)    
sql-dmo (2)    
xml (2)    
advanced querying (1)    
analysis services (ssas) (1)    
best practices (1)    
data mining (1)    
data types (1)    
data warehousing (1)    
development (1)    
dts (1)    
olap server (1)    
sql puzzles (1)    
state of the business (1)    
xsl (1)