3 Legit Signs It’s Time for Enterprise Edition

Your app is happily humming along on SQL Server Standard Edition. Things are quiet – too quiet. You’re wondering what you’re missing, and whether you should be on SQL Server Enterprise Edition. Here are 3 warning signs to watch out for.

It's The People

Last week the 2024 PASS Data Community Summit conference was held in Seattle. 1,700 of my closest friends got together for a week of learning (well, technically it's a three day conference, but there are two days of pre-conference seminars) and sharing. I'm still exhausted a week later (although, old age and an aggressive travel […]

Creating Views in MongoDB

Like many relational database systems, MongoDB supports the use of views. A view is a read-only object in a MongoDB

AUTO_DROP Statistics

When Companies Fail

The challenge of software pervading all aspects of our lives and inside many products is going to be create an interesting world when companies fail.

Are We Dinosaurs?

Let's talk about the elephant in the room right up front. Yes, I'm old. I remember when Buck Woody was a little tyke on the day the last of the Tyranosaurs died (I'm older than Buck). So, I'm not asking if I'm old. Yes. I'm old. No, I'm asking if that massive meteor strike over […]

The Vast Expansions of Hardware

Today Steve looks back at hardware changes over time.

The PASS Data Community Summit Session Schedule is LIVE!

Join over 170 global data experts offering more than 150 sessions designed for all skill levels. Explore the schedule to plan your days on-site, secure your ticket, and book your travel before prices increase.

EsProc SPL and SQL, Complimentary , But Different Technologies

Have you ever surfed the internet and felt overwhelmed by personalized advertisements that appear to know your every desire? Have you ever been amazed at how accurate some weather forecasts can be? These actions are based on data processing. EsProc SPL and SQL (note, SPL stands for Structured Processing Language and SQL stands for Structured Query Language). SQL is a major language widely encountered and used for data manipulation within relational databases. While EsProc SPL is another effective tool for data processing, especially suited for complex computations and in-memory operations, it is less commonly encountered.

Setup Excel as Front End Application for SQL Server

In this article, we walk through how to set up a simple Excel interface to work with SQL Server data to insert, update, delete, and select data.