How Much Pizza and Soda for a User Group Meeting (Why You Should RSVP)?
After a few meetings of oPASS this year the numbers I use are 2 slices of pizza and 2 drinks...
2007-10-29
1,449 reads
Blog Posts
Structuring the Blog Better
For a variety reasons, including personal/family concerns and workload, I've not been able to write as often as I'd like....
2007-10-28
1,466 reads
Alpha Version of SQLPing3 Command Line Available
Noted SQL Server security expert, Chip Andrews, has released an alpha version of a command-line version of SQLPing3. You can...
2007-10-25
2,308 reads
SQLSaturday Finally Listed in PASS Connector
If you subscribe to the Connector (the main communication email from PASS.org) you should have gotten one yesterday that finally...
2007-10-25
1,398 reads
Steve Jones Finally Reads My Blog!
I've been following Steve's exploits trying to learn the podcasting business and we usually talk about it once a week...
2007-10-25
1,461 reads
Views for Abstraction Posted on SSC
This went up today and there is one great comment about possibly using snapshot isolation as an alternative to the...
2007-10-25
1,355 reads
Untitled Pages in ASPX
If you do any coding in .Net using aspx pages you'll recognize this one. Each page has a title attribute...
2007-10-24
1,472 reads
Be Pithy
I'm tech editing a book, working late as usual, football game on and kids in bed. As I was going...
2007-10-22
1,394 reads
Requiring Columns Over 900 Bytes to Be Unique
Had a friend call me recently to ask about how to do this, had an nvarchar(2000) column that needed to...
2007-10-22
1,450 reads
If Exists (Select 1...) vs If Exists (select * ...)
If exists is a well known way to improve performance because it returns as soon as it matches a single...
2007-10-21
1,836 reads
Blogs
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers