| Programmierung |
Administration •
Links •
Vorgehensmodelle •
NuGet •
Transformations •
MSBuild •
Raspberry •
Cheatsheets •
Git •
Mathematica |
| C♯ |
|
| F♯ |
|
| Python |
Classes •
Loops •
Anonymous Types •
Lambda Expressions •
Queries (LINQ) •
Iterators (yield) |
| PHP |
|
| T-SQL / SQL Server |
| T-SQL Fundamantals |
Select •
Programming •
Pitfalls •
Query from Multiple Tables •
Groups and Summaries •
Advanced Select •
Aggregation and Windowing •
Insert, Update, Delete •
Strings •
Date and Time •
Numbers •
Transactions, Locking, Blocking, Deadlock •
Tables •
Views •
Large Tables and Databases •
Indexes •
Stored Procedures •
User-Defined Functions and Types •
Triggers •
Error Handling •
Query Performance and Tuning •
Hints •
Index Tuning and Statistics •
XML •
Files, Filegroups, Integrity •
Backup •
Recovery •
Principals and Users •
Securables, Permissions, Auditing •
Objects and Dependencies |
SQL Server Performance Tuning |
Memory Performance Analysis •
Disk Performance Analysis •
CPU Performance Analysis •
Baseline Creation •
Query Performance Metrics •
Query Performance Analysis •
Index Architecture and Behavior •
Index Analysis •
Database Engine Tuning Advisor •
Key Lookups •
Statistics, Data Distributuon, and Cardinality •
Index Fragmentation •
Execution Plan Generation •
Execution Plan Cache Behavior •
Parameter Sniffing •
Query Recompilation •
Query Design Analysis •
Reduce Query Resource Use •
Blocking and Blocked Processes •
Causes and Solutions for Deadlocks •
Row-By-Row Processing •
Memory-Optimized OLTP Tables and Procedures •
Database Performance Testing •
Database Workload Optimization •
SQL Server Optimization Checklist |
| Service Broker |
Message •
Contract •
Queue •
Service •
.NET Integration •
Route •
Security |
| |
Datatypes •
Unit Testing •
Dependency Injection •
Partitioning • |
|
| .NET |
|
| ASP.NET |
|
| Messaging |
|
| User Interface |
|
| Parallel Programming |
|
| ECMAScript |
|
| SharePoint |
|
| Microsoft CRM |
Reporting and Dashboards •
SharePoint Integration •
Authentication •
Entity Handling •
Workflows •
Queries |
| Security |
Forms Authentication •
Membership and Role Provider •
Zertifikate •
OAuth •
OpenID •
Windows Identity Foundation |
| Dateiformate |
CSV •
Excel •
Word •
PDF •
Email |
| Azure |
|
| Muster |
|
| Powershell |
|
| Android |
ROM Flashen •
Unit Testing •
Assistant |
| Machine Learning |
| Neuronale Netze |
Propagierungsfunktionen •
Aktivitätsfunktionen •
Lernmethoden •
Pattern Associator •
Rekurrente Netze •
Kompetitive Netze •
Kohonennetze •
Constrain Statisfaction Netze |
| Tensorflow |
Linear Regression •
Logistic Regression •
Softmax Regression •
Hidden Markov •
K-Means Clustering •
Self-Organizing Map •
Autoencoder •
Q-policy neural network •
Perceptron •
Convolutional Neuronal Network •
Recurrent Neuronal Network •
Seq2Seq •
Ranking |
|
| Core Server |
Hyper-V •
Active Directory User Groups •
Active Directory Domain Services •
Active Directory Federation Services •
DHCP •
IIS •
DNS •
RDP •
WSUS •
User Permissions •
IP •
SMB •
DHCP •
IPAM •
Sonstige |
| Bot Framework |
Rich Messages • |