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
730 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
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers