Sean Duffy recently had an unwelcome encounter with Exchange Server Back Pressure, which cut off his message flow due to a lack of space on the server. To make sure it didn’t happen again, he found a way to automatically monitor all his servers from afar, with a little PowerShell magic.
Some of the most important 'Member' functions of MDX are often known as the 'Family Functions'. These are used in queries on multidimensional structures for analysis and reporting, and can refer to relative nodes in the hierarchy in much the same way as in a family tree.
This Friday Steve Jones asks if we should reconsider the way we train developers and other computer professionals. Give us your opinion this week.
To understand how to write SQL code for SQL Server that performs well, it is important to appreciate how the query optimizer works. Ben Nevarez explains the essentials, in a broad sweep through a complex subject, in an article taken from his new book 'Inside the SQL Server Query Optimizer'.
This article will show you how to determine which network port that SQL Server is listening on for connections
Today Steve Jones talks about a way to improve your skills, make yourself more marketable for that next job, and perhaps earn some money.
You need to configure transactional replication for a very large SQL Server database. Instead of running the snapshot agent to initialize the subscriber, in this tip we look at how you can initialize the subscriber from a SQL Server backup.
Steve Jones talks about the idea of an automated DBA and disputes the notion that it will come to pass anytime soon.
The term DDL designates Data Definition Language, which implies an action involving creating data structures. In the context of Analysis Services Execute DDL Task, this is a bit of a misnomer because its capabilities are much more diverse, extending to such areas as backups, restores, deletions, modifications, or processing. This is accomplished by employing Analysis Services Scripting Language (ASSL).
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