5 Things Every DBA Should NOT Do
Earlier in the month I shared with you 10 Things That Every DBA Should Do and so it only seems natural...
Fundamentals of Storage Systems, IO Latency and SQL Server
A Thousand Men Marching Still Only March As Fast As One Man.
la·ten·cy - Computers . the time required to locate the first bit or character in a storage location, expressed as access timeminus word time.
Often when talking to people...
How to reduce MDX code redundancy in SQL Server Analysis Services (SSAS)
To query an Analysis Services cube, MDX is used as the query language. In most business settings, one would find a set of queries that are common across a number of user query requirements. To cater to this, even with a modest size IT team, there is a good chance that the same queries are developed redundantly either within a SSAS MDX script or repetitively in an ad-hoc manner in client applications. In this tip we would look at how to reuse queries without redeveloping them over and over.
Professional Development Week
Last week was Professional Development Week at SQL University. Steve Jones talks about the importance of having a professional development plan and the types of things that you could learn this week.
Will You Become a Master?
Today we have a guest editorial from Andy Warren. There are changes in the Microsoft Certified Master of SQL Server program and many people are considering trying to earn this certification. Today Andy Warren asks if you want to go down that path.
And now for a completely inappropriate use of SQL Server
A while back I wrote up a short introductory overview of Genetic Algorithms. Just for the shear, absolute fun of...
Emailing tempdb Query Results to Paul Randal with PowerShell
I was referred to someone on twitter today who wants to email query results without setting up database mail. I...
Monitoring Transactional Replication – The Distribution Queue
This article looks at the distribution database what information can be obtained for monitoring transactional replication.
SQL Saturday #69 - Philadelphia
SQL Saturday comes back to Philly on Mar 5, 2011. Spread the word and come get a free day of training on SQL Server.
Odd Questions
Interviews can be strange for many reasons, often because interviewers are not well prepared to evaluate candidates. This Friday Steve Jones asks you what weird things you might have encountered in an interview when someone is asking you questions.
Blogs
Monday Monitor Tips: Intelligent Alert Thresholds
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
Forums
String_agg not working as needed
I'm trying to get this string_agg to put all the 'comments' into one result...
Vectors in SQL Server 2025
Comments posted to this topic are about the item Vectors in SQL Server 2025
Odd Sequences
Comments posted to this topic are about the item Odd Sequences
Question of the Day
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