the Surfing DBA...
Home
About
Contact Info
DBA/BI stuff
Azure
Open Source DBs
>
Linux Stuff
Connect to Linux with Powershell
Netezza
MongoDB
>
Connect to Mongo with Powershell
Postgres
MySQL
Powershell
>
DBATools
Import-CSV
Powershell Loops and other Syntax Stuff
Find Windows Administrators on Server
Create ZipFile w\\PS
Powershell Profile and Modules
Change Users Permissions to folder
VMWare PowerCLI
Secure Password File
Powershell Scripts
Execution Policy
Regex
Manage SMB File Shares
BI Stuff
Backup and Restore
SQL Server Architecture
SQL Server MetaData
Performance Troubleshooting
>
SSPI Context Error
Cardinaltiy stuff
Query the SQL Error Log
TempDB Won't Shrink
How to log DeadLocks
What Is Running
Execution Plans
Stuck in Single User Mode
Login failed for user 'xxxx\xxxx'.
My Version Store is huge!!!
Rebuild MSDB!!
Bugs and Stuff
Permissions and Security
Index Related Stuff
HADR
>
Windows Clustering
Availability Groups
SQL Clustering
Replication
Transaction Log Management
T-SQL
>
Windows Function
NOLOCK
SQL Server Concurrency
VMWare
RedGate SQL Compare
Job Interview Stuff
SolarWinds SQL Sentry
Deeper Dive into Top SQL
Setup Admin User for SQL Sentry Portal
DBATools and SQL Sentry
Alert Optimization
Adding New Targets with PS
My DBA Toolkit
PreFlight Pest Test
Published Scripts
T-SQL Window Functions with Adam Machanic
I was at TechEd this year. Great session on Window Functions.