Using Object Typed Variables in SSIS
Note: This will be the first post in a short series on using Object typed variables in SQL Server Integration...
2013-03-04
1,673 reads
Making sure your Triggers fire when they should
As some of you may be aware, triggers are not my favourite thing in the world but like most things,...
2013-03-04
1,089 reads
SQL Server – How to Rename Table/Column in SQL Server
To rename an object in SQL Server you can use sp_rename system stored procedure or you can do this via...
2013-03-04
2,032 reads
Virtualising your SQL Server?
Having just completed the latest revision of Learning Tree's SQL Server Virtualisation and consolidation course I thought I'd share with...
2013-03-04
677 reads
Introduction to the SQL BCP Utility
SQL Server BCP is a command line utility that bulk copies data between instances of SQL Server and data files. ...
2013-03-04
23,549 reads
SQL Server 2012 Diagnostic Information Queries (March 2013)
Here is the March 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-03-04
1,075 reads
List all Objects and Indexes per Filegroup / Partition
Today, I received a call from friend asking how he can find out which database object belongs to which filegroup.
Well...
2013-03-03
1,675 reads
Baton Rouge SQL Server User Group
Wednesday March 13th 2013, I have the pleasure in presenting to the local SQL Server User group in Baton Rouge,...
2013-03-03
713 reads
Shorten Your PowerShell Prompt
Recently, I’ve been getting very annoyed by the length of the default PowerShell prompt. Most of my work starts in my Documents folder, so with the default prompt, I’m...
2013-03-03
30 reads
FileTable: SQL Server 2012's little gasp-maker
When was the last time you looked at a SQL Server new feature list and said, “Ohhh, WOW!”? Was it...
2013-03-02
1,824 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Absolute and Relative References
Comments posted to this topic are about the item Absolute and Relative References
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Reserved Words I
Comments posted to this topic are about the item Reserved Words I