Recovering Data and Transactions
Recently I wrote about the disaster recovery issue recently at SQLServerCentral. Someone sent me a note asking why I didn’t...
2010-03-03
389 reads
Blog Posts
SQLSaturday #44!
Andrew Karcher and Marlon Ribunal are heading up SQLSaturday #44 scheduled for April 24, 2010 at Golden West College in...
2010-03-03
336 reads
Using the OUTPUT clause to retrieve new identity values from SQL Server 2008
Microsoft has a new KB article outlining issues with using SCOPE_IDENTITY and @@IDENTITY to retrieve values inserted into an identity...
2010-03-03
2,735 reads
Kindle for the Blackberry
Saw the announcement by accident while doing some browsing on Amazon. Thought I’d try it out just to see. Download...
2010-03-02
228 reads
Mitigating Consulting Risks
In my last post on consulting, Isn’t Consulting Risky?, I contended that in many respects, when done with sufficient forethought...
2010-03-02
1,206 reads
My First SQL Lunch
SQL Lunch has been a great resource for a while now, delivering lunchtime presentations. I was recently asked to be...
2010-03-02
345 reads
Personal "Failure" Is Just a Result
I'm reading a book by two teens called Do Hard Things. It's a book which represents a rejection of the...
2010-03-02
978 reads
SQL Server - MVP Deep Dives
I got my copy of MVP deep dives earlier this month and have been making good progress in reading some...
2010-03-02
862 reads
Using Database Transactions across multiple SSIS Tasks
If you experiment at all with transactions that are built into SSIS you will discover that they are highly flawed. ...
2010-03-02
2,595 reads
Using Excel 2007 in SSIS 2005
Many companies are not in a rush to upgrade their SQL Servers because of the enormous cost to upgrade. This...
2010-03-02
1,037 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