Plan for Capacity
It is important that you are monitoring your system to handle the capacity increases as it grows. Steve Jones notes that FourSquare recently had to deal with this.
Writing Nearly Codeless Apps: Part 3
As we continue in this series, see how auditing tables are used to track all changes that are made to the main data tables.
Add Some Spark to Your OData: Creating and Consuming Data Services with Visual Studio and Excel 2010
The Open Data Protocol (OData) is an open REST-ful protocol for exposing and consuming data on the web. Also known as Astoria, ADO.NET Data Services, now officially called WCF Data Services in the .NET Framework. There are also SDKs available for other platforms like JavaScript and PHP.
Powershell is Really Easy… If you know what you’re doing
Sigh… I just spent almost a full work day trying to come up with, what turned out to be a...
Living Moore's Law
eBay has quite a new data center in Utah, replacing all their hardware on a two year cycle. Steve Jones thinks that would be a challenge, and an exciting one at that.
Robyn Page's SQL Server String Manipulation Workbench
String searching and manipulation in SQL Server can be error-prone and tedious...unless you're armed with the techniques described in Robyn's string manipulation workbench, here newly revised with extra material from collaborator Phil Factor
Detective Stories - Changing the Case
How to change your "UPPER" or "lower" case strings to a mixed case
Software Assurance Cuts Back
Software Assurance from Microsoft is losing a benefit and Steve Jones comments.
TSQL Challenge 41 - Extract email addresses from text data
This challenge involves extracting email addresses from a table that contains text data downloaded from various websites.
When Times are Tough, Do You Rise to the Occasion?
Life isn't fair, and things don't always go your way. In fact, most people hit a tough patch sooner or later. When that happens to you, how do you respond?
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