Concrete Code
When building a new database or system, are you designing concrete code? Should you be? Steve Jones comments on matching your needs with your architecture.
SQL Server Luxembourg User Group Meeting
Our next meeting will be held on Friday 30th April in downtown Luxembourg.
SSIS for Multiple Environments
In this article, Zach Mattson shows us how you can set up SSIS to handle multiple application environments and easily move packages from development to QA to production.
SQLCLR function to return free space for all drives on a server
When looking for impending problems due to lack of disk space it's necessary to know how much space is available on each drive. There have been other tips written about how to do this, but in this tip I show you a way this can be done using SQLCLR.
Financial Data in the Cloud?
Phil Factor believes that there will have to be further compromises between the pioneers of The Cloud and the regulators, before companies feel safe in entrusting their financial data to such an abstract service, seemingly 'remote from sand and iron'.
Optimising Server-Side Paging - Part I
This article by Paul White presents an optimisation for paging through a wide data set.
PASS Virtual Chapters Late April Presentations
To finish up the month of April we’ve got sessions from AppDev and DBA and I’m even including one from PASS on ‘Intro to Speaking At PASS’.
How to Evict a Failed Node and Add it Back to SQL Server 2005 Cluster
Adding and removing nodes in SQL Server Clusters is not so difficult, and instructions on how to do so abound on the internet. However, mismanagement when adding/removing nodes can quickly become a 'gotcha' that wastes time. Bo Chen offers insight into some of those scenarios that are not normally covered in the standard online documents.
Help, my database is corrupt. Now what?
The stuff of nightmares, a corrupt database. However Gail Shaw gives you some advice about how to handle this situation.
Row Oriented Security Using Triggers
Handling security in an application can be a bit cumbersome. R Glen Cooper brings us a database design technique from the real world that can help you.
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...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
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...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers