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,948 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
1,985 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,225 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,879 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,057 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,225 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,523 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,465 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,597 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,417 reads
Blogs
Dynamically Unpivot columns in SQL
By DataOnWheels
Picture this, your data ingestion team has created a table that has the sales...
Friday Basics: RPO and RTO
By Brian Kelley
I did a post last month titled RTO and RPO are myths unless you've...
A New Word: ioia
By Steve Jones
ioia – n.the wish that you could see statistics overlaid on every person you...
Forums
SQL Server Encrypt data into a file, send it and then decrypt
First off, my apologies for what could potentially be a bad title! I am...
Table partitioning best practice
I've inherited a couple of rather large databases from my ex-colleague when I join...
Identifying Customer Buying Pattern in Power BI - Part 2
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
Question of the Day
Finding Marks
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers