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 21 to 40 of 91    Older >>
 

Dealing with Database Concurrency Conflicts in the Real World

Database concurrency conflicts are somewhat of a plague in software development because they're hard to predict and handle. Unfortunately, they're also hard to prevent.   Read more...
By Additional Articles 2006/10/11 | Source: DevX | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,346 reads

Stress Testing SQL Server

Properly sizing your SQL Server hardware and testing application loads against them is a complex and difficult topic. Anthony Bressi brings us a great new article that gives you a systematic approach to performing your own stress test.   Read more...
By Anthony Bressi 2006/10/10 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 20,318 reads

Preventing Identity Theft Using SQL Server

Solving business problems is an interesting problem for most application developers. Usually the issues are handled in application code, but there are some places where SQL Server can be used to help. Yaroslav Pentsarskyy brings us a creative use of SQL Server functionality to prevent identity theft.   Read more...
By Yaroslav Pentsarskyy 2006/09/20 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,094 reads

SQL Server as an IDS Tool

Intrusion Detection Systems are a great tool for security, but they have suffered from information overload with security professionals struggling to dig through the data. New author Yaroslav Pentsarskyy brings us a look at how SQL Server helped him find security issues.   Read more...
By Yaroslav Pentsarskyy 2006/08/15 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 4,625 reads

Dumping Microsoft SQL Server: MySQL, PostgreSQL attract big users

So, you're a Microsoft SQL Server administrator flirting with open source, but you're not sure how far you should go on the first migration? Don't worry, there won't be much peer pressure to go "all the way." Look around and you'll find that most businesses making the switch are going only as far as their Web applications.  Read more...
By Additional Articles 2006/08/04 | Source: SearchSQLServer | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,923 reads

Moving MicrosofOne of the responsibilities of the Microsoft.com opera

One of the responsibilities of the Microsoft.com operations team is to manage the infrastructure that supports the Windows Update and Microsoft Update services, which have client bases in the hundreds of millions and growing. The Windows Update site provides critical updates, security fixes, software downloads, and device drivers for Windows operating systems. Microsoft Update is the service that brings you all the features and benefits of Windows Update.   Read more...
By Additional Articles 2006/07/28 | Source: MSDN Communities | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,256 reads

Analyzing Disk Capacity for SQL Server

Ensuring that your disk subsystem performs well and does not run out of space is a balancing act that many DBAs learn over time through trial and "out of space" errors. New author Arindam Banerjee takes a look at some of the things to consider when capacity planning.   Read more...
By Arindam Banerjee 2006/07/04 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 15,381 reads

Creating usable applications

If I had a penny for every person who said "usability is just common sense", I'd have a pretty reasonable stack of pennies – maybe 30 or so. Clearly I'm not going to be able to retire on this, but at least it demonstrates that many people have misconceptions about how usable interfaces are designed.  Read more...
By Additional Articles 2006/06/27 | Source: Red-Gate | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,523 reads

Ronni Colville on Configuration Management Databases

Gartner has stated in the past that "configuration management is at the very heart of IT service management." What do you mean by this?  Read more...
By Additional Articles 2006/03/24 | Source: Other | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,817 reads

Ten of the Biggest Mistakes Developers Make With Databases

You may be wonderfully up-to-date with an AJAX Web interface or the latest whizbang Windows user interface, but under the covers, you're probably still pumping data in and out of a database, just as we all did a decade or more ago. That makes it all the more surprising that developers are still making the same database mistakes that date back to those good old days of Windows 95 and before.   Read more...
By Additional Articles 2006/03/23 | Source: developer.com | Category: miscellaneous
Rating:  Rate this |   Briefcase | 6,169 reads

Are single-platform databases in your future?

Despite a growing range of options for integrating mixed database environments, some companies are sidestepping the problem by moving to a single database platform.  Read more...
By Additional Articles 2005/12/16 | Source: Other | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,151 reads

Secrets of successful IT projects

Some time ago, I worked on a team that was attempting to define an IT strategy for a large multinational company. Management incorrectly thought the company was unique in that it had a high number of failed IT projects. In fact, only one in four IT projects can be termed successful, if the benchmarks of success are adherence to scheduled completion time and budget, and realization of the project goal, whether that be saving money, growing the business, or what have you. I have to explain this because many of you may never have come across one.   Read more...
By Additional Articles 2005/12/05 | Source: Red-Gate | Category: miscellaneous
Rating:  Rate this |   Briefcase | 3,412 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,710 reads

Small Scale SQL Server Deployment

Everyone seems to focus on the large scale, enterprise level installations of SQL Server with not a lot of information on the little guy. To that end, new author Tim Mitchell brings us a great overview on what you should consider when setting up a SQL Server environment for a small scale setting.   Read more...
By Tim Mitchell 2005/11/14 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,115 reads

Conducting a SQL Server Operational Audit

Auditing, analyzing and documenting your SQL Server installation is becoming more important all the time, especially as more and more attention is being paid to the security of your environment. Chad Miller brings us a look at a framework and a sample document you can use in your environment to conduct an audit.   Read more...
By Chad Miller 2005/10/24 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 13,160 reads

Starting Query Analyzer

Next in his series on Query Analyzer, Yakov Shlafman brings us a few ways that we can save more keystrokes working with SQL Server 2000's most popular tool. Learn how to customize your environmenty on startup so you can get to work.   Read more...
By Yakov Shlafman 2005/10/12 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 12,357 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,237 reads

Single Point of Administration

Whether you write TSQL code or front end VB code against your SQL Server, it pays to have some good development practices that make your life easier. Jonathan Stokes has written a good article showing some of the good practices you should use.   Read more...
By Jonathan Stokes 2005/08/15 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,911 reads

A SAN Primer

Storage is getting cheaper and cheaper, which means that more and more SQL Server servers will be incorporating SAN storage as an architecture moving forward. It seems that most DBAs, however, have never worked with this technology. New author Hugh Scott brings us a primer on this Storage Area Networks for DBAs new to this technology.   Read more...
By Hugh Scott 2005/06/22 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 15,145 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,213 reads
<< Newer    Items 21 to 40 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)