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)
118,959 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
67 reads
Kathi Kellenberger wonders what's keeping your business from upgrading.
2017-12-25
48 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)
25,763 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,047 reads
MVP Kathi Kellenberger covers the basics of using T-SQL to modify data in your databases.
2008-09-30
3,695 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,912 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)
7,795 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,250 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)
43,972 reads
Data analysis is all about wrangling massive datasets. To do that efficiently, you need...
By Rob Sewell
Make it easier for your audience to engage with you by connecting your site...
By Rayis Imayev
"Stories are where memories go when they are forgotten" - Doctor Who.(2024-Sep-13) As September quickly...
Comments posted to this topic are about the item New article
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers