dbafox
Welcome to dbafox.com, which is a collection of information gathered during my work as a DBA. Main topics are: Database, SQL Server, Oracle, PowerShell, Linux.
Most of the content is in the form of posts in the blog categories. Searching the site (at the bottom of the page), rather than navigating the menus, is the best way to find something of interest.
This front page is just a list of links that I found useful and wanted to remember.
Oracle
Oracle Database
- Oracle Help Centre (May require Oracle Account and SSO)
- Pete Finnigan Oracle and Oracle Security Information
- Oracle
- OTN
- My Oracle Support
- Oracle Recommended Patches — Oracle Database (Doc ID 756671.1) – Login to MOS required
- RMAN Duplicate Scenarios
- ORACLE-BASE – Recovery Manager (RMAN) Enhancements in Oracle Database 10g
- Information Center: Oracle Database 12c Release 1 (Doc ID 1595421.2) – requires Oracle Account and SSO
- Information Center: Oracle Database 12c Release 2 (Doc ID 2309844.2) – requires Oracle Account and SSO
- AUDIT (Traditional Auditing)
- Base Enterprise Manager Functionality
- Configuring Audit Policies
- Database Appliance X4-2 Oracle
- Database Hosting – All Documents Including Service Description
- Database Support Status
- Deprecated and Desupported Features for Oracle Database 12c
- ESL oracle
- Licensing Information 11gR2
- Management Connector for Microsoft System Center Operation
- My Oracle Support
- Options and Packs
- Oracle Blogs Homepage
- Oracle Core Factor Table
- Oracle Database 12c Release 1 (12.1) New Features
- Oracle Database Editions
- Oracle Help Center
- Oracle License and Service Agreement
- oracle price list
- Oracle Recommended Patches 756671
- Product Support – Toad for Oracle
- Rules Manager and Expression Filter getting removed (Upgrade your Database – NOW!)
- Upgrade your Database – NOW!
Powershell
PowerShell Automation
- PowerShell Magazine
- Enable PowerShell-ise on Windows 2008 R2
- comparing a string that contains a parenthesis
- Escape characters PowerShell SS64
- How to Install SQL Server 2012 SP2 on Standalone SQL Server Instance – TechNet Articles – United States (English) – TechNet Wiki
- Installing Updates from the Command Prompt
- Let’s do a deep drill into Select-String – Windows PowerShell Blog – Site Home – MSDN Blogs
- Overview of SQL Server Servicing Installation
- Regular Expression Language – Quick Reference
- Regular Expressions Are Your Friend (Part 1) – Dreaming in PowerShell – PowerShell.com – PowerShell Scripts, Tips, Forums, and
- Running SQL Server PowerShell (2)
- Running SQL Server PowerShell
- SQL Server and PowerShell PowerShell content from SQL Server Pro
- The “joy” of Reg-ex part 1. – James O’Neill’s blog – Site Home – TechNet Blogs
- The “Joy” of Reg-ex part 2 – ways I use it – James O’Neill’s blog – Site Home – TechNet Blogs
- The “Joy” of Reg-ex part 3 Select-String – James O’Neill’s blog – Site Home – TechNet Blogs
- Windows PowerShell 2.0 Select-String Cmdlet
SQL Server
Sql Server
- SQL Server – Add features to an existing instance
- SQL Server Kerberos and SPN Field Guide
- SSMS Query Window Shortcuts
- FILESTREAM – SQL Server
- How to transfer logins and passwords between instances of SQL Server
- SQL Server Management Studio Keyboard Shortcuts
- Read SQL Server Transaction Log
- SQL Server Management Studio SQLCMD mode option
- Aaron Bertrand SQL Server 2012 Service Pack 2 is available – but there’s a catch!
- Buy SQL Server 2012-2014 Microsoft
- Database Engine Error Severities
- Eight Steps to Effective SQL Server Monitoring
- How to query Active Directory to fetch more than 1000 rows using Sql Server–Part I SQL Server Faq
- Joining Active Directory Data with SQL Server Data Cannot fetch a row from OLE DB provider “YourProvider” for linked server “Y
- Latest Builds of SQL Server 2012 – SQL Sentry Team Blog
- Microsoft Product Lifecycle Search
- Microsoft SQL Server Release Services – Site Home – MSDN Blogs
- Microsoft SQL Server Versions and Builds List
- Microsoft Lifecycle
- Querying Active Directory through SQL Server Using OpenRowset and OpenQuery
- Report Builder of SQL Server 2008 R2 Service Pack 3 does not launch. – Microsoft SQL Server Release Services – Site Home – MSDN
- SharePoint SQL Server Support Matrix
- SQL Server 2008 R2 Service Pack 3 release information
- SQL Server 2008 R2 SP3 and SQL Server 2008 SP4 are now available! – SQL Server Team Blog – Site Home – TechNet Blogs
- SQL Server 2012 AlwaysOn
- SQL Server Data Tools BI (SSDT-BI) for SQL Server 2014 James Serra’s Blog
- SQL Server Data Tools for Visual Studio 2012
- SQL Server Data Tools Team Blog – Site Home – MSDN Blogs
- SQL Server Operating System Compatibility Matrices – Documentation 4.0 – Delphix Engine 4.1 Documentation
- SQL SERVER – Performance Counter Missing How to Get Them Back Journey to SQL Authority with Pinal Dave
- SQL Video
- Sql Workshops Ramesh MEYYAPPAN
- tsql – Query AD Group Membership Recursively Through SQL – Stack Overflow
- How to set up a Kerberos Authentication Scenario with SQL Server Linked Servers
Linux
Linux
- Linux Firewall
- Epoch Unix Time Stamp Converter
- Linux Memory Usage Commands
- Tools to monitor system resources on Linux
- linux.org
Windows
Windows
- Microsoft OneNote Main Page – Shortcut Windows-Shift-N to execute
- Managing Active Directory from MMC
- XCOPY to retain permissions