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
790 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
353 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
750 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
448 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
402 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
365 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
431 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
626 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
330 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
401 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers