Database and Disk Size - PowerShell Script
Every time we do a capacity analysis we need to analyse the database size (free and used) and the disk...
2012-08-14
6,047 reads
Drive Size - PowerShell Script
The below script is used to find the disk size for a set of servers,
## Script to Find List of...
2012-08-14
2,011 reads
Troubleshooting Performance - Top CPU Queries
Today I came accross white paper "Troubleshooting Performance Problems in SQL Server" by Sunil Agarwal, Boris Baryshnikov, Tom Davidson, Keith...
2012-08-14
1,238 reads
Find AD user detail - PowerShell Script
I developed the below script to find the details of a AD user and the AD groups he is associated...
2012-08-13
7,919 reads
Find Members of AD Group - PowerShell Script
This is one of the powershell script I have been using quite regularly from the day I developed. Most of SQL...
2012-08-13
2,164 reads
Forcing network protocol to connect SQL server
Whenever there is a network issue or a SQL server browser issue we might need to connect SQL server in different...
2012-08-09
1,245 reads
Service pack Native Client, SQL XML4 and VSSWriter failed
One of my client accidentally executed a 32 bit service pack on a 64 bit SQL Server, the service Pack...
2012-08-09
1,548 reads
SSIS: Transfer SQL Server Object using SMO
we often face a situation to move SQL server object beween servers or databases, when you have constant table list...
2012-08-08
5,583 reads
Blocking in SQL Server by SPID -2 (Orphan distributed transactions)
Blocking in in SQL Server by SPID -2 happens due to Orphan DTC transaction, for instance whenever a data source...
2012-08-06
5,762 reads
Rollback TRUNCATE TABLE statement
Whenever I ask a SQL candidate in an interview the difference between DELETE and TRUNCATE TABLE, the first answer I...
2012-08-06
2,442 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