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
Glenn Berry
Rocky Mountain Tech Trifecta Impressions
I attended and presented at the Rocky Mountain Tech Trifecta yesterday, where I had a very nice time. Julie Yack...
2010-02-28
1,484 reads
Weekly Electrical Usage from Google PowerMeter
Since I like to measure and monitor things (maybe that is why I am a DBA), and I care about...
2010-02-28
1,568 reads
Dr. DMV Script for Rocky Mountain Tech Trifecta
Here is the script that has the diagnostic queries that I will be using during my presentation at the Rocky...
2010-02-26
2,769 reads
Upcoming Speaking Event Schedule
I have a fairly busy schedule of upcoming speaking events (especially for someone with a full-time day job).
I will be...
2010-02-24
919 reads
Experiments with Data Compression in SQL Server 2008
Data compression is an Enterprise Edition only feature that was added in SQL Server 2008. It allows you to use...
2010-02-22
2,113 reads
Power Plans and Windows Server 2008 R2
After seeing an interesting blog post on AnandTech IT last week that showed slower query response time in x64 SQL...
2010-02-22
3,442 reads
New iSCSI Performance Benchmark from Microsoft and Intel
The Windows Server Division blog has a post up trumpeting a very impressive iSCSI benchmarking result achieved with Intel hardware...
2010-02-21
933 reads
Playing With SQL Azure Data Synch
Microsoft has provided a free tool that allows you to easily create a SQL Azure database, and then synchronize the...
2010-02-19
1,567 reads
SQL Azure Database Service Update 1 Released on February 17
Microsoft’s David Robinson has announced on the SQL Azure Team Blog that they have released Service Update 1 for SQL...
2010-02-19
522 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Having a Little Fun at SQL Server Central
Comments posted to this topic are about the item Having a Little Fun at...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers