Performance Impacts Related to Different Function Types
The July 2010 PASS Performance VC Presentation by Jason Strate on July 6th 12:00 PM EDT (GMT -4).
SSIS Package to Script All SQL Server Jobs to Individual Files
The provided SSIS package contains a single script task that will script all SQL Server 2000/2005/2008 Agent Jobs into individual files.
What if TDE was available in Standard Edition?
Today we have a guest editorial from John Magnabosco that looks at TDE, and the reasons that it ought to be in Standard Edition.
Multi-parameter CLR aggregate in SQL Server 2005
How is it possible to pass multiple parameters to a SQL Server 2005 CLR aggregate?
Should DBAs Be the Protectors of Data?
Brad McGehee wonders whether DBA's should take a more active role in managing their organization's data, even if it means potentially ruffling a few feathers.
Physical Join Operators in SQL Server - Merge Operator
Part II of the Physical Joins series looks at the Merge operator.
Are We Not Testing Enough?
This Friday Steve Jones asks if we are setting the bar high enough when interviewing people and would you want to test more?
There Must Be 15 Ways To Lose Your Cursors… Part 2
Learn to use Where, Claire. Plus a conversion methodology, a test harness and more!
Reporting Services 2008 R2: Geospatial Visualization – Part I
Geospatial Visualization is one of the key new features of SQL Server 2008 R2 Reporting Services. This step-by-step tutorial demonstrates the creation of a Map Report.
Blogs
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...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
query to track time spent on individual tasks in SSIS
Hi everyone I am looking at building a query to determine how much time...
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Hidden Heroes
Comments posted to this topic are about the item Hidden Heroes
Question of the Day
Identities and Sequences I
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers