Intertia
This editorial was originally published on August 22, 2006. Steve Jones looks at the pace of change in companies and notes it ought to be dictated by the business, not IT.
TSQL Challenge 65 - Solving the Running Total Problem
This challenge invites you to solve one of the most common calculation challenges seen in applications that deal with financial -transactions.
Come to the Charleston PASS SQL Server User Group
The Charleston, SC PASS chapter is looking for speakers and new members. Read more and come to the Sept 20 meeting if you are near the area.
Storing Windows Event Viewer Output in a SQL Server table with PowerShell
Laerte Junior was asked for a quick and easy way to save the output from the Get-EventLog cmdlet in a SQL Server table. Luckily, he already knew about Chad Miller's excellent Out-DataTable and Write-DataTable functions, and has laid out everything we need to use them like pros.
Dotted Line Relationships Are Everywhere – Get Good at Them!
Today we have a guest editorial from Andy Warren. Andy talks about the relationships we have at work with our management and how sometimes the indirect reports are hard to deal with.
Are you using Microsoft’s Azure platform?
We are conducting new product research and are keen to speak to people who have any experience (good or bad!) using Microsoft's SQL or Windows Azure. If you're interested and would like to get involved--tell us your frustrations, shape a new product, test-drive betas etc
Statistics on Ascending Columns
It comes as rather a shock to find out that one of the commonest circumstances in an OLTP database, an ascending primary key with most querying on the latest records, can throw the judgement of the Query Optimiser to the extent that perfomance nose-dives. Fabiano Amorim once again dons snorkel and goggles to explore the murky depths of execution plans to find out why.
Cloud Common Sense
Moving to the cloud, or any other type of outsourcing should be done with common sense, as Steve discusses today. That means keeping control of your backups.
Blogs
Creating a Pulsing Conducting Baton - Part 1
By Bert Wagner
Train Wreck The last time I watched a high school band nearly fall apart mid-performance...
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Forums
We Are Eating Our Own Seed Corn
Comments posted to this topic are about the item We Are Eating Our Own...
Before Using AI with Business Data, Read This
Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis...
Designing SQL Server ETL Pipelines That Don't Break at Scale
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
Question of the Day
Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers