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
5,945 reads
Every time we do a capacity analysis we need to analyse the database size (free and used) and the disk...
2012-08-14
5,945 reads
The below script is used to find the disk size for a set of servers,
## Script to Find List of...
2012-08-14
1,985 reads
Today I came accross white paper "Troubleshooting Performance Problems in SQL Server" by Sunil Agarwal, Boris Baryshnikov, Tom Davidson, Keith...
2012-08-14
1,225 reads
I developed the below script to find the details of a AD user and the AD groups he is associated...
2012-08-13
7,876 reads
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,056 reads
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,223 reads
One of my client accidentally executed a 32 bit service pack on a 64 bit SQL Server, the service Pack...
2012-08-09
1,521 reads
we often face a situation to move SQL server object beween servers or databases, when you have constant table list...
2012-08-08
5,452 reads
Blocking in in SQL Server by SPID -2 happens due to Orphan DTC transaction, for instance whenever a data source...
2012-08-06
5,593 reads
Whenever I ask a SQL candidate in an interview the difference between DELETE and TRUNCATE TABLE, the first answer I...
2012-08-06
2,416 reads
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
Comments posted to this topic are about the item The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers