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

Guest Columnist: Kathi Kellenberger

SQLServerCentral.com profile

   Items 1 to 20 of 20   
 

Introduction to Common Table Expressions

Learn how to use common table expressions to simplify your code. Replace temp tables and correlated subqueries with this cool T-SQL feature.  Read more...
By Kathi Kellenberger 2009/12/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 14,625 reads

Modifying Data - SQL School Video

MVP Kathi Kellenberger covers the basics of using T-SQL to modify data in your databases.  Read more...
By Kathi Kellenberger 2008/09/30 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 3,629 reads

Summarizing Data with Aggregate Queries - SQL School Video

Learn how to summarize the values of your data using aggregate functions such as COUNT(), SUM(), and AVG() from MVP Kathi Kellenberger. Grouping and aggregate filters are covered as well.  Read more...
By Kathi Kellenberger 2008/08/28 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 4,819 reads

Technology: Where have all the women gone?

Longtime author Kathi Kellenberger brings us a guest editorial today on what is happening with women in the technology world.  Read more...
By Kathi Kellenberger 2007/02/12 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 131 reads

A Review of PDF-eXPLODE

Reporting is a huge part of any DBA's job with constant changes and new requests for data that non-technical people can use. And more and more often the format of choice is PDF, which ensures the end result looks the same on many different platforms. Kathi Kellenberger takes a look at a product that can allow end-users to generate PDFs from a database and easily send them to other people.   Read more...
By Kathi Kellenberger 2007/02/15 | Source: SQLServerCentral.com | Category: product reviews
Rating: |  Discuss |   Briefcase | 7,621 reads

Finding Primes

While it's not likely that many of you need to find prime numbers using T-SQL, it is an interesting programming exercise. SQL Server guru Kathi Kellenburger brings us one solution after taking a break over the holidays and reading some popular fiction.   Read more...
By Kathi Kellenberger 2007/01/29 | Source: SQLServerCentral.com | Category: sql puzzles
Rating: |  Discuss |   Briefcase | 6,471 reads

What's new with SSIS?

With the release of SQL Server 2005, there have been many changes in the product, but probably none as dramatic as the changes to the ETL tool. Data Transformation Services has become SQL Server Integration Services, or SSIS. It has been completely redesigned with a whole new paradigm for developing data movements. Kathi Kellenberger brings us a short introduction to this new tool.   Read more...
By Kathi Kellenberger 2006/01/31 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 20,788 reads

Aggregate Queries

They are a basic type of query that every DBA and developer should be able to write, but aggregates are sometimes misunderstood and result in strange behaviors and results. Kathi Kellenberger brings us a tutorial on what aggregate queries are and a few hints on how to become more proficient at writing them.   Read more...
By Kathi Kellenberger 2007/03/16 (first published: 2005/12/19) | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 35,418 reads

SQL Diagnostic Manager Review

SQL Diagnostic Manager from Idera is a great tool for troubleshooting issues with your SQL Server databases. Kathi Kellenberher puts this tool through it's paces and gives you some insight into how it fits in a busy SQL Server environment.   Read more...
By Kathi Kellenberger 2005/11/08 | Source: SQLServerCentral.com | Category: product reviews
Rating: |  Discuss |   Briefcase | 15,738 reads

Using Parameters with Stored Procedures

It seems that SQL Server developers avoid stored procedures whenever possible, especially if they are new to the product. Kathi Kellenberger brings us a basic article that you can give to developers that explains the basics of how you use parameters with ADO.NET, especially output parameters.   Read more...
By Kathi Kellenberger 2008/02/29 (first published: 2005/08/08) | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 118,199 reads

Understanding Object Ownership

In SQL Server 2005, object ownership will have a different meaning, but since most of us work with SQL Server 2000, Kathi Kellenberger has written a good introduction to understanding how object ownership works and why you might want to follow certain practices.   Read more...
By Kathi Kellenberger 2007/01/05 (first published: 2005/07/18) | Source: SQLServerCentral.com | Category: advanced
Rating: |  Discuss |   Briefcase | 51,022 reads

Dynamic Properties

One of the most useful tasks in SQL Server 2000's DTS environment is the Dynamic Properties task. Author Kathi Kellenberger brings us a look at how this task can help you accomplish an unusal import task.   Read more...
By Kathi Kellenberger 2005/06/20 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 14,530 reads

Restoring to a Point In Time

One of the lesser used features of SQL Server 2000, but the capability to restore your databases to a particular point in time can be a valuable skill. Kathi Kellenberger takes a moment to explain how this feature works and how you can use it in your environment.   Read more...
By Kathi Kellenberger 2005/06/14 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 16,996 reads

Turbo for SQL Server

Searching data is an essential part of SQL Server applications, especially text searching. While Full Text Search in SQL Server 2000 works, it lacks some important features that Turbo for SQL Server can handle. Read this review of the product and see if this is a way you can enhance the search functions in your application.   Read more...
By Kathi Kellenberger 2005/06/01 | Source: SQLServerCentral.com | Category: product reviews
Rating: |  Discuss |   Briefcase | 7,259 reads

SQL Backup 3.0

SQL Server 2000 has a rock solid backup process and one that many people have relied upon for years. However with the growth in database sizes and the constant load on many database servers, a third party backup utility is almost required in many environments. Kathi Kellenberger takes a look at Red-Gate Software's SQL Backup 3.0 and how it performs in her environment.   Read more...
By Kathi Kellenberger 2005/04/27 | Source: SQLServerCentral.com | Category: product reviews
Rating: |  Discuss |   Briefcase | 12,369 reads

SQLH2: The Free Health, History and Performance Monitoring Tool

One of the strengths and powers of the SQL Server platform over others is the shear number of things that are available free from Microsoft besides the relational platform. DTS, Reporting Services, SQLAgent, and more are included with the product. One of the newer utilities is SQLH2, a performance monitoring tool that is reviewed here by Kathi Kellenberger.   Read more...
By Kathi Kellenberger 2005/03/28 | Source: SQLServerCentral.com | Category: product reviews
Rating: |  Discuss |   Briefcase | 17,889 reads

Access to SQL Server: Getting Started with Access Projects

SQL Server 2000 and Access databases are two technologies closely linked with the new Access ADP format using SQL Server as the basis for the code. Access Projects are also a way to closely link the two products together and take advantage of each to produce an application very easily. Author Kathi Kellenberger brings us part 3 of her Access series with a look at Access Projects.   Read more...
By Kathi Kellenberger 2005/02/24 | Source: SQLServerCentral.com | Category: access
Rating: |  Discuss |   Briefcase | 9,954 reads

Access to SQL Server: Linking Tables

SQL Server 2000 and Access databases can be configured to work closely together. If you find that the Access storage format is not handling your needs and an upgrade is needed, you need not through away all of your access development. Instead, you can link Access tables to underlying tables in SQL Server and improve your application by using SQL Server as the backend for your Access project. Author Kathi Kellenberger brings us her second articles in an Access series looking at Linking tables to   Read more...
By Kathi Kellenberger 2006/11/17 (first published: 2005/02/23) | Source: SQLServerCentral.com | Category: upgrading
Rating: |  Discuss |   Briefcase | 42,413 reads

Access to SQL Server: The Upsizing Wizard

SQL Server 2000 is the basis for the new Access database storage. However there are still many cases where applications developed on Access are outgrown and need to be moved to SQL Server to support the load. Author Kathi Kellenberger brings us a look at the Upsizing Wizard and how you can move your databases to SQL Server.   Read more...
By Kathi Kellenberger 2007/01/12 (first published: 2005/02/22) | Source: SQLServerCentral.com | Category: upgrading
Rating: |  Discuss |   Briefcase | 30,085 reads

Removing the Builtin Administrators - Some Pitfalls to Avoid

The SQL Server 2000 security model is not the best one of all the RDBMS platforms and requires some work to secure properly. One of the practices that is recommended is removing the builtin/administrators group from accessing the SQL Server. New author Kathi Kellenberger shows us some of the pitfalls she encountered when removing this group from her servers.   Read more...
By Kathi Kellenberger 2007/08/10 (first published: 2005/01/12) | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 29,437 reads
   Items 1 to 20 of 20