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.
2019-05-23 (first published: 2005-08-08)
119,694 reads
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
81 reads
Kathi Kellenberger wonders what's keeping your business from upgrading.
2017-12-25
64 reads
When I began using LAST_VALUE, the results were not what I expected at all. Read on to learn the secret!
2016-06-03 (first published: 2015-04-14)
26,423 reads
Learn how to use common table expressions to simplify your code. Replace temp tables and correlated subqueries with this cool T-SQL feature.
2009-12-08
15,221 reads
MVP Kathi Kellenberger covers the basics of using T-SQL to modify data in your databases.
2008-09-30
3,711 reads
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.
2008-08-28
4,933 reads
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.
2008-02-07 (first published: 2007-02-15)
8,110 reads
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.
2008-01-01 (first published: 2007-01-29)
7,383 reads
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
2007-10-02 (first published: 2005-02-23)
45,490 reads
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers