Total Database Information At Your Fingertips Part - II
This article will help to get some basic information from your databases that may help you in different situations.
SQL Server Functions: The Basics
SQL Server's functions are a valuable addition to T-SQL when used wisely. Jeremiah Peshcka provides a complete and comprehensive guide to scalar functions and table-valued functions, and shows how and where they are best used.
Are You Easy To Work With?
Today we have a guest editorial from Andy Warren that looks at the relationships you have with your co-workers.
SQL Server AlwaysOn - Part 2 - Availability Groups Setup
SQL Server has produced some excellent High Availability options, but I was looking for an option that would allow me to access my secondary database without it being read-only or in restoring mode. I need the ability to see transactions occur and query the secondary database.
Survey: Do You Monitor Your Databases?
We're looking to find out more about whether you monitor your databases, and how you do it. If you can spare a moment to complete a short survey, please click here.
Dealing with Incomplete Data - A T-SQL Puzzle 1
Client data received for processing may have invalid records based on processing requirements. Identifying and dealing with bad records in a specific scenario is the object of this article.
Power Tools at Work
This editorial was originally published on Jan 17, 2007. It is being republished as Steve is on vacation. This one deals with data security.
Finding the Source of Your SQL Server Database I/O
There are a number of ways of measuring and identifying I/O-related performance information for your SQL Server database instances.
A simple math expression solver
Ben Kubicek wrote a recursive function that solves simple math expressions in a select statement. Read about this creative use of T-SQL.
Blogs
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...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
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