Parsing SQL for Table Names
Visual Studio Team System 2008 Database Edition (VSDB) ships with a .NET class for parsing T-SQL. I’ve previously blogged about...
2010-04-04
2,149 reads
Visual Studio Team System 2008 Database Edition (VSDB) ships with a .NET class for parsing T-SQL. I’ve previously blogged about...
2010-04-04
2,149 reads
After blogging on Live Spaces for a 517 days, I’ve made the difficult decision to move to my own domain...
2010-03-25
644 reads
I was interviewed by Jon (@JonWaltz) and Hal (@Halr9000) in episode 106 of the PowerScripting Podcast. This was my second...
2010-03-25
1,917 reads
After blogging on Live Spaces for a couple of years, I’ve made the difficult decision to move to my own...
2010-03-21
517 reads
SQL Server Powershell Powershell Extensions (SQLPSX) has been updated to version 2.1. The most notable change is the addition of...
2010-03-10
1,916 reads
In this two part blog post we will demonstrate how to query an Oracle database from Powershell. Before we can...
2010-03-04
2,943 reads
In part one we installed and configured the Oracle client software, in this post we will query an Oracle database...
2010-03-04
2,472 reads
In this two part blog post we will demonstrate how to query an Oracle database from Powershell. Before we can...
2010-03-01
3,467 reads
In part one we installed and configured the Oracle client software, in this post we will query an Oracle database...
2010-03-01
3,168 reads
I presented a 30 minute session at Suncoast Technology Forum Tech Fest on Windows Scripting Automation with Powershell: "This session will...
2010-02-26
1,752 reads
Low-code solutions often accelerate development and make tasks accessible to people who can’t or...
By Steve Jones
Often we find out about a problem reported by a customer after the incident...
Let’s face it, most of the time, you probably don’t want your SQL Server...
We've got upwards of 40 SSIS solutions all stored in one GIT repository in...
Comments posted to this topic are about the item Improving the Performance of UPDATE...
Comments posted to this topic are about the item Replacing a Null
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL; SELECT ISNULL(@value, 100.5) AS Result;See possible answers