Kathi Kellenberger

Kathi Kellenberger is a Sr. Consultant with Pragmatic Works. She is an author, speaker and trainer.
  • Interests: Walking, running, grandchildren!

SQLServerCentral Article

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.

4.18 (28)

2019-05-23 (first published: )

119,004 reads

SQLServerCentral Article

So Many Choices with SQL Server

There was a day when you didn’t have many decisions to make about a new SQL Server instance. You had to choose from a few editions and two licensing models: per proc or server cal. It wasn’t long ago that SQL Server would almost always be installed on a physical server on premises, and the […]

2018-03-26

67 reads

SQLServerCentral Article

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.

5 (1)

2008-02-07 (first published: )

7,821 reads

SQLServerCentral Article

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.

4.33 (6)

2008-01-01 (first published: )

7,281 reads

SQLServerCentral Article

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

5 (1)

2007-10-02 (first published: )

44,260 reads

Blogs

SQL Server In Place Upgrades

By

Good morning dear blog reader. Today’s episode is fresh from a great weekend with...

Daily Coping 27 Sep 2022

By

Today’s coping tip is take your time. Make space to just breathe and be...

Running SQL Server in Windows Subsystem for Linux (WSL)

By

I previously wrote a post on how to convert a SQL Server Docker image...

Read the latest Blogs

Forums

Why does antivirus stops I/O and SQL sees it as a full backup, during AV check

By peter2501

Hello, I have noticed that some AV's do freeze disk I/O to the databases...

Validation status "VS_ISBROKEN" is SSIS Package

By christi1711

Hi all, I have an issue with one job in SSMS which uses some...

customers classification based on the orders placed between two dates

By Zond Sita

Good Morning, I have the two tables customers (joined) and their orders (dateoforder- record...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers