Register Log in

SQL Server

Articles tagged SQL Server

SQL Server Performance Testing

When faced with two viable solutions to a badly compromised database design, one using clustered indexes and the other compound primary keys, Grant Fritchey took...

2 min read

SQL Server Full Text Search Language Features

SQL Full-text Search (SQL FTS) is an optional component of SQL Server 7 and later, which allows fast and efficient querying when you have large...

24 min read

Database Geek of the Week – Glenn Johnson

Meet Glenn Johnson; he runs Glenn Johnson Technical Training and has just written "Programming Microsoft ADO.NET Applications - Advanced Topics".…

13 min read
Learn SQL Server
in Learn SQL Server

SQL Server and .NET Training and Career Development (part 2)

In Part I of this series, I discussed the role and value of conferences in the career development of SQL Server and .NET developers. In...

15 min read

Database Geek of the Week – Tom Moreau

"In grad school, I had a temporary assignment as director of the undergrad labs, where I had to manage the grades of 800 students. My...

13 min read
Learn SQL Server
in Learn SQL Server

SQL Server and .NET Training and Career Development

A number of years ago, I wrote a blog entry entitled "Who is Responsible for your Career?". It was perhaps the second most popular post...

15 min read

Database Geek of the Week – Michael Rys

Dr. Michael Rys is the program manager for the SQL Server Engine Team at Microsoft, represents Microsoft on the W3C XQuery Working Group and has...

8 min read

Database Geek of the Week: Peter DeBetta

Peter runs a consulting firm that develops data-driven enterprise solutions, he is also a programming instructor for Wintellect and a frequent speaker on SQL Server...

9 min read

Database Geek of the Week: Scott Forsyth

Scott is the director of IT for a premier web hosting company called ORCS Web, and has spent a lot of time working on SQL...

12 min read

Database Geek of the Week: Adam Machanic

Adam is a Microsoft MVP and a Microsoft Certified Professional. He speaks at Code Camps and has just become an independent consultant for SQL Server.…

10 min read

DTS to SSIS Migration

Determining how you will upgrade your DTS packages to SQL Server Integration Services (SSIS) is the first step in creating a DTS-to-SSIS migration strategy.…

9 min read

Database Geek of the Week – Damian Mehers

Damian Mehers created a tool called PromptSQL which brings Intellisense into the SQL Server world. …

5 min read

Database Geek of the Week – Linchi Shea

Linchi works at a major Wall Street firm and is responsible for SQL Server product engineering. He is a Microsoft MVP for SQL Server. …

11 min read

Database Geek of the Week: Itzik Ben-Gan

Itzik Ben-Gan is a writer and mentor, he writes a monthly column for SQL Server Magazine and co-authored Advanced Transact-SQL for SQL Server 2000.…

12 min read

Schema and metadata retrieval using ADO.NET

How to obtain different types of information from your SQL Server 2000 database using ADO.NET 2.0, part of VS.NET 2005 and .NET 2.0. …

7 min read

Geek of the Week – Wally McClure

In addition to being a Microsoft MVP, Wally is an ASP Insider and one of the authors of a new book from Wrox called Professional...

12 min read

Performance tuning tips for database developers

Performance tuning is not easy and there aren't any silver bullets, but you can go a surprisingly long way with a few basic guidelines. …

4 min read

SQL Server Central Interview

Steve Jones interviews Red Gate Software's Simon Galbraith and discusses Simon's current views on the industry.…

1 min read

Database Geek of the Week – Hilary Cotter

An interview with Hilary Cotter, a specialist in SQL Server full-text search and replication.…

8 min read

Geek of the Week – Euan Garden

Euan Garden is a Microsoft group program manager for SQL Server, prior to that he spent four years as the manager of Microsoft's SQL Server...

10 min read