What Does The PASS Community Mean To You?
In less than 72 hours I'll be in Charlotte with over 3,000 of my closest SQL Server friends for the...
2013-10-11
706 reads
Blog Posts
Coast to Coast with SQL Saturday
Last month I blogged about the SQL Crazy train making a whistle stop in Providence Rhode Island. A couple of...
2013-10-10
657 reads
Coast to Coast with SQL Saturday
Last month I blogged about the SQL Crazy train making a whistle stop in Providence Rhode Island. A couple of weeks prior to that, you may have read this...
2013-10-10
3 reads
One Down
Yesterday was our first 2013 SQL in the City event in Pasadena, CA. I was excited and nervous, with 3...
2013-10-10
789 reads
PASS Summit 2013
The PASS Summit 2013 is almost here! Check out all the great sessions and speakers. I feel very fortunate to be able to speak...
2013-10-10
630 reads
SQL Server Analysis Services Activity Viewer 2012 1.1 Stable Released
This morning I am happy to announce the release of a stable version of SSAS Activity Viewer 2012. The build number is 1.1.0.0. The new features have been highlighted...
2013-10-10
8 reads
Use TOP instead of SET ROWCOUNT
Both TOP and SET ROWCOUNT are both valid methods of limiting the result sets from a query. They are however...
2013-10-10 (first published: 2013-10-07)
3,974 reads
Checking Backup/Restore progress
Every now and then we all need to perform backup or restore, for large databases when we need to perform...
2013-10-09
611 reads
How to Limit IO Requests with SQL Server 2014 Resource Governor
Resource Governor was introduced in SQL Server 2008 in order to allow us have better control over our system resource...
2013-10-09
2,238 reads
Leveraging LinkedIn to Contribute to the DBA Community & Attract Opportunities with Internationally-Oriented Organisations
LinkedIn has matured over the past decade and I can
sincerely say it is well worth the time setting up your...
2013-10-09
1,257 reads
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