Next Week, in or out of Charlotte (#sqlpass #Summit13 #SQLHighTea #TooManyHashtags)
Welcome to Tuesday. We hope you enjoy your stay! Edit: We have been informed that today is actually Wednesday. We...
2013-10-09
535 reads
Blog Posts
Speaker of the Month, October 2013
This month I saw several good speakers talking on a variety of topics. Making this choice was hard. I’m really...
2013-10-09 (first published: 2013-10-04)
1,139 reads
Unexpected result with the File System Task
Recently I ran across a forum thread where someone encountered an unexpected result when creating a directory using the File...
2013-10-09
639 reads
Unexpected result with the File System Task
Recently I ran across a forum thread where someone encountered an unexpected result when creating a directory using the File...
2013-10-09
359 reads
Azure Account and Spending Limits
If you’ve been working with Azure for a while you probably signed up before they had the ability to create...
2013-10-08
807 reads
Benchmark SQL Server Wait Statistics
One of the secret weapons in performance tuning with SQL Server is understanding wait statistics. Every time a process (spid)...
2013-10-08
1,968 reads
Data Warehouse Maturity Model
I have talked about the Business Intelligence Maturity Model (see Business Intelligence Maturity Assessment), but I wanted to dig further into...
2013-10-08
2,209 reads
Generating a unique identifier outside of SQL and persisting it…
I’ve been thinking about a question from a application developer regarding generating a unique identifier outside of SQL and persisting...
2013-10-08 (first published: 2013-10-03)
2,632 reads
New Job Checklist
I started a new job a month ago, but didn’t want to just figure things out as they came to...
2013-10-08
840 reads
Oh, The Free Stuff!
Ah, Shwag I’ve been doing the whole conference thing for a while. Not as long as some but quite a while. Along the way I’ve collected quite a...
2013-10-08
6 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