Additional Articles

Intro to Entity Framework with SQL Server

by Additional Articles

MSSQLTips.com

Entity Framework

I'm a DBA and the developers in my organization are starting to use something called the Entity Framework (EF) in their applications. The developers are telling me that with EF you don't use stored procedures, you simply write .NET code to perform all of your data access. When I use the SQL Server Profiler to take a look at what they're doing, all I see is a bunch of dynamic SQL being executed. Naturally I'm a little skeptical of this, so can you help me to understand what is this Entity Framework?

2010-04-14

5,701 reads

Proactive Database Index Creation

by Additional Articles

Database Journal

Indexing

Indexes help your application find your data quickly and provide users with a well performing application, while minimizing server resources. This article discusses indexing guidelines related to join tables and covering indexes.

2010-04-13

3,989 reads

SQL Server Geography Data Type

by Additional Articles

MSSQLTips.com

Spatial Data

We are working on the migration to SQL Server 2008 and have geospatial data that we would like to move over as well. As part of our application we house information on locations across the globe. Which data type should we use?

2010-04-12

3,284 reads

Retrieving Data from an Audit Table

by Additional Articles

SQL Server Performance

Auditing

This article examines the various methods for retrieving data from an Audit table.

2010-04-09

3,419 reads

SQL Server Intellisense VS. Red Gate SQL Prompt

by Additional Articles

SimpleTalk

SQL PROMPT

Fabiano Amorim is hooked on today's Integrated Development Environments with built-in Intellisense, so he looked forward keenly to SQL Server 2008's native intellisense. He was disappointed at how it turned out, so turned instead to SQL Prompt. Fabiano explains why he prefers to SQL Prompt, why he reckons it fits in with the way that database developers work, and goes on to describe some of the features he'd like to see in it

2010-04-09

4,030 reads

SQL Server 2008 Spatial Index Performance

by Additional Articles

MSSQLTips.com

Spatial Data

The institution I work with has decided to migrate their database system to SQL Server 2008. One of the applications uses geospatial data, which consists of millions of rows. I understand that their are indexes that can be used for geospatial data, but have not worked with them. What's the scoop on them?

2010-04-08

4,056 reads

New and Improved Functionality in SSIS 2008

by Additional Articles

Database Journal

Integration Services (SSIS)

While it does not bring revolutionary changes, the release of SQL Server 2008 delivers functionality, scalability, and performance improvements to SQL Server Integration Services (SSIS). Here is a comprehensive listing of new and enhanced features of SSIS with a short description of each.

2010-04-07

4,355 reads

Understanding Dynamic Management Views and Functions in SQL Server 2008

by Additional Articles

MSSQLTips.com

Performance monitoring and optimization is an inseparable part of a DBA's activities. To optimize a poorly performing system/query or to troubleshoot the performance issues you need to know the root cause. Prior to SQL Server 2005, we had several system tables to monitor the state of the system.

2010-04-06

2,169 reads

Celko's SQL Stumper: Eggs in one Basket

by Additional Articles

SimpleTalk

SQL Puzzles

Joe Celko returns with another stumper to celebrate Easter. Unsurprisingly, this involves eggs. More surprising is the nature of the puzzle: This time, the puzzle is one of designing a database rather than a query. DDL as well as the DML.

2010-04-05

2,337 reads

SQL Server Indexed Views

by Additional Articles

Database Journal

Indexed Views

Views can be an effective tool for speeding up your selects and simplifying complex queries. Learn what indexed views are, where you might want to use them, how to create them, and what constraints exist with their use.

2010-04-05

5,000 reads

All authors

Additional Articles

Intro to Entity Framework with SQL Server

Proactive Database Index Creation

SQL Server Geography Data Type

Retrieving Data from an Audit Table

SQL Server Intellisense VS. Red Gate SQL Prompt

SQL Server 2008 Spatial Index Performance

New and Improved Functionality in SSIS 2008

Understanding Dynamic Management Views and Functions in SQL Server 2008

Celko's SQL Stumper: Eggs in one Basket

SQL Server Indexed Views

Blogs

Enterprise AI Operating Rhythm – Top 5 practices for 2026

Resetting on the AI hype train

A New Word: Etherness

Forums

The Max PK Length

My experience using the GitHub Copilot in SSMS 22

The Microsoft SQL Year in Review

Question of the Day

The Max PK Length