Performance Data Gathering
As a DBA, one of the things I struggled with was gathering all my important system information in one place,...
2009-10-09
769 reads
Allen White
- Interests: Running, Theatre, Flying, SQL Server
[Tagged] Anatomy of a Geek
I got tagged by my buddy Michael Coles, aka Sergeant SQL to talk about how I "became" a geek. (I...
2009-10-05
345 reads
ADO.NET in PowerShell
I've had to rework some logic for gathering database information in my serverstatus.ps1 script, because SMO doesn't exactly do things...
2009-09-22
731 reads
Browse and Script
One of the cool features of the SQL Server PowerShell snapins is the the ability to browse SQL Server as...
2009-09-16
425 reads
Use the Best Tool for the Task - Part 2
Yesterday I posted about how Transact-SQL was better suited than SMO for gathering details about database files for a database...
2009-09-03
386 reads
Use the Best Tool for the Task
Last February I wrote an article for Simple-Talk called Let PowerShell do an Inventory of your Servers . This script was...
2009-09-02
353 reads
24 Hours of PASS Tonight
For those of you who may have missed it, the 24 Hours of PASS conference starts tonight at 8pm EDT!...
2009-09-01
418 reads
A Couple of Invoke-SQLCMD Issues
In working on a PowerShell script to load data into SQL Server, I decided to use the Invoke-SQLCMD cmdlet included...
2009-08-14
619 reads
User Group Presentation: Essential Database Management - Top Ten Recommendations
In the August 13th 2009 meeting of the Ohio North SQL Server Users Group (ONSSUG), Paul Randal and his wife...
2009-08-07
325 reads
The Basic Truths about Data
In reviewing database development best practices recently I'm reminded of an attitude I've found prevalent in many development shops, that...
2009-08-03
391 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...