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.
Log shipping and A Control Mechanism
Longtime author Leo Peysakhovich has implemented a log shipping mechanism that can recover from failures and give you control over how it works. Read on if you want to implement your own version of log shipping and have control over all aspects of the process.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Forums
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
SSoL Support on the OS
Comments posted to this topic are about the item SSoL Support on the OS
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers