alexei
AntonovIgor
itserg
Andy
vykser
http://eax.me/
calabonga
clava080
greenkaktusx
rbdev
http://nesteruk.wordpress.co...
Spider84
gpeipman
Felix
mellomannov
handcode
DevLanfear
http://kigorw.livejournal.co...
ttil
http://outcoldman.ru/openid
taegeukz
kalisha
Vlad-55
Anry
http://www.tdelphiblog.com/
butaji
sashaeve
http://vsego.wordpress.com/
Lesnoy_chelovek
alexbozhko
Vir2al
noonv
http://deerua.livejournal.co...
kron0s
Базы данных
|
2
proggs |
Thursday, September 02, 2010 9:51:42 AM GMT
Wednesday, September 01, 2010 4:37:21 PM GMT
В одном из комментариев здесь была просьба рассказать подробнее об индексах, и так как, в рунете практически нет сводных данных о поддерживаемых индексах различных СУБД, в данном обзоре я рассмотрю, какие типы индексов поддерживаются в наиболее популярных СУБД »»»
|
|
3
proggs |
Tuesday, August 31, 2010 3:28:15 PM GMT
Sunday, August 29, 2010 12:51:45 PM GMT
The release of Entity Framework Feature CTP4 was recently announced and included some walkthroughs touching on the core functionality included in the CTP. Over the next couple of weeks I’m going to post up a series of short articles that cover some of the finer points in the CTP.
The CTP includes some work called the Productivity Improvements for EF which aims to provide a simpler and more productive experience writing data access code with EF. Along with a bunch of conventions that take care of a lot o... »»»
|
|
3
proggs |
Monday, August 16, 2010 7:48:18 AM GMT
Friday, August 13, 2010 4:47:40 PM GMT
Microsoft выпускает новые и обновленные версии инструментов обеспечения безопасной миграции баз данных Oracle, Sybase, MySQL, Access на SQL Server. Microsoft SQL Server Migration Assistant позволяет снизить риски и затраты при осуществлении миграции данных с разных СУБД на SQL Server. Миграция с Access поддерживается для версий Access 97 и выше. Миграция с Sybase поддержив... »»»
|
|
3
proggs |
Monday, August 16, 2010 7:48:18 AM GMT
Friday, August 13, 2010 4:52:46 PM GMT
Implementation of a ASP.NET Membership provider for SQL Server Compact 4.0, for use with Forms Authentication for web sites using only SQL Server Compact 4.0. This project provides files that contain a Membership provider, a Role provider for ASP.NET and a SQL Compact database. »»»
|
|
3
proggs |
Saturday, August 14, 2010 5:54:02 PM GMT
Wednesday, August 11, 2010 11:57:09 AM GMT
After making EF Prof work with EF Code Only, I decided that I might take a look at how Code Only actually work from the perspective of the application developer. I am working on my own solution based on the following posts:EF Feature CTP4 Walkthrough: Code FirstEF Feature CTP4 Walkthrough: Productivity Improvements
But since I don’t like to just read things, and I hate walkthroughs, I decided to take that into a slightly different path. In order to do that, I decide... »»»
|
|
3
proggs |
Saturday, August 14, 2010 4:38:33 AM GMT
Wednesday, August 11, 2010 7:03:29 AM GMT
This post intends to help TSQL developers get started with PIVOT/CROSS TAB queries. Most business applications will need some sort of PIVOT queries and I am sure many of you must have come across pivoting requirements several times in the past. »»»
|
|
3
proggs |
Wednesday, August 11, 2010 3:36:42 AM GMT
Tuesday, August 10, 2010 4:58:19 PM GMT
Microsoft’s Azure platform provides excellent data storage facilities in the form of the Windows Azure Storage service, with Table, Blob and Queue stores, and SQL Azure, which is a near-complete SQL Server-as-a-service offering. But one thing it doesn’t provide is a “document database”, in the NoSQL sense of the term.
I saw Captain Codeman’s excellent post on running MongoDB on Azure with CloudDrive, and wondered if Ayende’s new RavenDB database could be run in a similar fashion; specifically, on a Worker ... »»»
|
|
3
proggs |
Wednesday, August 11, 2010 3:36:42 AM GMT
Tuesday, August 10, 2010 5:48:20 PM GMT
I’m guessing that the properties of these three NoSQL database are what the original SQL Server Data Services (SSDS) and later SQL Data Services (SDS) teams had in mind when they developed their original SQL Server-hosted Entity-Attribute-Value (EAV) database. GraphDB is the newest and one of the most interesting of the databases.
SQL Azure has become very popular among .NET developers working on Windows Azure deployments due to its relatively low cost for 1-GB Web databases (US$9.99 per month). A single s... »»»
|
|
4
proggs |
Tuesday, August 10, 2010 4:46:25 PM GMT
Tuesday, August 10, 2010 12:23:04 PM GMT
Работаем с часовыми поясами в SQL Server 2008
В SQL Server 2008 появился новый тип данных – DATETIMEOFFSET, позволяющий задавать смещения часовых поясов при обработке соответствующих типов данных (на всякий случай напомню, что в SQL Server 2008 появились четыре новых типа данных: data, time, datetime2 и datetimeoffset).
Текущая дата и время (вместе со смещением часового пояса) могут быть получены через SYSDATETIMEOFFSET. Для того, чтобы перевести значение из одного часового пояса в другой, можно воспользо... »»»
|
|
3
proggs |
Tuesday, August 10, 2010 4:46:25 PM GMT
Tuesday, August 10, 2010 12:36:07 PM GMT
The most typical error people make when trying to design the data model on top of a document database is to try to model it the same way you would on top of a relational database. A document database is a non relational data store, and trying to hammer a relational model on top of it will produce sub optimal results. But you can get fantastic results by taking advantage on the documented oriented nature of Raven. »»»
|
|
4
proggs |
Monday, August 09, 2010 12:15:25 PM GMT
Friday, August 06, 2010 2:19:31 PM GMT
In keeping with the theme of this issue, it’s time to return to the roots of SQL and relational databases. Naturally, it would thus seem apropos to write something about SQL Server, something about its new feature set or performance improvements or whatnot, but that’s just not my style. Don’t get me wrong, SQL Server is a great database, and highly recommended for those “big iron” enterprise-class scenarios, but not every problem demands (as a friend once put it) a “big honkin’ centralized database.” »»»
|
|
3
proggs |
Monday, August 09, 2010 12:15:25 PM GMT
Friday, August 06, 2010 2:17:58 PM GMT
Many applications are designed explicitly to use multiple tiers, where the performance of calls into the data access tier is crucial to the overall responsiveness of the application. The use of multiple tiers increases the flexibility of the application. The n-tiered approach also fosters isolation of key components, which can be used to improve both reliability and scalability. The use of multiple tiers promotes scalability because components that are isolated into distinct tiers can then more readily be d... »»»
|
|
3
proggs |
Monday, August 09, 2010 12:15:25 PM GMT
Friday, August 06, 2010 2:22:36 PM GMT
One of the first things I hear from database owners when they see the Entity Framework command creation at work is: “What? I have to provide access to my tables?” They react this way because one of the core capabilities of the Entity Framework is generation of SELECT, UPDATE, INSERT and DELETE commands.
In this column, I will give database administrators some insight into how the Entity Framework generates commands and then introduce features that let you limit its access to your database by allowing it ... »»»
|
|
5
proggs |
Sunday, August 08, 2010 6:08:20 PM GMT
Thursday, August 05, 2010 2:26:19 PM GMT
Общие табличные выражения. Часть 2
Всю мощь общих табличных выражений можно оценить при необходимости выполнения рекурсивных запросов к иерархическим древовидным структурам данных. Фактически, потребность в эффективном инструментарии решения подобного рода задач и явилась причиной, по которой компания Microsoft дополнила стандарт ANSI SQL-92 механизмом CTE. Рекурсивные CTE состоят как минимум из двух запросов. Первый, внешний запрос, к которому осуществляется привязка одного или нескольких дочерних запросо... »»»
|
|
4
proggs |
Friday, August 06, 2010 12:50:03 PM GMT
Thursday, August 05, 2010 8:21:03 PM GMT
MongoDB 1.6 is a drop-in replacement for 1.4. To upgrade, simply shutdown mongod then restart with the new binaries.Sharding
Sharding is now production-ready, making MongoDB horizontally scalable, with no single point of failure. A single instance of mongod can now be upgraded to a distributed cluster with zero downtime when the need arises.Sharding TutorialSharding DocumentationUpgrading a Single Server to a ClusterReplica Sets
Replica sets, which provide automated failover among a cluster of n nodes, a... »»»
|
|
4
proggs |
Thursday, August 05, 2010 11:47:15 PM GMT
Tuesday, August 03, 2010 2:47:01 AM GMT
WP7 developer devices are already out in the US and I still hope I will qualify for one here in Italy. I would really love to test one. Brandon PLEASE don't forget me :) As my proposal was a better port of the Sqlite engine I did some optimizing on the engine and also implemented/adapted a SqliteClient that is easier to use than normal sqlite3 commands. At the "engine" part I use the journal file persistent this way the engine doesn't delete and create the journal at each command. I've also eliminated... »»»
|
|
4
proggs |
Thursday, August 05, 2010 6:11:27 AM GMT
Wednesday, August 04, 2010 2:16:51 PM GMT
Last month I blogged about the new Entity Framework 4 “code first” development option. EF “code-first” enables a pretty sweet code-centric development workflow for working with data. It enables you to:Work with data without ever having to open a designer or define an XML mapping file Define model objects by simply writing “plain old classes” with no base classes required Use a “convention over configuration” approach that enables database persistence without explicitly configuring anything
In my initial... »»»
|
|
4
proggs |
Thursday, August 05, 2010 6:11:27 AM GMT
Wednesday, August 04, 2010 1:52:41 PM GMT
Now that you have your database set up in SQL Azure, the next step is to load your data to this database. Your data could exist in various sources; valid sources include SQL Server, Oracle, Excel, Access, flat files and others. Your data could exist in various locations. A location might be a data center, behind a corporate firewall, on a home network, or even in Windows Azure. »»»
|
|
6
proggs |
Thursday, July 29, 2010 3:40:12 PM GMT
Monday, July 26, 2010 5:43:23 PM GMT
Популярный сторонний ORM NHibernate выпущен в новой версии NHibernate 3.0 Alpha1.
NHibernate 3.0 Alpha1 – это предварительный выпуск библиотеки, предназначенный для целей тестирования и обнаружения ошибок силами сообщества. »»»
|
|
3
proggs |
Thursday, July 29, 2010 3:40:12 PM GMT
Monday, July 26, 2010 5:46:56 PM GMT
Microsoft Project Code-Named “Houston” (Houston) is a light weight database management tool for SQL Azure. Houston can be used for basic database management tasks like authoring and executing queries, designing and editing a database schema, and editing table data. Currently, Houston is its first community technology preview (CTP), the instructions and screen shots shown in this blog post are from the CTP version of Houston. In this blog post I am going to show how to get started using Houston. »»»
|
