SQL Server Learning Opportunities!
There are two big SQL Server learning opportunities I want to remind you about. First, DevTeach/SQLTeach will be held in...
2007-03-09
1,801 reads
Kathi Kellenberger
- Interests: Walking, running, grandchildren!
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.
2007-02-12
156 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.
2007-01-12 (first published: 2005-02-22)
30,848 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.
2007-01-05 (first published: 2005-07-18)
54,929 reads
Phone books and Indexes
On Wednesday I gave a presentation to the St. Louis Visual Basic.Net user group. I really enjoy speaking to this...
2006-12-22
1,408 reads
SET QUOTED_IDENTIFIER
We recently received a script for a modified stored proc from a vendor. My colleague ran the script on the...
2006-12-15
2,577 reads
The Moto Q and Being Proactive
I am a big fan of automating whatever I can and being proactive. The more proactive you can be, the...
2006-12-14
1,518 reads
Joining Tables Part 1
In this video for beginners you'll begin to learn how to write queries that use more than one table using T-SQL. Kathi walks you through common tactics to efficiently pull out data from a normalized system.
2006-12-11
972 reads
Inserting missing rows
I can think of three ways to insert just the missing rows from one table or query into another table. ...
2006-12-06
3,071 reads
Bad weather and Power Outage
After years of mild weather in the St. Louis area, this is the second time we have been hit hard...
2006-12-02
1,339 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Learn From History
Comments posted to this topic are about the item Learn From History
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers