Articles

Technical Article

Free Workshop: Microsoft Data Platform Modernisation - London, Sep 24

Are you an ISV and/or commercial software developer using SQL Server? Are you considering how to upgrade your application to take advantage of new SQL Server 2014 and would like to know more about how Microsoft can help your migration and sales/marketing efforts? Register using this invitation key 9ABED3

(1)

You rated this post out of 5. Change rating

2015-09-01

5,194 reads

External Article

Selective Updates with ASP.NET SignalR

Many developers get the misleading perception that ASP.NET SignalR merely helps to build a chat application or provides live updates of news, stock and score tickers. In reality, ASP.NET SignalR has a broader scope. In this article, Dino Esposito covers a few techniques to make selective SignalR updates to pages behind an ASP.NET authentication layer.

2015-09-01

2,801 reads

External Article

Choosing hash distributed table vs. round-robin distributed table in Azure SQL DW Service

Designing databases to use distributed tables effectively will help you to achieve the storage and query processing benefits of the Azure SQL DW Service (SQL DW). In this article, Murshed Zaman explains the various Azure SQL Data Warehouse distributed table types, and offers guidance for choosing the type of distributed table to use and when to use it.

2015-08-31

2,130 reads

External Article

Database Documentation Survey

Documentation often gets left behind in software development, perhaps even more so when it comes to developing the database schema. How do you keep yours up-to-date? Do you even think you should?

2015-08-27 (first published: )

4,698 reads

External Article

Identify SQL Server Database Growth Rates

Unchecked SQL Server database growth can hurt the bottom line of organizations in the form of poor application performance and increased infrastructure costs. In this article, Marios Philippopoulos looks at whether there's an easy way to proactively obtain a recent list of the fastest-growing databases in a SQL Server instance using information captured by default in the database engine.

2015-08-26

3,923 reads

Blogs

How to Find Expensive Queries in Amazon Redshift

By

Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...

The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech

By

If you've been here before, you know this blog is usually about SQL Server,...

Designing a Storage Load Test for SQL Server

By

I’ve been doing storage load tests for SQL Server for a long time, both...

Read the latest Blogs

Forums

A question about how to store the address in the database

By eichnerm

I have an app that has an address field on the customer and the...

SSIS package failing intermittently on last Excel Component

By Reh23

Good Afternoon, I have a Job which "fires" off an SSIS package (that is...

T-SQL in SQL Server 2025: JSON_ARRAYAGG

By Steve Jones - SSC Editor

Comments posted to this topic are about the item T-SQL in SQL Server 2025:...

Visit the forum

Question of the Day

Multiple Sequence Values

How do I easily get the next 12 sequence values from a sequence object?

See possible answers