Tag Cloud
- .NET
- ADO.NET
- Architecture
- Calendar
- Client/Server
- Cloud
- Contacts
- Database
- Dataflow
- Dev_Workstation
- Distributed_Apps
- Entity_Framework
- FileSystemWatcher
- Gmail
- InternalBufferOverflowExceptions
- Kindle
- LightSwitch
- Notebook
- Office_365
- OneDrive
- Oracle
- Outlook
- Project_Management
- remember_the_milk
- Security
- Server_2008
- SQL_Server
- Surface
- Tasks
- ThinkPad
- TPL
- Transaction_Scope
- Travel
- UWP
- Visual_Studio
- WCF
- Windows 10
- Windows_7
- Windows_8
- Windows_Phone
-
Aktuelle Beiträge
- Global Error Handling for UWP-Apps
- Tracing for UWP-Apps
- Quirks with date and number formats in UWP Apps and Windows 10
- Good Gear and Tools for Digital Nomads (with DE shopping links)
- Good Gear and Tools for Digital Nomads (with US shopping links)
- Thoughts and Experiments on Cloud Encryption
- How to completely clean install Windows 10 on a UEFI PC
- Windows Service Worker Options
- Simple WCF
- Tamed FileSystemWatcher
- My Windows 8.1 upgrade and usage experiences
- How to move from Hotmail and Gmail to Office 365 as a Server for Outlook desktop and Windows Phone 8
- Installing Windows 8 on an old X61s ThinkPad
- A WebCrawler demonstrating the Beauty of TPL Dataflow
- WP7 Background Agent Pitfalls and App/Agent Synchronization
- Windows Phone 7 App Development Helpers and Time Savers
- Managing BLOBs using SQL Server FileStream via EF and WCF streaming
- Using Transactional NTFS (TxF) with SQL Server in .NET
- How to get the best currency exchange rate when travelling
- Changing the email send address in Office 365 without moving your domain
- Using Native VHD Boot
- My Advice for Successful Projects
- Have Passion for Your Work
- .NET Database Access Options
- My Advice for .NET Application Architecture and Design
- Advanced Search with Internet Search Engines
- Why I Dislike IE 9
- Configure your Kindle for better Readability
- About Opinions and Assumptions
- How to Configure MS SQL Server for Testing with Visual Studio
Archiv
- Juli 2016 (2)
- Juni 2016 (1)
- April 2016 (2)
- März 2016 (1)
- September 2015 (1)
- Juni 2015 (2)
- Mai 2015 (1)
- Oktober 2013 (1)
- April 2013 (1)
- Oktober 2012 (2)
- Mai 2012 (2)
- Februar 2012 (2)
- Oktober 2011 (1)
- Juli 2011 (1)
- April 2011 (5)
- März 2011 (15)
- Januar 2011 (1)
- März 2010 (3)
Meta
Schlagwort-Archive: SQL_Server
Managing BLOBs using SQL Server FileStream via EF and WCF streaming
Für mehr Informationen zu diesem Thema in Deutsch siehe meinen Artikel „Stream das BLOB“ im dotnetpro Magazin 6/2012. With FileStream SQL Server 2008+ stores BLOBs in the NTFS file system instead of its table store and offers fast streaming access. … Weiterlesen
Veröffentlicht unter Computers and Internet
Verschlagwortet mit .NET, ADO.NET, Architecture, Database, Entity_Framework, SQL_Server, Transaction_Scope
4 Kommentare
Using Transactional NTFS (TxF) with SQL Server in .NET
I just stumbled across the very new Transactional NTFS (TxF) .NET managed wrapper by Pietro Partescano and gave it a try. TxF offers transactional protection for NTFS operations: Atomic operations on single files. Makes writing files more robust. Transactions for … Weiterlesen
Veröffentlicht unter Computers and Internet
Verschlagwortet mit .NET, Architecture, Database, Entity_Framework, SQL_Server
Kommentar hinterlassen
.NET Database Access Options
Database access options in .NET: Plain ADO.NET and DataSets See The SQLCommandBuilder is way Better than its Reputation. Create a custom simple ADO.NET data access wrapper Provider independent using System.Data.Common Microsoft Enterprise Library, Data Access Application Block (DAAB) Can be used … Weiterlesen
Veröffentlicht unter Computers and Internet
Verschlagwortet mit .NET, ADO.NET, Architecture, Database, Distributed_Apps, Entity_Framework, Oracle, SQL_Server
Kommentar hinterlassen
My Advice for .NET Application Architecture and Design
This post summarizes my general architecture and design guidelines for developing applications and points to some interesting NET technologies. Reading this post will not make anyone an architect, but working through it should give you a good foundation for understanding … Weiterlesen
Veröffentlicht unter Computers and Internet
Verschlagwortet mit .NET, ADO.NET, Architecture, Database, Distributed_Apps, Entity_Framework, LightSwitch, Oracle, SQL_Server
4 Kommentare
How to Configure MS SQL Server for Testing with Visual Studio
When setting up MS SQL Server for test projects with Visual Studio I generally stumble across the following problems only: Use SQL Server Express or Developer Edition? Enabling remote access What are the default database instance names With Oracle I … Weiterlesen
Veröffentlicht unter Computers and Internet
Verschlagwortet mit .NET, Database, SQL_Server, Visual_Studio
1 Kommentar
DB Concurrency Control with .NET – Details
[To put this post into perspective see DB Concurrency Control with .NET – Overview] The following patterns are commonly used in applications to control database concurrency: Optimistic Control in UI Scenarios in Service Scenarios Pessimistic Control SQL Locking Hints Check-out Locking … Weiterlesen
Veröffentlicht unter Computers and Internet
Verschlagwortet mit .NET, ADO.NET, Architecture, Client/Server, Database, Distributed_Apps, Entity_Framework, LightSwitch, Oracle, SQL_Server, Transaction_Scope
3 Kommentare
Know your Database System!
[To put this post into perspective see DB Concurrency Control with .NET – Overview] Developing database centric applications you must(!) understand the fundamentals of your specific database management system – even when using an ORM: You must understand the DBMS architecture … Weiterlesen
Veröffentlicht unter Computers and Internet
Verschlagwortet mit .NET, ADO.NET, Architecture, Database, Entity_Framework, Oracle, SQL_Server
3 Kommentare
Beware of End-User Permissions in Databases
Beware of giving end users direct access to your databases, e.g. by using SQL Server integrated security in single-layer or Client/Server architectures. If end users have permissions on database tables they may bypass your application logic and read or update … Weiterlesen
Veröffentlicht unter Computers and Internet
Verschlagwortet mit ADO.NET, Client/Server, Database, Distributed_Apps, Oracle, SQL_Server
Kommentar hinterlassen
Stored Procedures Pros & Cons
Using a stored procedures (SP) data access layer is a totally viable approach (see [1]). While I do not devalue SP’s as the „assembly language of databases“, I personally dislike the language break and generally use stored procedure in special … Weiterlesen
Veröffentlicht unter Computers and Internet
Verschlagwortet mit .NET, ADO.NET, Database, Oracle, SQL_Server
2 Kommentare
Use the .NET TransactionScope
The TransactionScope class provides an elegant way to enclose a set of operations against resource managers in a transaction. Resource managers are: Databases (SQL Server, Oracle, DB2, …) MSMQ Transactional NTFS file system TxF Transactional Registry Custom resource managers See … Weiterlesen
Veröffentlicht unter Computers and Internet
Verschlagwortet mit .NET, ADO.NET, Database, Entity_Framework, Oracle, SQL_Server, Transaction_Scope
4 Kommentare