Additional Articles


External Article

Cloud Identities versus Federated Identities in Office 365

Identities, the 'accounts' by which Cloud and Web users identify themselves, are tricky to manage, and tiresome for the users. Cloud services such as Office 365 have their main use in large organisations and so there have to be easy ways for system administrators to maintain them. Microsoft provide three alternative strategies; Cloud identities, Synced identities and federated identities. What is the differences between them, and which should you choose?

2014-12-11

8,211 reads

Technical Article

Lead and Lag Functions in SQL Server 2012

Arshad Ali discusses how to use CTE and the ranking function to access or query data from previous or subsequent rows. He also shows you how to leverage the LEAD and LAG analytics functions to achieve the same result without writing a self-join query using CTE and ranking function

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2014-12-10

8,382 reads

External Article

SSIS 2012 Projects: Deployment Configurations and Monitoring

The Project Deployment Model introduced in SSIS 2012 speeds up the deployment of database projects in which there may be hundreds of SSIS packages per project. Not only that, but deployments can be configured differently for each environments such as test and staging, and there are now ways of monitoring the status and performance of packages and of versioning the SSIS Catalog.

2014-11-26

7,422 reads

Blogs

T-SQL Tuesday #204 – Are blogs still relevant?

By

Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....

A Front Door for the DBA Team – AgentDBA UI

By

AgentDBA began as a command line. That suits one DBA on one server, but...

Cleaning Up Azure MS Defender Billing

By

I have a few Azure subscriptions, which are fairly small and not used that...

Read the latest Blogs

Forums

SQL Server Vector Support II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server Vector Support II

Great Things

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Great Things

Troubleshooting Slow Queries That Already Have an Index

By Imran2629

Comments posted to this topic are about the item Troubleshooting Slow Queries That Already...

Visit the forum

Question of the Day

SQL Server Vector Support II

With regard to SQL Server 2025's Vector support, what is an embedding?

See possible answers