TechTalk: Kimberly L. Tripp on Developing for SQL Server

Kimberly L. Tripp talks about indexing best practices and what developers should know about SQL Server management. She also discusses stored procedure and parameterized queries caching, the new availability features in SQL Server 2005, and the SQL Server CLR.

Database Geek of the Week - Bob Beauchemin

Bob Beauchemin is a developer who not only writes code and develops databases, but also teaches other developers to create applications and databases, often using the latest Microsoft technologies.

Bob has more than 25 years of experience working with IBM mainframes and Unix boxes, as well as Windows-based PCs. He has taught a number of database courses for DevelopMentor, a hands-on training company for experienced developers, and has given instruction on writing .NET web services and creating applications and components using C#.

Featured Interview with Gert Drapers from Microsoft

An interview with Gert Drapers, SQL Server MVP and valuable SQL Server contributor.

An interview with Ken Henderson

I have never met Ken Henderson, but I have followed his career, read his books, and even reviewed one or two of them for Dr. Dobb’s Journal. When I first saw Ken’s The Guru’s Guide to Transact SQL I almost did not pick it up. As a general rule, I don’t pick up the guru’s guide to anything. I’m glad I overcame this, since the book is little short of amazing.

Ken surprised me again with his latest book, The Guru’s Guide to SQL Server Architecture and Internals . About 400 pages into it, I was impressed by the introduction to what is involved in creating a server-based application, but wondered about its inclusion in a SQL Server book. The next 400 pages made it clear that understanding how servers work on Windows is critical to understanding the implications of how SQL Server runs.

Simon Says

Most of us have probably worked with some third party tool at some point in our SQL Server career. But how many tools have been written by a rocket scientist? Steve Jones had a chance to interview Red Gate Software's Simon Galbraith about a variety of topics. An interesting look at the software world through Simon's eyes.

An Interview with Idera CEO, Rick Pleczko

I was talking with the people over at Idera a few weeks ago and they mentioned that their CEO would be happy to give us a few minutes of his time. So I took them up on the offer and built a list of questions about Idera and SQL Server 2005. Take a moment to learn about the vendor view of the world and the impending release of SQL Server 2005.

Web UI Standards

THis nothing to with databases. Does anyone know a site where I can get the Web UI Standards.

RE: many to many query question

Wise you are, Master Yoda! In mysql, I used: ALTER TABLE `artistsProducts` DROP `artistProductID` ALTER TABLE `artistsProducts` ADD PRIMARY KEY (artistID,productID) And viola! That is now my primary key. Thank you very much! I search high and low on the web, but couldn't find answers, and here I got lots of help. Cheers! While when […]

RE: Oracle to SQL Server Migration

It's the syscomments table.  A bit confusing I know because "comments" in oracle are documentary, but in sql the TEXT column of syscomments provides the text of the stored procedure, function or view.Documentation in SQL Server is often (if at all) provided through the definition and use of extended properties.

RE: Problems with INSERT..EXEC to Linked Sybase server

Server: Msg 7391, Level 16, State 1, Line 2 The operation could not be performed because the OLE DB provider 'MSDASQL' was unable to begin a distributed transaction. I'm using the ODBC driver for Sybase, the system is 11.9.2. I saw somewhere on Google that there is an OLEDB driver available for Sybase system 12, […]