Better Than a Business Card?
A few weeks ago I was looking for a few branded items, happened to run across drink coasters at 4imprint....
2009-11-11
583 reads
Blog Posts
IDENTITY Property in SQL Server
IDENTITY PropertySometimes we need a column whose values can uniquely identifying the rows in the table. To achieve this purpose,...
2009-11-11
1,865 reads
Looking Back – PASS Summit 2009 Day 3
I started Wednesday planning on going to the Quest sponsored breakfast (plus presentation about DMVs) but when I bailed when...
2009-11-11
701 reads
PASS Summit 2009 – Fun
I’m not a big party guy, and in fact, more than a few people can attest to the fact that...
2009-11-11
813 reads
Planning a Longer Break Soon
I’m sure you know what I mean when I say that I feel like my ability to task switch and...
2009-11-11
480 reads
Speaking at the .NET User Group meeting
When a SQL Server application is under performing, how can you isolate where the actual problem is? Would more memory...
2009-11-11
289 reads
Troubleshooting SQL Server Database Mirroring Problems with Best Practices: Requirements, and the 64-bit Benefit
As mentioned in previous disaster recovery posts and article, during my current mandate I have been tasked with what will...
2009-11-11
11,982 reads
Using a SSRS Report to run SQL Agent Jobs
Data Warehouse latency is often a complaint I have heard from end users when trying to access data via either...
2009-11-11
6,596 reads
And the Winner is........
DB Audit Challenge #1
And the Winner is….
First, I want to thank everyone that participated in the DB Audit Challenge, and...
2009-11-10
814 reads
Article of the Week – Sanjay Mirsha (Data Compression)
Data Compression was introduced in SQL Server 2008. This feature helps compress data inside the database, thus potentially reducing the...
2009-11-10
722 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