I’ve refreshed a test database from prod but now the users can’t access it.
This happens to me all the time. I get a request from a developer to overwrite the test copy of...
2013-10-16 (first published: 2013-10-09)
2,666 reads
Blog Posts
Liveblogging PASS Sumit Day 1 Keynote with Quentin Clark (#SQLPASS #Summit13)
Welcome to the live blog! Have some resources to start: Watch the keynote live here: http://www.passsummit.com #sqlserver Take a look at...
2013-10-16
518 reads
LogReader agent failed
You may get an error on log reader agent failed with following error: Cannot execute as the database principal because...
2013-10-16
830 reads
PASS 2013 Keynotes Live Day 1
Final thoughts Dear Reader. This is a big launch year for Microsoft and we are getting some very cool toys...
2013-10-16
711 reads
PASS Summit 2013 - Day 2 - Highlights Q&A - What Are You Presenting On?
Today, October 16, 2013: PASS DAY2
PASS Summit Day 1……complete……..Great learning, check! Awesome sessions and nuclear networking! You can read my...
2013-10-16
1,127 reads
PASS Summit 2013 – Day 2: The PASS Spirit
This is my second day into the PASS Summit 2013, and the excitement is still rising. My first day was...
2013-10-16
391 reads
PASS Summit 2013 - Highlight Q&A - Where Will You Be?
PASS SQL Summit time, 2013is in full blown progress. Fantastic keynotes and presentations taking place all day long! For those...
2013-10-16
1,440 reads
PASS Summit 2013 Day 1 Keynote
I am liveblogging the keynote from the bloggers table at the PASS Summit again this year. Just keep scrolling.
Watching the...
2013-10-16
798 reads
PASS Summit 2013 Keynote, Day 1
Today is the first full day of the PASS Summit 2013 conference. This year I’m again joining the blogger table...
2013-10-16
1,105 reads
PASS Summit 2013 Report #10 (Dr DeWitt)
I was lucky/thrilled to get to spend a few minutes chatting with Dr. DeWitt this afternoon (and thanks to PASS...
2013-10-16
637 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