DotNetShoutout

Database

4
shouts

Shout it

Schedule database backup for sql server 2005 using maintenance plan

posted by

kcherupa 13 days, 20 minutes ago

Schedule database backup for sql server 2005 using maintenance plan

Scheduling a daily backup of sql server 2005 database using sql agent is very easy. By following below steps anyone can do that. Open sql server 2005 Management Studio and connect a serverExpand the tree (left navigation) ”Management->Maintenance Plans”Right click on node Maintenance Plans and Click “Maintenance Plan Wizard” (As shown in figure below) which causes to open a wizard. Follow the wizard In 2nd step of the wizard, You can schedule the task as clicking the Button “Change” as shown i... (more)

category: SQL | clicked: 1 | comment | | source: cherupally.blogspot.com

| flag as spam

tags: backup, Daily, Database, recurrent, sql agent, SQL Server 2005

6
shouts

Shout it

Resize Image In Asp.Net And Upload To Databse

posted by

amitjain 19 days, 9 hours, 18 minutes ago

Resize Image In Asp.Net And Upload To Databse

In this example i am going to describe how to resize image and upload to ms sql database in asp.net. For this i am using FileUpload control to upload the image in datbase after resizing. I am also displaying the Image in Gridviw after uploading to database. (more)

category: ASP.NET | clicked: 3 | comment | | source: csharpdotnetfreak.blogspot.com

| flag as spam

tags: ASP.NET, Database, grid View, SQL

7
shouts

Shout it

SQL SERVER – Stored Procedure Optimization Tips – Best Practices « Journey to SQL Authority with Pinal Dave

published 27 days, 15 hours, 31 minutes ago posted by

pinaldave 27 days, 21 hours, 4 minutes ago

SQL SERVER – Stored Procedure Optimization Tips – Best Practices « Journey to SQL Authority with Pinal Dave

We will go over how to optimize Stored Procedure with making simple changes in the code. Please note there are many more other tips, which we will cover in future articles. Include SET NOCOUNT ON statement: With every SELECT and DML statement, the SQL server returns a message that indicates the number of affected rows by that statement. This information is mostly helpful in debugging the code, but it is useless after that. By setting SET NOCOUNT ON, we can disable the feature of returning this extra i... (more)

category: SQL | clicked: 62 | comment | | source: blog.sqlauthority.com

tags: Database, pinaldave, SQL, SQLAuthority, SQLServer

2
shouts

Shout it

Entity Framework Canonical Functions

posted by

Devart 35 days, 16 hours, 18 minutes ago

This article can be useful for programmers who want to develop a cross-database applications and use the canonical functions. Entity Framework Canonical Functions are a set of functions, which are supported by all Entity Framework providers. These canonical functions will be translated to the corresponding data source functionality for the provider. (more)

category: Architecture | clicked: 17 | comment | | source: www.devart.com

| flag as spam

tags: Database, Entity Framework

6
shouts

Shout it

10 things you must do to make your desktop database apps better

published 35 days, 19 hours, 7 minutes ago posted by

http://vistadb.myopenid.com/ 36 days, 11 hours, 26 minutes ago

10 things you must do to make your desktop database apps better

Each of these items could be a blog post unto themselves, but I am going to try really hard to not be too verbose and just cover the core of the concept and why you need to do it. Everyone knows that any app driven by data is much more than just the app. In most cases the app without a database doesn’t even function, or fails to function properly. If a database is an integral part of your application, then shouldn’t you be doing all you can to ensure it ... (more)

category: SQL | clicked: 68 | comment | | source: www.vistadb.net

tags: Application Development, Database, Reliability

3
shouts

Shout it

dotConnect Team’s Blog » Blog Archive » PostGIS and Entity Framework

published 35 days, 19 hours, 7 minutes ago posted by

Devart 36 days, 14 hours, 11 minutes ago

dotConnect Team’s Blog » Blog Archive » PostGIS and Entity Framework

Introduction In this article we consider how to build Entity Framework models using PostGIS objects in Entity Developer. PostGIS is a popular spatial extension for PostgreSQL that gives one an opportunity to work with geographic objects. To create and use such models we will: use a .NET wrapper for PostGIS (SharpMap) build a new Entity C# code generation template in order to enable geometry types support write some code dealing with change tracking (more)

category: Architecture | clicked: 31 | comment | | source: www.devart.com

tags: Database, Entity Framework

6
shouts

Shout it

Working with transactions in Entity Framework and LINQ to SQL

published 35 days, 19 hours, 7 minutes ago posted by

Devart 36 days, 15 hours, 39 minutes ago

Working with transactions in Entity Framework and LINQ to SQL

Entity Framework In this article we consider a short description of the Entity Framework and LINQ to SQL transactional models. There are also some simple code listings illustrating different aspects of the transactional model. A transaction is a series of operations performed as a single unit of work. Entity Framework transactions are a part of its internal architecture. The SaveChanges method operates within a transaction and saves results of the work. It is designed to ensure data integrity. (more)

category: Architecture | clicked: 60 | comment | | source: www.devart.com

tags: Database, Entity Framework, Linq

3
shouts

Shout it

Lifestyle China Database system allows desktop UI & functionality on the Web

posted by

webgui 57 days, 10 hours, 59 minutes ago

Lifestyle China Database system allows desktop UI & functionality on the Web

"after certain tests and tries, we believed that Visual WebGui was the tool we dreamed about for developing such data dense Web-based solutions… The proven unhackable security and the ease of deployment and update totally relieve our worries and saved us tremendous labor and budget" (more)

category: ASP.NET | clicked: 0 | comment | | source: www.visualwebgui.com

| flag as spam

tags: .NET, Ajax, Database, developers, Development, UI, Web, windows applications, WinForms

1
shouts

Shout it

SSMS tab grouping with Tabs Studio

posted by

SergeyVlasov 82 days, 19 hours, 59 minutes ago

SQL Server Management Studio uses quite different scheme for tab names from Visual Studio. I’ve significantly improved SSMS support in the next Tabs Studio version. (more)

category: SQL | clicked: 4 | comment | | source: tabsstudio.wordpress.com

| flag as spam

tags: Database, SQL, SQL Server, SQL Server Management Studio, ssms

10
shouts

Shout it

Mindscape LightSpeed 3 domain modeling and persistence framework

published 91 days, 17 hours, 53 minutes ago posted by

http://vistadb.myopenid.com/ 93 days, 6 hours, 43 minutes ago

Mindscape LightSpeed 3 domain modeling and persistence framework

Mindscape has announced a new version of their dot net ORM tool named Mindscape LightSpeed 3. Version 3 includes support for VistaDB 4 and a lot of other new features. Priced at only $199 per developer (source is available for an extra fee) LightSpeed is a very cost effective tool to add to any developers tool belt. There is also a free version available for databases with less than eight tables if you just want to take the product for a test drive. We recently spoke with John-Daniel Trask of Minds... (more)

category: SQL | clicked: 93 | comment | | source: www.vistadb.net

tags: Database, LightSpeed, ORM, VistaDB, Visual Studio

4
shouts

Shout it

Spell-check OleDb Databases - Win Dev Blog

posted by

et213 107 days, 9 hours, 47 minutes ago

Spell-check OleDb Databases - Win Dev Blog

Introduction This article describes the implementation of C1DBSpellChecker, a utility that performs spell-checking on OleDb databases including SqlServer and Access. After reading this article, you will be able to specify a connection string, and then select a table and one or more string fields on the table to spell-check. Typing errors will then be displayed in a grid where they can be corrected. When all corrections have been made, the changes will be saved back to the database. Background Spell-c... (more)

category: SQL | clicked: 2 | comment | | source: helpcentral.componentone.com

| flag as spam

tags: access, AdventureWorks, ComponentOne, Database, IntelliSpell, OLEDB, spell-check, spellchecker, spell-checking, spelling, SQLServer, Visual Studio, Windows Forms, WinForms

11
shouts

Shout it

RoundhousE: Version Your Database

published 115 days, 19 hours, 3 minutes ago posted by

ferventcoder 118 days, 16 hours, 7 minutes ago

Versioning your database is as important as versioning your code. How much time do we waste currently before we are even productive when we have to fix or enhance something in a database? RoundhousE versions your database how you want. The recommended way is to version based on source control, but that may not be your solution. But for a moment let’s pretend it is. Why would versioning your database based on source control be a big help? Read on to find out why DBAs, Auditors, and ladies that can't walk... (more)

category: SQL | clicked: 27 | comment | | source: ferventcoder.com

tags: Database, database migrations, db migrations

10
shouts

Shout it

RoundhousE: Configuration

published 121 days, 19 hours, 48 minutes ago posted by

ferventcoder 122 days, 13 hours, 25 minutes ago

Let’s take a look at the RoundhousE's configuration. We are going to focus on the MSBuild/NAnt task configuration for now because the console isn’t yet complete. The console will actually have at least this much if not more (we’ve talked about how to use it to create the migration scripts and not just run them). Because we like to be able to infer things, we have determined that there are only two required items. Worth a look... (more)

category: SQL | clicked: 26 | comment | | source: ferventcoder.com

tags: Database, database migrations, DB, db migrations

11
shouts

Shout it

RoundhousE DB Migration: Action Shots

published 122 days, 20 hours, 20 minutes ago posted by

ferventcoder 124 days, 16 hours, 13 minutes ago

A quick walk through of a sample database creation and migration. With action shots so you can see the total awesome that is RoundhousE in action. Is it the best thing since sliced bread? No - only cuz you can't eat it. It will make your database migration life so much easier you'll wonder how you ever lived without it. Are you still reading this? Click the link! (more)

category: SQL | clicked: 34 | comment | | source: ferventcoder.com

tags: Database, database migrations, DB, db migrations, migration

7
shouts

Shout it

Enter The Dragon: RoundhousE DB Migrations

published 125 days, 19 hours, 21 minutes ago posted by

ferventcoder 126 days, 42 minutes ago

Enter The Dragon: RoundhousE DB Migrations

RoundhousE is an open source automated database deployment (change management) system that allows you to use your current idioms and gain much more. Currently it only supports Microsoft SQL Server, but there are future plans for other databases. It seeks to solve both maintenance concerns and ease of deployment. We follow some of the same idioms as other database management systems (SQL scripts), but we are different in that we think about future maintenance concerns. We want to always apply certain ... (more)

category: Agile | clicked: 22 | comment | | source: ferventcoder.com

tags: C#, Database, database migrations, Databases, DB, db migrations

7
shouts

Shout it

Free Database: The Relational Databases Blog: Create Firebird database from script file by code

published 129 days, 16 hours, 14 minutes ago posted by

eugenciuta 131 days, 11 hours, 41 minutes ago

Free Database: The Relational Databases Blog: Create Firebird database from script file by code

It seems the Firebird embedded engine is not able to create a database by executing a full file script as one statement. If this is what you are trying to achieve, here is a workaround (.NET/C#/ActiveRecord): Create a Firebird database from script file with ActiveRecord (more)

category: SQL | clicked: 37 | comment | | source: free-database.blogspot.com

tags: ActiveRecord, Database, Firebird

4
shouts

Shout it

Dot Net Facts: Create a Firebird database from script file with ActiveRecord

posted by

eugenciuta 131 days, 11 hours, 44 minutes ago

Dot Net Facts: Create a Firebird database from script file with ActiveRecord

Once I needed to create a Firebird database from a SQL script file using the ActiveRecord component from Castle Project. First problem was to convince ActiveRecord to execute a non-query command and the second, to execute the script file using the Firebird embedded engine. Execute non-query commands with ActiveRecord The main idea is to grab the IDbConnection object from the current ActiveRecord session. After that, you can use this connection any way you want to. C# .NET ActiveRecordMediator.Exe... (more)

category: SQL | clicked: 4 | comment | | source: dotnetfacts.blogspot.com

| flag as spam

tags: ActiveRecord, C#, Database, Firebird

10
shouts

Shout it

Are You Using Scalable Shared Databases? - Ben Nevarez

posted by

Joseph 136 days, 22 hours, 54 minutes ago

Are You Using Scalable Shared Databases? - Ben Nevarez

Did you know that you can share read-only databases between several instances of SQL Server? Scalable Shared Databases is a very interesting SQL Server feature that many of us seem to almost have forgotten about it. Available for the first time in SQL Server 2005 and originally described on the Microsoft KB article 910378, it was later fully documented on Books Online. This Enterprise edition-only feature allows a read-only database to be accessed at the same time by two or more SQL Server instances (ma... (more)

category: SQL | clicked: 3 | comment | | source: sqlblog.com

| flag as spam

tags: Database, DB, SQL, SQL Server

14
shouts

Shout it

VS 2010 Beta 2 Read Me Items for Web Deployment - Vishal Joshi

published 136 days, 17 hours, 12 minutes ago posted by

iftekharahmedamit 136 days, 23 hours, 34 minutes ago

VS 2010 Beta 2 Read Me Items for Web Deployment - Vishal Joshi

There are some known issues/bugs related to VS 2010 Web Deployment features in VS 2010 Beta 2 Read Me… I can imagine reading the entire Beta 2 read me file can be daunting so I thought I can just copy paste the ones related to Web Deployment here… DB Deployment will fail if the Database Name is longer than 127 characters Description: If you are using latest VS 2010 Web Deployment Features and trying to deploy your database using the Deploy SQL property page then at times you might get error from VSMsDe... (more)

category: Foundation | clicked: 46 | comment | | source: vishaljoshi.blogspot.com

tags: Database, DB, Deploy, Deployment, SQL, Visual Studio 2010, visual studio 2010 beta 2, VS 2010, VS2010

7
shouts

Shout it

Eschewing Date Types in our Database - Karl Seguin - CodeBetter.Com

published 139 days, 4 hours, 56 minutes ago posted by

Steves 139 days, 14 hours, 11 minutes ago

Eschewing Date Types in our Database - Karl Seguin - CodeBetter.Com

About a month ago, I found myself transforming data for the reporting portion of our application. Like many reporting systems, ours works off of date ranges, with statistics grouped together by the day (and a few by the hour). An early prototype made heavy use of TSQL Date functions (like DateAdd and DatePart). However, I wasn't happy with this solution, my transformations were unnecessarily coupled to SQL Server. I mean, database date functions all do pretty primitive date arithmetic's, surely we can co... (more)

category: SQL | clicked: 36 | comment | | source: codebetter.com

tags: Database

Welcome!

Our Sponsors

The Lounge

Database

Schedule database backup for sql server 2005 using maintenance plan

Resize Image In Asp.Net And Upload To Databse

SQL SERVER – Stored Procedure Optimization Tips – Best Practices « Journey to SQL Authority with Pinal Dave

Entity Framework Canonical Functions

10 things you must do to make your desktop database apps better

dotConnect Team’s Blog » Blog Archive » PostGIS and Entity Framework

Working with transactions in Entity Framework and LINQ to SQL

Lifestyle China Database system allows desktop UI & functionality on the Web

SSMS tab grouping with Tabs Studio

Mindscape LightSpeed 3 domain modeling and persistence framework

Spell-check OleDb Databases - Win Dev Blog

RoundhousE: Version Your Database

RoundhousE: Configuration

RoundhousE DB Migration: Action Shots

Enter The Dragon: RoundhousE DB Migrations

Free Database: The Relational Databases Blog: Create Firebird database from script file by code

Dot Net Facts: Create a Firebird database from script file with ActiveRecord

Are You Using Scalable Shared Databases? - Ben Nevarez

VS 2010 Beta 2 Read Me Items for Web Deployment - Vishal Joshi

Eschewing Date Types in our Database - Karl Seguin - CodeBetter.Com

Open ID Login

Standard Login

Forgot Password?

Sign up