Additional Articles

All authors

External Article

Even More SQL Server Features that Time Forgot

SQL Server works well, and Microsoft does everything it can to keep it relevant and competitive: As with everything in real life, it doesn't don't always get it completely right, and Rob Sheldon continues his quest through the jungle of past features to rediscover and explore the ones that time forgot. Here, he comes across Lightweight Pooling, XML Indexes, Stretch Databases, SQL Variants, Transaction Savepoints and In-Memory OLTP.

2017-12-01

5,018 reads

External Article

Simple SQL: Handling Location Datatypes

How do you record locations in SQL? Most relational database systems support spatial and geographical data, generally using the round-earth system based on the SQL specification of the Open Geospatial Consortium (OGC). However, this is not the only approach, as Joe Celko explains.

2017-11-29

2,871 reads

External Article

More SQL Server Features that Time Forgot

SQL Server produces some great features, but it would be impossible to get them spot-on target every time. We are now quietly advised to use caution about using some of them, such as AutoShrink or the Index Advisor. Others, like the database diagramming tool, almost seem to have been quietly abandoned. Robert Sheldon investigates.

2017-11-21

4,678 reads

External Article

Questions About RDS SQL Server That You Were Too Shy to Ask

There are a number of different ways that you can host SQL Server. RDS SQL Server, for example, uses SQL Server within AWS as a simple database service, much like a more versatile alternative to MySQL. Obviously, it is a compromise, in that you lose many of the extras beyond the database. Laerte Junior answers those questions about RDS that people seem to assume you know the answers to, but which you may be too shy to ask.

2017-11-17

3,241 reads

All authors

Blogs

Github Copilot in SSMS can include data in its memory, simple prompt injections ahead

By

SQL Server Management Studio (SSMS) has recently added support for Github Copilot. This is...

Advice I Like: Failure

By

If it fails where you thought it would fail that is not a failure....

Logged in as a member of an Azure AD Group Error while Deploying DACPAC

By

Quite a long title for a short blog post ??While deploying a DACPAC (from...

Read the latest Blogs

Forums

Don't Create Workslop

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Don't Create Workslop

What is the original database name?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What is the original database...

The DBScan algorithm tutorial

By Daniel Calbimonte

Comments posted to this topic are about the item The DBScan algorithm tutorial

Visit the forum

Question of the Day

What is the original database name?

What is returned when this code is run? 

SELECT ORIGINAL_DB_NAME()

See possible answers