Articles

External Article

Database Sharding: Strategies for Seamless Scaling and Performance Optimization

Companies of all sizes and across industries are struggling to cope with an explosion of data never before seen in the short history of computing. As applications reach new levels of sophistication and become deeply interconnected, these companies find themselves increasingly overworked, overheated, and at their wits’ end, desperately trying to squeeze just a bit more performance and availability out of their aging database architectures.

2024-10-11

Technical Article

PASS Summit 2025 Dates

You heard it here first, PASS Data Community Summit will return to Seattle next year! Save the date, as PASS Summit will take place in person at Summit, Seattle Convention Center, from November 17-21, 2025!

2024-10-11

Technical Article

Microsoft to Headline PASS Data Summit 2024 as Sapphire Sponsor

Join Microsoft at PASS Summit 2024 to explore the latest database innovations and how Azure solutions enhance app performance, security, and scalability in the AI era. Learn new SQL database capabilities, connect with Microsoft engineering leaders, and attend expert-led sessions on topics from database migration to modernization.

You rated this post out of 5. Change rating

2024-10-09

78 reads

Technical Article

Introducing the PASS Data Community Summit Keynotes from Microsoft, Redgate, and a Community Star

After meeting the stellar pre-con speakers and exploring the 5 learning pathways at #PASSDataSummit 2024, we’re excited to reveal the keynote lineup. Each day will kick off with inspiring keynotes from Microsoft, Redgate, and a special community-driven session led by industry experts. Don’t miss out on these insightful sessions designed to energize and empower you throughout PASS Summit 2024.

2024-10-07

External Article

Storing and Retrieving the Initialization and Configuration Data for Applications

All developers hit the problem of how and where to store and set their configuration, profile, or initial data. A long time ago, it was generally decided that simple text files containing key/values were best, stored with the application. After all, you are relying on being able to entice busy people to get the permanent settings right for their requirements, folks who are generally not interested in your elegant computer science constructs. Not only that, but the settings must be parsed very quickly and efficiently, otherwise a process that uses the tool will slow to a crawl.

2024-10-04

Blogs

A New Word: Opia

By

opia – n. the ambiguous intensity of eye contact The entry for this says...

Friday Flyway Tips: Searching a Migration

By

This was actually a cool tip I saw internally from one of the product...

Build Recovery into the Design

By

It's like disaster recovery (and business continuity) planning is the end-of-term research paper that...

Read the latest Blogs

Forums

Serverless Gets Faster

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Serverless Gets Faster

sqlclient data provider .net provider connection

By jaango123

I have a task to check the connection managers as part of ssis integration...

How

By cw255

Hi, wondering if someone can help me. We're trying to build an application that...

Visit the forum

Question of the Day

Statistics Histograms

I have a statistics objects with 2 key columns from my tables. How many histograms and their type are stored?

See possible answers