Tag | Database Posts

If you have played with the ADO.NET Data Service, you can experience how quickly you can build RESTful Services using the Entity Model and then consume them as you would do it with WCF Services. The ADO.NET Data Services offer more flexibility in terms of granular data URIs compared to REST enabling your WCF Service. To begin with, if you are REST enabling your WCF Service using the WCF REST Starter Kit, you can enable your service to basic level of REST features. However, if you want to make this ...
In this Issue: Sergey Barskiy, Michael Washington, Katrien De Graeve, Brad Abrams, Chris Klug, Kirupa Chinnathambi, Tim Heuer, Koen Zwikstra, John Papa, David Anson, and Jeff Blankenburg(2). Shoutout: Chris Bernard and Sara Summers have announced Dynamic Prototyping with SketchFlow in Expression Blend ... this should be good! In this Issue: From SilverlightCream.com: Silverlight Isolated Storage DatabaseSergey Barskiy has an Isolated Storage Database for Silverlight 3 out on CodePlex. It is Object ...
In this post, I will explain how to migrate a blog running on Word Press (Self Hosted) to BlogEngine. But before I start let me say, that Word Press simply rocks. The reason why I plan to switch my blog is customization. Since I am a dotnet geek, I really have no great idea of what I can make out of Word Press using PHP and when it comes to Blogging in .net, I guess I made a very right decision to use BlogEngine. It is open source and included all the necessary blogging utilities. The main thing ...
I recently had to configure Forms Based Authentication for our website (in my case SharePoint, but the same would apply to a plain ASP.NET website) and I wanted to configure it to use Active Directory for the account storage. Our website is going to be accessed at the corporate office, using Windows Integrated Authentication and we’ve set up a separate website pointing to the same content for our extranet users. Both corporate and extranet accounts are going to be stored in AD. Just for review, FBA ...
Some of the servers provided with Windows CE implement user authentication and can grant different level of access to different kinds of users or no access at all to unauthorized people. You may use the same mechanism to grant access to your device features from your main application or from your own custom remote interface or WEB-based UI. First of all you should add the NTLM authentication service to your OS image. This will allow you to access the NTLM API and the NTLMSetUserInfo function. Using ...
Arnon Rotem-Gal-Oz wrote an article for Architect Zone where he makes the claim that CRUD is bad for REST. I couldn’t disagree more, so I felt it important to respond to his criticism. CRUD which stands for Create, Read, Update and Delete, are the four basic database operations. Some of the HTTP verbs, namely POST, GET, PUT and DELETE (there are others like OPTIONS or HEAD) seem to have a 1-1 mapping to CRUD. As I said earlier they don’t. The table below briefly contrast HTTP verbs and CRUD Actually, ...
We answered a lot of questions on Azure at day 2 of the Worldwide Partner Conference yesterday (Tues 14th July 2009). The conference is being streamed live this week (or at least parts of it) at http://www.digitalwpc.com/ Windows Azure, SQL Azure, and .NET Services will be available for purchase before end of calendar 2009 and Windows Azure will be available at PDC 2009 in November. (I’m stroking my lucky rabbits foot – but we seem confident). It will be available in 21 countries at launch (including ...
I don’t approve of calling a WCF server from SQL Server, but there was a business requirement that had to be met. It concerned regulations regarding the safeguarding of certain data elements. Due to performance issues and the application’s infrastructure, calling the service from the application itself wasn’t an option. Coding the CLR functions were the easy part. To do this, reference the Microsoft.SqlServer.Server and System.Data.SqlTypes namespaces (contained in System.Data.dll) and set the appropriate ...
I decided to write this example because this has been asked many times at the forums. In this article, I will show on how to sort GridView columns manually using a DataTable. Note that in this example, I used my own database for populating the GridView. See Adding Rows in GridView for more info. Now to get started lets set up the GridView with TemplateField columns. Since we are working with TemplateFields then we need to handle sorting manually by adding a LinkButton control inside the HeaderTemplate ...
This is all like deja-vu all over again with the exception that this time around I'm using the editor full time. That's not to say we've been totally enamored of each other for the last 24 hours, but we've made up and met half-way... The fix-ups Let me talk about the problems and workarounds first. When I said yesterday that my macros compiled, that was true... every one of them... and that was a huge improvement because last go-around I had to dork around with most of them. I may have also said ...
There has always been a controversy between modeling and coding. All from the point where models are to be turned into code automatically, through the state where models are written and then forgotten after coding has started, to the point where one generates models from the code. To me, code and model is representations of the same thing - the problem to be solved, or the solution to the problem. And when the solution matches the problem, which sometimes happens, all is well. So the artifacts one ...
I read, with interest, a post by Whitney Weaver about the “No SQL” movement. I have been, to this point, blissfully unaware of this movement. While I am not quite ready to get rid of SQL, I have been known to gripe about some of its applications and wanted to share my thoughts on the subject. SQL (or, more correctly, a Relational Database Management System, or RDBMS) is fantastic at performing the work for which it was designed: the storage of related data. Through mechanisms such as referential ...
Two new showcases are available on the Visual WebGui Showcases section. Both cases present projects from companies that have experienced and created solutions with Visual WebGui before. The first case is from the CRMCompany located in the Netherlands which is a leading company in the fields of CRM and Information. The CRMCompany developed a CRM on th web for a large customer in the Construction industry that needed a centralized application to simplify the information flow from the various locations ...
If you’ve ever written a standard .NET ASMX web service before, you know the drill. You make your service, build out your web methods, publish your service, make your consuming web project, point your project to your service via a web reference, and voila! You get strongly-typed proxy classes auto-generated for your web service consumption pleasure… But this comes at a great cost. WSDL is slow, clunky, and bloated. All that proxy code that is generated results in serializing, packaging, unpacking, ...
I wanted to create a custom alert on the SQL Database when number of records with some values(considered as invalid) exceeds the expected limit. First of all you need to Set up Database Mail for SQL 2005 and follow procedure How to setup SQL Server alerts and email operator notifications IMPORTANT: don't forget to Restart SQL Agent to activate settings. Similar to the article Define custom error messages in SQL Server 2005 I've defined the error EXEC sp_addmessage 60001, 1, N'Number of not-processed ...
This is the third post in a series to demonstrate how to use the standard MSFT technologies to implement a CRUD data application in Silverlight. The steps in this post build upon those completed in part 2. The goal of this series is to show those of you who are relatively new to Silverlight how analogous building such an app in Silverlight is to say building it in ASP.NET, Win Forms or WPF. This app is built on Visual Studio 2008 SP1, SQL Server 2008, Silverlight 2.0 and the Silverlight Toolkit using ...
This is the second post in a series to demonstrate how to use the standard MSFT technologies to implement a CRUD data application in Silverlight. The steps in this post build upon those completed in part 1. The goal of this series is to show those of you who are relatively new to Silverlight how analogous building such an app in Silverlight is to say building it in ASP.NET, Win Forms or WPF. This app is built on Visual Studio 2008 SP1, SQL Server 2008, Silverlight 2.0 and the Silverlight Toolkit ...
I’ve had this tendency to deploy CLR Functions manually by providing the dll and scripts to the data management team. This has generally worked out great, and I’ve always thought I’d have a dba available to perform the database duties. Imagine my surprise when I could not contact anyone today. Apparently database administrators take their holidays and vacations seriously (it’s Independence Day weekend for my non-American readers). Another developer asked me why I couldn’t deploy my clr functions ...
Recently I have been doing some work on an older system using ADODB recordsets. Every now and then we still have to support these old systems. I wanted to create an open recordset in code on the .NET side to pass to the older system, but ADODB really wants an open database connection in order to open a recordset. My first obvious attempt was to create the recordset object, then create the field objects and add them to the recordset. I could create the recordset this way, but I couldn't open it, and ...
Recently during migration BizTalk project from SQL to WCF adapter had some rather confusing moment. After deploying to test environment WCF ports started generate errors like this: Failed to open Microsoft.ServiceModel.Chan... Faulted Microsoft.ServiceModel.Chan... Faulted System.ServiceModel.Channel... Failed to open System.ServiceModel.Channel... After few frustrating troubleshooting sessions ...
The Problem: Recently was testing my web-app against a SQL-Server 2008 database and got a time-out expired message from the SQL database. No matter what I did after that it just did not want to drop the transaction and I continually got the time-out. I needed to find and stop the SQL transaction. The solution: Sign onto the SQL-Server with the Enterprise Manager. Execute sp_who2 and look for rows that are blocked on another connection (the BlkBy column will have the spid of the blocking connection ...
This is the first post in a series to demonstrate how to use the standard MSFT technologies to implement a CRUD data application in Silverlight. This post is beginners stuff - there’s nothing advanced here. Most readers with some experience of Silverlight will learn nothing from this post, but I want to start at the beginning so those of you who are relatively new to Silverlight can see how analogous building such an app in Silverlight is to say building it in ASP.NET, Win Forms or WPF. This app ...
In January and March 2009 I presented to the East Bay .NET and San Francisco Bay .NET user groups respectively on how to build business applications in Silverlight. The theme of the presentations was to show how developing line of business applications in Silverlight is extremely similar to other technologies like Win Forms, WPF or ASP.NET. I demoed how to build a simple CRUD application in Silverlight hitting a SQL Server database over WCF. The building of the application during the presentation ...
Yesterday I was trying to create my first database on SQL 2008 and thought let me check out if there are any new data types that I can take advantage of and yes in fact there are. The best I liked is Date and Time data type, how many times we needed a field just to store either the date part or just the time part and we ended up using DateTime data type which stores both date and time when you don't need both. Besides saving space in storage it saves the hurdle of reformatting or massaging the code ...
You know what happens when we change the name of a SharePoint server right? It simply won’t work again unless you run the SharePoint Server configuration wizard. So what would happen if you do the same for the SSRS (SQL server reporting services) server? Some say you might not be able to connect to the reporting services again. I changed my reporting server’s name and still was able to create reports and do some other things. But clearly there were some problems. I tried to get support from my colleagues ...
Many organizations are faced with the threat of data theft, from which legal battles, hefty fines and negative publicity can arise. Interestingly enough stealing data is not always that difficult. In this post we will review certain aspects of data masking, a technique used to disguise personable and sensitive information. Data masking encompasses two key areas: in-flight and at-rest. In-flight data masking is different than encryption; the goal of this technique is to temporarily transform data ...
I decided to write this simple demo because this issue has been asked many times at the forums. Hidden columns are fields in GridView that you don’t want to expose or show in the page, usually this field is the primary key of the data. Since a primary is a confidential data then you might want to hide it to the users. Most people usually use BoundField columns for displaying the data and just hide the field that contains the primary key. In this example, I will demonstrate two ways on how to access ...
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; ...
I had a question a little while ago via my blog about possibly using a rowset action to execute a SQL query against a specified table. Although a rowset action will allow you to enter a SQL query, such a query is still executed against the current cube and only the subset of SQL supported by SSAS can be used. Basically the rowset action just returns a flattened result set. However what would be possible would be to write a .Net stored procedure and use that to execute your SQL query. The code itself ...
I have just encounted an unusual database problem. My dev BizTalk server suddenly ran out of space. Initially I thought it was the transaction logs. No luck there they were well within normal limits. I did check the size ot the 'Microsoft SQL Server' directory. It was over 8GB. The volume was traced to the LOG directory. SQL was pumping out 4 MB of error log every 10 seconds. After fighting with the server to free up some disk space, I checked out the error files. The parts appear to be: ***Stack ...
Thanks for the comments. Here is a more complete listing of information types that is extensive but not exhaustive. Disposable information: Installation information such as wizard text, liner notes in a CD Jacket, and temporary information (passwords). Product Notes to tell the customer what is new in a version of the software. Getting Started, which is information in a small document (~20 pages) to familiarize someone with the product (in-depth information available elsewhere), or a high-level tool ...
I will be the first to tell you that I don't think of myself as a writer. Instead I think of myself as a geek and a gardener. I will save you from my dissertation on the best food for hostas and will try to keep on track in this blog. I will stick to the geek topics as best I am able. A little about me: I have been working with SQL server since 1994, Version 4.21a to be specific. Prior to my dive into this new technology I was a mainframe DBA, working with IMS, DB2, and Sybase. This new DB technology ...
Several Windows Embedded CE API's deal with handles: an application obtains a handle to an object than it typically checks if the handle is valid or not; unfortunately there are two values which means invalid handle: for example CreateFile returns INVALID_HANDLE_VALUE (which is defined as -1 or 0xFFFFFFFF) while CreateEvent returns NULL. A mnemonic aid is the following: all the API's that deal with files, storage and database (CreateFile, FindFirstChangeNotification, OpenStore, CeOpenDatabaseEx, ...
In this Issue: Brian Genisio, Steve Strong, Andrew Myhre, John Papa, and Corey Schuman. Shoutout: Jordan Knight is working on a presentation for Remix Australia and has posted the code he's using throughout his talk: Remix Australia 09 – Silverlight 3 Super Session Demo!, with more info to follow. Life has been hectic, so this is part 1 of 2 today... From SilverlightCream.com: Adventures in MVVM – Slides and Demo AppBrian Genisio gave an MVVM talk and has his deck and code up for our perusal. The ...
Virtual Private Database Virtual Private Database (VPD), a feature of Oracle Database 11g Enterprise Edition, was introduced in Oracle8i and is one of the most popular security features in the database. VPD is used when the standard object privileges and associated database roles are insufficient to meet application security requirements. VPD policies can be simple or complex depending on your security requirements. VPD can be used in combination with the "application context" feature to enforce ...
While C# is a computer language, Microsoft Visual C# is a programming environment used to create various types of applications, including console, graphical (GUI), XML, databases, and file-based, etc. This web site provides lessons and other topics on using Microsoft Visual C#, any version (Microsoft Visual C# 2005 Express Edition or Microsoft Visual C# Professional). Windows Controls Button Browse for Folder Check Box Checked List Box Color Dialog Combo Box Context Menu Data Grid View Date Picker ...
I worked on a project for PaperWise a few months ago where I needed to restrict the results of a SQL view based upon the user executing queries against that view. To do that, I needed some way to tie the query being executed on the view to the user executing it. The problem is that subsequent queries in PaperWise don’t necessarily identify the user executing them. PaperWise uses standard SQL Server authentication and not Windows NT authentication, which means that we have a Users table in our database ...
There was a question in the SSAS forum recently on how to replace one group name with another within the membership of a number of SSAS roles in a number of databases. While you could possibly do this with XMLA it would be tricky as you have to re-submit the whole membership list, you can't just add/remove single members. The easiest way to do this is to write something using the AMO library and in my opinion the easiest way to write a script for AMO is using Powershell. Below is my short script ...
I was working with a system migration where a client had moved a database server. The actual SQL Server HW was moved but not the SAN where the database MDF’s and LDF’s resided. They solved this by copying all of the data and log files onto a portable (USB) disk and sending this with the server. These files where then to copied onto the SAN at the new hosting place. But, they did not detach the databases first. Just copied the files. So when the server came up on the new location all the databases ...
I found this gem while looking at a database that needed all indexes rebuilt. I actually had to create the programmatic way of doing rebuilding all indexes in a database based on the information in these posts: http://blog.sqlauthority.co... http://www.sql-server-perfo... http://www.sqlservercurry.c... ...
This example shows on how to add rows of data in the GridView control. In this example, I created a simple database table called “Table1” for storing the data. The Table has the following columns: Id – PK Employees Position Team Note that I added some dummy data in table that I have created so that we can display something in the GridView when the page is loaded for the first time. To get started, let’s grab a GridView Control from the Visual Studio ToolBox and place it in the webform. Then set up ...
Summary In an Exchange 2003 environment that has matured over time, an enabled Active Directory account may get a #5.2.1 Undeliverable message (NDR) as shown below when they send an e-mail message to another enabled Active Directory account. ---------------------------... From: System Administrator Sent: March 30, 2009 9:30 AM To: Bob Stevens Subject: Let's meet at Noon Your message did not reach some or all of the intended recipients. Subject: ...
For anybody that bought the SQL Server 2008 Self-Paced Training book for 70-433, if you are running a full version of SQL Server 2008 rather than the express edition, you will have problems attaching the AdventureWorks2008 database (file activation error). The trick is to use a SQL command, like so: USE [master] GO CREATE DATABASE [AdventureWorks2008] ON ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQL2008\MSSQ... ), ( FILENAME = N'C:\Program Files\Microsoft ...
[Source: http://geekswithblogs.net/E... Often in BizTalk deployments you need to do additional work after installation. Typically your full install process may need to: Install BizTalk artifact assemblies to the GAC Install application dependencies to the GAC Register an application source name in the registry, for logging to the Event Log Create FILE send or receive locations on the local filesystem Add application store configuration settings to Enterprise Single Sign-On (SSO) Add log4net ...
Downloads Microsoft BizTalk Adapter for SQL Server http://www.microsoft.com/do... BizTalk Adapter Pack 2.0 http://www.microsoft.com/do... Installing and Configuring Microsoft BizTalk Adapters for Enterprise Applications http://www.microsoft.com/do... BizTalk ...
Today next preview version of Sync Framework became accessible. Version Sync Framework v.2 CTP2 became accessible on June, 4th, 2009. Main features of this version: New database providers Custom filters Improved conflict handling Data conversion between providers Change application service All new features are interesting that them to look. Microsoft Download Center: http://www.microsoft.com/do... ...
Normal 0 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.000... mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} If you are planning to choose ...
Maine was great! This passed weekend and beginning of the week, my wife and I took our first vacation without the kiddos since our honeymoon in celebration of our 5 year anniversary. At first we were looking for places like New York or Chicago to go, but I wanted to get away from hectic life and visiting large cities is just a hectic as real life in KC. So we decided to go to Maine on a whim. Since it was so unlike us (mainly me) to not do trips like this, we went one step further and only planned ...
I started having a think about how you could make BizTalk Server 2009 RESTful as I had been asked to give it some thought. Whilst thinking about it and wondering how I could let any subscription know the message it was subscribing to was supposed to be GET, DELETE, PUT or whatever I started creating some basic plumbing to give me something to test. To this end I started taking a look at the new WCF SQL Adapter in the BizTalk Adapter Pack 2.0. This new adapter is built using the WCF LOB Adapter SDK ...
On August 1st the Baton Rouge Area SQL Server and .Net user groups are hosting an all day free SQL Server and .Net training event! Attendees will have chances to win great prizes! What more could a SQL Server and .Net Professional ask for? If this sounds good to you then don’t miss your opportunity to attend SQL Saturday! #17, the largest FREE training event dedicated exclusively to SQL Server, .Net, Development and Business Intelligence to hit Baton Rouge. Registration is required. For more information ...