- SQL Server (Database Developer / DBA / Datenbank Entwickler / Administrator)
- SSIS, SSAS, SSRS, MDS, DQS
- Business Intelligence (BI-Developer / DWH Developer / BI-Entwickler / DWH-Entwickler)
- SharePoint, PowerPivot, Excel Services, PerformancePoint Services, MDX
- Reporting (Reports Developer / Reporting Specialist / Reports Entwickler / Reporting Spezialist)
- SSRS, Report Designer, Report Builder, PowerView, PivotTables, Excel, .Net-based custom reporting solutions
- Windows Server & Infrastructure
- AD, DNS, DHCP, Kerberos, IIS, SharePoint, Hyper-V
- System Center
- SCOM, SCCM, SCVMM, Orchestrator
- Programming
- C#, VB.net, VBA (Excel, Access, Outlook), ASP.Net
- Scripting
- T-SQL, MDX, Powershell, VB-Script, HTML, CSS, RegEx
- MS Office
- Word, Excel, Excel, Access, Outlook, PowerPoint
Full list of of my skills, the tools I use and the technologies I've been exposed to:
Expertise area / Task |
Products & Tools & Utilities |
Versions |
HW |
Dell PowerEdge |
R610 | R710 | R620 | R720 |
Dell Server Management |
OME | OMSA | DMC | SUU | SBUU | Repository Manager |
|
Server OS |
Windows Server | Windows Server Core | Core Configurator |
2003 | 2008 | 2008R2 | 2012 |
Client OS |
Windows |
XP | Vista | 7 | 8 |
Storage |
RAID | iSCSI |
|
Server Virtualization |
Hyper-V Server | Hyper-V Manager | SCVMM |
2008 | 2008R2 | 2012 |
Discovery |
SCCM | MAP-Toolkit 8 | SQLping 3 | Quest Discovery Wizard for MSSQL |
2007 | 2012 |
OS/SW-Deployment & Patching |
SCCM | MDT | WAIK | Windows ADK | SCUP | WSUS |
2007 | 2007R2 | 2012 |
Inventory/Asset Management |
SCCM |
2007 | 2007R2 | 2012 |
Monitoring |
SCOM | Quest Spotlight | Quest Foglight |
|
Development |
Visual Studio | .Net | VB.Net | C# | ASP.Net MVC |
|
Scripting |
WinRM | Powershell | WinRS | WMI | WQL | VBScript | OS-Script | RegEx | Html |
|
WMI |
Code Generator | Scriptomatic | WBEMTEST | WMIDiag | WQL |
|
XML |
XML | XSD | XSLT | XPath | XPointer | SOAP | SAX | SQL/XML |
|
Configuration Management |
SourceSafe | TFS |
|
Support / Ticketing |
BMC Remedy ITSM |
|
SQL Server (daily work) |
SSMS Tool Pack | Redgate SQL Toolbelt | Toad f. SQL Server | ApexSQL |
|
SQL Server Jobs Management |
Idera SQL Job Manager | MultiServer Management feature |
|
SQL Server Backup / Restore |
EMC Networker | Quest LiteSpeed |
|
SQL Server Events Management |
SCOM | MultiServer Management feature |
|
SQL Server Settings Management |
SQL Server Best Practices Analyzer | Policy-Based Management Feature |
2005 | 2008 | 2012 |
SQL Server Database Modelling |
ErWin | E/R Studio | Enterprise Architect | Visio |
|
SQL Server Database Development |
SSDT (SQL Server Data Tools) |
|
SQL Server BI-Development |
SSDT (SQL Server Data Tools) | BIDS | BIDS-Helper | PowerPivot | Sharepoint |
|
SQL Server Reports Development |
SSDT | Report Designer | Report Builder | Powerview | PowerPivot | .Net |
|
SQL Server Programming |
T-SQL | Stored Procedures | UDFs | Triggers | DAX | MDX | .Net (for CLR) |
|
SQL Server Performance Tuning |
Foglight PA |
|
SQL Server Troubleshooting |
SQLPing | Portqry | DTCPing | DTCTest |
| .NET Development | Visual Studio | LinqPad | RegEx | AutoMapper | Web Essentials | GitHub | |
Last update on 01.07.2013 |
|