SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Kathi Kellenberger

SQLServerCentral.com profile

   Items 1 to 20 of 26    Older >>
 

How do the Experts Become Experts?

How does one become better at some endeavor?  Read more...
By Kathi Kellenberger 2018/01/29 | Source: SQLServerCentral.com | Category: editorials
Rating: (not yet rated) |  Discuss |   Briefcase | 43 reads

Why Haven’t You Upgraded SQL Server?

Kathi Kellenberger wonders what's keeping your business from upgrading.  Read more...
By Kathi Kellenberger 2017/12/25 | Source: SQLServerCentral.com
Rating: (not yet rated) |  Discuss |   Briefcase | 42 reads

Using LAST_VALUE

When I began using LAST_VALUE, the results were not what I expected at all. Read on to learn the secret!  Read more...
By Kathi Kellenberger 2016/06/03 (first published: 2015/04/14) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 23,122 reads

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,787 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,688 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,898 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 | 142 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,662 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,538 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,812 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,568 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,823 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,254 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,481 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,544 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 | 17,059 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,270 reads
   Items 1 to 20 of 26    Older >>