Querying Oracle from Powershell Part 1
In this two part blog post we will demonstrate how to query an Oracle database from Powershell. Before we can...
Querying Oracle from Powershell Part 2
In part one we installed and configured the Oracle client software, in this post we will query an Oracle database...
Using The Data Mining Query Task in SSIS
The Data Mining Query Task can be used to run prediction queries based on data mining models built in analysis service.
A SQL Evening in London
Spend an evening with Itzik Ben-Gan, Greg Low, Davide Mauri and Bill Vaughn in London on March 16th. Come attend if you can.
Fixing DBCC CHECKDB Msg 8992 Errors
Returning author Wayne Sheffield recently had some database corruption - read about how it was fixed.
Usage Based Pricing
Software pricing is a controversial topic, but Steve Jones found an article saying many enterprises would prefer usage based pricing. Do you think it's better?
Efficiently Reuse Gaps in an Identity Column
This article will demonstrate an efficient way to reuse gaps in an identity column. Please note that this is something you normally shouldn't be bothered about in a well-designed database or application. However, there are circumstances where you are forced to do this.
How Do You Drive Your DBA Mad?
I’ve written about a few ‘worst practices’ over the years to call attention to some things that are bad (or...
March Question: What is the biggest mistake/problem you have ever found on a SQL Server instance, and how did you fix it?
Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if...
Blogs
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers