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

Guest Columnist: Additional Articles

SQLServerCentral.com profile

   Items 1 to 20 of 49    Older >>
 

Is Source Control Really That Boring?

The SSC team has put together a little quiz on database source control to go with Rob Richardson, Robert Sheldon, and Tony Davis' new book, SQL Server Source Control Basics. Do you daydream about source control... or daydream to avoid it?  Read more...
By Additional Articles 2014/07/22 | Source: SQLServerCentral.com | Category: survey
Rating: |  Discuss |   Briefcase | 1,451 reads

Good Practices for Software Development

We always want to follow the best, or at least good, practices for software development. However do you know what those are? Steve Jones notes there's at least one that isn't often followed.  Read more...
By Additional Articles 2014/04/24 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 249 reads

SQLServerCentral Webinar #26: Best Practices in Database Deployment (Part 2)

Grant Fritchey (SQL Server MVP) and David Simner (Red Gate developer) give you a step-by-step guide of how you can automate your database deployment Process using Red Gate Deployment Manager.  Read more...
By Additional Articles 2013/09/04 | Source: SQLServerCentral.com | Category: webinar
Rating: (not yet rated) |  Discuss |   Briefcase | 166 reads

SQLServerCentral Webinar #25: Best Practices in Database Deployment (Part 1)

SQL Server Central Webinar #25: Best Practices in Database Deployment (Part 1)  Read more...
By Additional Articles 2013/08/28 | Source: SQLServerCentral.com | Category: webinar
Rating: |  Discuss |   Briefcase | 501 reads

New Resource: LearnSomeSQL.com

We're trialling a new resource for SQL beginners and we'd like to know what you think.  Read more...
By Additional Articles 2013/07/19 | Source: SQLServerCentral.com | Category: beginner
Rating: |  Discuss |   Briefcase | 1,868 reads

SQL Source Control - Q & A

After a webinar for SQL Source Control, there were a large number of questions left unanswered. All have been listed here, along with answers from the Red Gate development team.  Read more...
By Additional Articles 2010/08/27 | Source: SQLServerCentral.com | Category: red gate software
Rating: |  Discuss |   Briefcase | 3,471 reads

SQL Data Generator

A new tool from Red Gate software that helps you generate realistic test data for testing your SQL Server applications.  Read more...
By Additional Articles 2008/04/17 | Source: SQLServerCentral.com | Category: product reviews
Rating: |  Discuss |   Briefcase | 3,309 reads

SQL Sleep

A new tool announced today for tired DBAs  Read more...
By Additional Articles 2008/04/01 | Source: SQLServerCentral.com | Category: humor
Rating: |  Discuss |   Briefcase | 4,913 reads

SQLBits 2008

After the success of SQLBits 2007, it's back on March 1st in the UK.  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 1,180 reads

Beginning ADO.NET

One of the strengths of Visual Studio .NET is its features for rapid application development, or prototyping. If, for example, you want to develop a Windows form that lets you maintain the data in one table of a database, you can usually do that in 20 minutes or less. This article will show you how.   Read more...
By Additional Articles 2004/04/01 | Source: Other
Rating: (not yet rated) |  Discuss |   Briefcase | 267 reads

Test Your SQL Server Security Skills and Compete with your Friends!

Test to see how much you know about SQL Server security. If you're one of the members to pass the test (72% score or higher), you're entered into a contest to win a copy of AppDetective and one year's worth of support (over $1500 value)! You can only take the test question test once and it is not timed. After the test, you'll be given the answers and why one answer is more correct than another. Questions are randomly chosen from a pool.  Read more...
By Additional Articles 2003/05/22 | Source: SQLServerCentral.com | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 315 reads

Webcast: 0 to Cluster in 60 Minutes-Clustering Windows and SQL Server

In this session we’ll rapidly discuss the MSCS clustering architecture and deploying the system into your environment. We’ll then jump into a demo where we actually cluster a Windows and SQL Server system in under 60 minutes. We’ll discuss the administration tools and best practices on clustering and walk you through completing a cluster and fixing problems along the way. After this session, you should have just enough information to build you own SQL Server that is highly available.  Read more...
By Additional Articles 2003/05/13 | Source: TechNet Blogs
Rating: |  Discuss |   Briefcase | 875 reads

Free Webcast: SQL Server 2000 Security Best Practices

Join SQLServerCentral.com co-founder for this free webcast on SQL Server security best practices. In this session, we will look at how to protect your system from internal and external security factors. We will look at the types of permissions in your database objects, implementing column and row-level security, and protecting yourself from SQL Injection attacks. We'll also cover best practices for basic and advanced protection for your SQL Server system.  Read more...
By Additional Articles 2003/03/27 | Source: TechNet Blogs | Category: best practices
Rating: |  Discuss |   Briefcase | 345 reads

Analyzing and Optimizing T-SQL Query Performance on SQL Server

This white paper discusses the basics of indexes, such as density and selectivity, effects of many versus few indexes, long versus short keys, covering indexes, and how the SQL Server optimizer chooses indexes  Read more...
By Additional Articles 2003/03/14 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 2,171 reads

Analyzing and Optimizing T-SQL Query Performance Part 1

In this series by Quest Software's Kevin Kline, he shows you some tips to performance tuning T-SQL. This was contributed by Quest from their recent webcast. This white paper discusses various T-SQL discovery, optimization and tuning techniques using the SET and DBCC commands.   Read more...
By Additional Articles 2003/03/06 | Source: Quest | Category: performance tuning
Rating: |  Discuss |   Briefcase | 2,599 reads

Freeware : DDL Source Safe Archive Utility

If your shop is even close to the typical Micosoft SQL Server environment there are several people that can (and do!) make changes to the production environment, a change management system is in place, that change management system uses Source Safe to store database scripts, and what's in Source Safe does not match what's on the SQL Server. This utility by Bill Wunder will archive your SQL scripts and DDL into Source Safe easily and efficiently. All for the price of $0 (yes, free!).  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 258 reads

Free Utility : EnforcePass

These sets of scripts will add minimum password enforcement when a login is created or its password changes.  Read more...
By Additional Articles 2003/02/14 | Source: SQLServerCentral.com | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 90 reads

Freeware: Terminator Opens Gigabyte Files Easily

Ever tried to open 1 Gig ASCII file with Notepad? WordPad? Do you remember ASCII codes of Tab and Carriage Return? Enter Terminator; huge ASCII file viewer and BCP helper. Terminator reads top 10 (and more if asked) records of ASCII file of any size. It detects record terminators and calculates current cursor position (field offset) and length of selected area (field length). Best of all, it's free!  Read more...
By Additional Articles 2003/01/29 | Source: SQLServerCentral.com | Category: dts
Rating: (not yet rated) |  Discuss |   Briefcase | 99 reads

Freeware SQLExecMS Updated

Laplas Soft has updated its ever popular freeware SQLExecMS. SQLExecMS makes a DBAs and developers life so much easier by building in a number of common untilites. You can download it free if you're a SQLServerCentral.com member!   Read more...
By Additional Articles 2002/10/04 | Source: SQLServerCentral.com | Category: news
Rating: (not yet rated) |  Discuss |   Briefcase | 130 reads

Migrating from Oracle to SQL Server

Are you migrating your database and applications from Oracle to SQL Server and having trouble converting your code from PL/SQL to T-SQL? Then this article might help, though it doesn't cover all aspects. It provides you with answers to most commonly asked migration relasted questions. You will also find links to additional resources and books.   Read more...
By Additional Articles 2002/10/02 | Source: Vasyn MVP site | Category: dts
Rating: (not yet rated) |  Discuss |   Briefcase | 378 reads
   Items 1 to 20 of 49    Older >>