Featured Blog: SQL Server 2008: Spatial indexes
Paul Randal talks about the new spatial data types and their indexes.
2008-01-23
2,907 reads
Additional Articles
Measure TSQL Statement Performance
Every developer needs to ensure that each TSQL statement is optimized. This article will give you a few different ideas on how to identify slow running queries and provide you with some tips on monitor your query performance while you make iterative changes to each query to try and improve performance.
2008-01-22
4,005 reads
Building Reliable, Asynchronous Database Applications Using Service Broker
Microsoft SQL Server 2005 Service Broker is a new platform for building distributed asynchronous database applications. Including an asynchronous, reliable messaging feature in the SQL Server database makes it possible to build a variety of database applications that were difficult, if not impossible, to build before.
2008-01-21
2,109 reads
New datetime datatypes in SQL Server 2008
Older versions of SQL Server had only one datatype to store both the date and time values. In SQL Server 2008, Microsoft introduces a set of new datatypes that store date and time individually, and both date and time together.
2008-01-21
3,175 reads
SQL Server 2005 Best Practices Analyzer (January 2008) -- Now Available!
An upgrade to the Best Practices Analyzer from Microsoft is now available. Here's a blog post from the SQL CAT team.
2008-01-21
3,617 reads
Accessing Data from a Mobile Application
Data access is an important aspect of developing applications with the Microsoft® .NET Compact Framework for Windows Mobile® devices. By using the existing architecture to send and receive data between your mobile application and your application server, you can pass data with either DataSets, custom objects, or scalar values.
2008-01-18
3,781 reads
CS TechCast 7: Super Sized SQL
A weekly show from a few SQL Server MVPs that looks at a variety of technology items. This episode concentrates on SQL server.
2008-01-18
1,542 reads
Data Integration Solutions for Master Data Management
This white paper describes how application developers can leverage the functionality of Microsoft SQL Server 2005 Integration Services to address the data integration challenges of Master Data Management applications.
2008-01-18
1,821 reads
Server Side Paging using SQL Server 2005
A common activity in applications is to page results or record sets from a database. This is usually done on the client using the client's paging functionality or on the server through a variety of methods. In SQL Server 2000 those server side methods typically used dynamic SQL or nested TOP clauses and weren't very efficient. Using Common Table Expressions in SQL Server 2005 we have a better way to page record sets on the server.
2008-01-17 (first published: 2007-01-25)
4,640 reads
The Data Stewardship Approach to Data Governance: Chapter 1
The definitions of data governance and data stewardship that I use have changed, albeit slightly, over the years of providing data governance and stewardship solutions.
2008-01-17
1,477 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers