Spatial Data in SQL Server has special indexing because it has to perform specialised functions. It is able, for example, to break down an indexed space into a grid hierarchy by using a technique called tessellation. This is a rules-based system that, when you compare a shape to an index, works out how many cells in the the grid hierarchy are touched by that shape , and how deep down the grid hierarchy to search. There is powerful magic in Spatial Indexes as Surenda and Roy explain.

Prevent and Log Certain SQL Server Login Attempts

by Additional Articles

MSSQLTips.com

Logins

Aaron Bertrand presents a more elegant to prevent developers from attempting to log into production databases using application logins (and to log any such attempts).

Don't exaggerate the difficulties of the RDBMS

by Phil Factor

SQLServerCentral.com

Editorial

Phil Factor argues that in learning about relational databases such as SQL Server, we should encourage people to "break a few pots".

Maps in SQL Server Reporting Services

by Adam Aspin

SQLServerCentral.com

Learn how to add maps to your Reporting Services reports with this article from expert Adam Aspin.

Pre-built or Ad Hoc

by Steve Jones

SQLServerCentral.com

Editorial

Steve Jones talks about the ad hoc nature of some NoSQL databases and whether that's something that most users want.

Never Ignore a Sort Warning in SQL Server

by Additional Articles

SimpleTalk

sort

It is always bad news if your SQL queries are having to use the SORT operator. It is worse news if you get a warning that sort operations are spilling onto TempDB. If you have a busy, slow TempDB, then the effect on performance can be awful. You should check your query plans to try to eliminate SORTs and never leave a SORT warning unheeded. Fabiano Amorim shows the range of ways of getting information on what is going on with a query that is doing a SORT and when requests are made for memory.

Five Rules For Successful Conversations With DBAs

by Joshua Feierman

SQLServerCentral.com

As a developer working with SQL Server, you'll need to work with DBAs at one point or another. Here are some easy ways to make those conversations go smoothly.

The Internet of Things: A New World Order?

by Additional Articles

SimpleTalk

Was the marketing hook 'The Internet of Things' conjured up before the technical definition? Are we being persuaded to spend money on fending off yet another fantasy tsunami of data? Already, we have televisions that listen to, and report, your conversations; so are we facing the Science Fiction future of gadgets that report where you go, who you visit and what medications you take? As Robert Sheldon says; "It's big, almost too big to get your arms around".

Cardinality Estimator – What’s new in SQL Server 2014

by Alessandro Mortola

SQLServerCentral.com

Cardinality Estimator

SQL Server 2014 has introduced a rebuilt Cardinality Estimator (CE) with new algorithms. Which are the biggest differences between the new CE and the previous one? Which one works better? Read more to find out.

Creating a multi-option parameter report for SQL Server Reporting Services

by Additional Articles

MSSQLTips.com

Reporting Services (SSRS)

If you have a reporting requirement where users want to enter report parameters by either selecting values from a dropdown list or entering To and From range values, Ghanesh Prasad explains how to accomplish this in a Reporting Services report?.

SQL Server Spatial Indexes

Prevent and Log Certain SQL Server Login Attempts

Don't exaggerate the difficulties of the RDBMS

Maps in SQL Server Reporting Services

Pre-built or Ad Hoc

Never Ignore a Sort Warning in SQL Server

Five Rules For Successful Conversations With DBAs

The Internet of Things: A New World Order?

Cardinality Estimator – What’s new in SQL Server 2014

Creating a multi-option parameter report for SQL Server Reporting Services

Blogs

A Career of Memories

Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead

Microsoft Build 2026 announcements

Forums

Changes, Happiness, and a Few Tears

BCP on Linux

You Probably Don't Need a Vector Database

Question of the Day

BCP on Linux