Do you need to setup a SQL Server development environment in short order? Are you familiar with the options available? Are they all laborious? Are you facing security and data privacy issues? Do you have sufficient storage? Attend this information-packed session to learn about the best ways to build, manage and protect your sandbox development environment.
This editorial was originally published on Oct 12, 2006, published today as Steve is out today at the PASS Summit. Today Steve talks about the productivity that comes from having multiple monitors.
BI Architect Bill Pearson continues his introduction to the MDX Members functions. In this Level we continue our exploration of the general “family” group with the .LastChild and .FirstSibling functions.
Date manipulation is a common scenario when retrieving or storing data in a SQL Server database. There are several functions that are available and in this tip we look at how to use the DATEADD function.
A task was set before our team to find the first Tuesday after 10 days from a specific date. This article shows how we accomplished that.
Steve Jones talks about the most interesting contest, evah! Brought to you by Red Gate Software.
Why? Because they're the real Masters of the Universe. Red Gate Software is giving DBAs a chance to fly in space. As in, weightless, in orbit, out of the Earth's atmosphere.
SQL is a powerful tool for querying data, and for aggregating it. However, you can't easily use it to draw inferences, to make predictions, or to tease out subtle correlations. To provide ever more sophisticated inferences to businesses, the race is on to combine the power of the relational model with advanced statistical packages. Both IBM and PostGres are ready with solutions. And SQL Server? Hmm...
Steve Jones has a short piece today, about an announcement coming today at 10am PST during the PASS Summit.
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
I'm trying to get this string_agg to put all the 'comments' into one result...
Comments posted to this topic are about the item Vectors in SQL Server 2025
Comments posted to this topic are about the item Odd Sequences
What values are returned from this code?
CREATE SEQUENCE NumericSequence
AS NUMERIC(5,1)
START WITH 1.0
INCREMENT BY 0.1;
GO
SELECT NEXT VALUE FOR NumericSequence
GO
SELECT NEXT VALUE FOR NumericSequence
GO See possible answers