What’s In My Utility Belt? Issue #1
Welcome to the first issue of what I hope will become a monthly series called “What’s In My Utility Belt?”....
2013-10-29
546 reads
Blog Posts
Change in SQL 2012 SSMS grid output behavior
It’s one of those things that always aggravated me but not really enough to complain about. When you run a...
2013-10-28
693 reads
is count(1) faster than count(*)?
Recently I saw a post regarding the count(1) and count(*)
http://www.sqlservercentral.com/articles/T-SQL/102474/
the post said "You know that doing COUNT(*) on a table with...
2013-10-28 (first published: 2013-10-20)
5,779 reads
Last Weeks Top “Reading” Links #55
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-28
1,106 reads
Notes from the Oct 23, 2013 oPASS Meeting
I drove up to Sanford after work on Thursday for the oPASS meeting to see Mark Kromer present Big Data...
2013-10-28
772 reads
Only one month left! Register for the SQL Server Live! Conference in Orlando Through TheSQLPro.com and Receive a $500 Discount
The SQL Server Live! Conference in Orlando is between November 18-22, 2013. There is a discount code provided for those...
2013-10-28
713 reads
Review: SQL Server Transaction Log Management
Book Details:
SQL Server Transaction Log Management
Davis, Tony and Shaw, Gail
Simple Talk Publishing, October 2012.
Free PDF download
Do I Recommend This Book?
Yes,...
2013-10-28
2,894 reads
SQL PASS Summit 2013 – Simply Amazing
This past week I attended my third SQL PASS Summit in Charlotte, North Carolina. All I can say is – WOW....
2013-10-28
812 reads
SQL Saturday in Verona!
This year I will speak at PASSSQL Saturday in Verona with a session based on database and source control management.
“PASS SQLSaturday’s...
2013-10-28
328 reads
IT Pro Camp Tampa 2013
This year I was honored to sponsor and speak at IT Pro Camp Tampa 2013. Like always, it is a...
2013-10-27
888 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