SQL in the City, US Tour 2013, Recap
Red Gate visited three cities this year with our SQL in the City event; Pasadena, Atlanta and Charlotte. I just...
2013-10-22
837 reads
Blog Posts
SQL Server Configuration Manager (sqlserverManager11.msc) Hidden after Windows 8.1 Upgrade
You may have noticed, like I did, that after upgrading-in-place from Windows 8 Enterprise to Windows 8.1 Enterprise, my local...
2013-10-22
7,257 reads
Why I’m Excited About Hekaton
I recently readMicrosoft’s research paper on Hekaton, the new in-memory database engine in SQL Server 2014. When I first heard...
2013-10-22
2,339 reads
Windows 8.1 Upgrade Deletes VirtualBox Host-Only Network Adapter
Windows 8.1 was released to the Windows Store last week and aside from having to download the same 3.9 GB...
2013-10-22
1,198 reads
Last Weeks Top “Reading” Links #54
Monday morning and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...
2013-10-21
864 reads
MSDB– cleanup is necessary
Recently I have been asked to work on the task which is to reduce the size of MSDB database. The...
2013-10-21
971 reads
No, Simple Mode Doesn’t Disable The Transaction Log
If you’ve spent any time with me in person, trading war stories, you’ve likely heard my rant about the consultant...
2013-10-21
6,260 reads
PASS Summit 2013 and SQL Saturday Charlotte in Review
I love reading the many blogs posts that pour in following a PASS Summit. I think it is fun to...
2013-10-21
766 reads
PASS Summit 2013-Almost Final Thoughts
I’m home in Orlando, reveling in not being jet lagged for once. A great traveler I am not. I was...
2013-10-21
651 reads
Presentation Slides for Building an Effective Data Warehouse Architecture
Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” at the PASS Summit 2013. The abstract is below. It...
2013-10-21
766 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