aus Wikipedia, der freien Enzyklopädie
Zur Navigation springen
Zur Suche springen
Programmierung
| 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
|
|
| 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 •
|
- relational SQL Databases
- suitable for financial transactions because of transactional integrity
- Examples
- Azure SQL Database
- SQL Server
- Oracle
- MySQL
- SQL Compact
- SQLite
- Postgres
- stores data in Key/Value tuples
- Examples
- Azure Blob Storage
- maps URI to file
- URI corresponds to folder and filename
- Azure Table Storage
- Value is Entity with properties
- Queries on Entities properties are possible, but inefficient
- Entity properties are optional
- Azure Cache
- Redis
- Memcached
- Riak
- splits data of an entry into groups of columns with the same key
- Examples
- hierarchical data possible
- support for XML, YAML, JSON, BSON
- queries of non-keys are possible, but should use indexers
- Examples
- stores data as objects and relationships
- Examples
- NuoDB
- NewSQL database
- supports transactional integrity
- has distributed storage and querying
- Hadoop with Map/Reduce
- Framework to make data analysis on NoSQL databases
- minimize cost by using a PowerShell skript to manage jobs and clusters
|
