Introducing PowerShell V2 Remoting for SQL Server
owerShell can be used to for many SQL administrative tasks; this tip walks through how to run T-SQL code and admin tasks on remote servers.
A Matter of Life or Death
Could your job as a data professional result in the death of someone? It's entirely possible this might affect you at some point. Steve Jones talks about why you ought to do your best when setting up security.
Are remote databases fragmented? Let's Defrag.
This article shows an automated reorg/rebuild index for remote servers with notifications for the DBA.
Now you ODBC me now you don't
Phil Factor reflects on Microsoft's "handbrake turn" on OLE DB; Denali's successor will have to have all this plumbing ripped out to replace it with the older ODBC technology. It's a surprising move but makes a lot of sense, given the ubiquity of ODBC drivers for relational data access.
Disk Space Monitoring and Early Warning with PowerShell
Sean Duffy recently had an unwelcome encounter with Exchange Server Back Pressure, which cut off his message flow due to a lack of space on the server. To make sure it didn’t happen again, he found a way to automatically monitor all his servers from afar, with a little PowerShell magic.
Stairway to MDX - Level 6: Member “Family” Functions: .Parent and .Children
Some of the most important 'Member' functions of MDX are often known as the 'Family Functions'. These are used in queries on multidimensional structures for analysis and reporting, and can refer to relative nodes in the hierarchy in much the same way as in a family tree.
The Apprentice
This Friday Steve Jones asks if we should reconsider the way we train developers and other computer professionals. Give us your opinion this week.
The SQL Server Query Optimizer
To understand how to write SQL code for SQL Server that performs well, it is important to appreciate how the query optimizer works. Ben Nevarez explains the essentials, in a broad sweep through a complex subject, in an article taken from his new book 'Inside the SQL Server Query Optimizer'.
Find which port SQL Server is using to establish connections
This article will show you how to determine which network port that SQL Server is listening on for connections
Learning for Profit
Today Steve Jones talks about a way to improve your skills, make yourself more marketable for that next job, and perhaps earn some money.
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