Archive for 'Databases' Category

Resolution to QUOTED_IDENTIFIER Error when using SqlCacheDependancy’s

By Tony - Last updated: Friday, July 17, 2009

At work we are building a medium sized ASP.NET web application. We are using ASP.NET forms authentication for the membership. I then decided to implement a custom role provider (implementing ProviderBase) based on our [Employee] application table. Implementing this was really easy! Along the way I realized that out database was going to get hammered [...]

ADO.NET Entity Framework

By Tony - Last updated: Tuesday, March 3, 2009

I just started reading Programming Entity Framework  The subjects include:  Data Binding with WPF, LINQ to Entities Queries, Utilizing the ASP.NET EntityDataSource Control, Using Entity Objects with Web and WCF Services, Using the Entity Framework with n-Tier Windows Forms or WPF Applications, a bit on Data Transfer Objects (DTO), Customizing Entities, Using the Entity Framework [...]

SQLTRACE_BUFFER_FLUSH, Performance Metrics on SQL Server 2005

By Tony - Last updated: Monday, December 10, 2007

Tuning your SQL 2005 Database with built in metrics.

Easy way to kill MS SQL server transaction logs

By Tony - Last updated: Sunday, August 19, 2007

I manage many SQL 2000 databases. And many times while performing maintenance I have run into the ‘transaction log full’ error. like this: Error: 9002, Severity: 17, State: 2 The log file for database ‘%.*ls’ is full. So like many people I resort to using the commands BACKUP LOG databasename WITH TRUNCATE_ONLY DBCC SHRINKFILE The [...]

Utilizing SQL 2005 Linked Server to connect to external systems via OLE DB

By Tony - Last updated: Saturday, March 10, 2007

You can utilize MS SQL Server 2005′s Linked Servers ability to connect to any OLE DB provider. Here we are connecting to an iSeries (AS/400) DB2 using the IBMDA400 ole db provider Here is the command to add a linked server: EXEC master.dbo.sp_addlinkedserver @server = N’MYSERVER’, @srvproduct=N’IBMDA400′, @provider=N’IBMDA400′, @datasrc=N’MYSERVER’, @provstr=N’Transport Product=Client Access; Force Translate=0; DATA [...]

Creating a Period Date Range Table, with SQL!

By Tony - Last updated: Wednesday, October 18, 2006

You need a way to lump dated records into periodic chunks, like say for a timesheet system. Say your company’s payroll periods are bi-weekly (that’s every other week). So you need a way to distinguish the dated payroll data into two week timesheets. Sure you could spend three days figuring out a fancy algorithm, only [...]

How to reset a DNN password at the Database

By Tony - Last updated: Tuesday, September 26, 2006

If your DotNetNuke passwords all of a sudden stop working (like due to a failed upgrade), have no fear you can reset them at the database! This is not a hack, it uses the official aspnet Password Reset. Open SQL Query Analyzer – Connect to your dotNetNuke database Paste the following Stored Procedure code into [...]

Querying Data From JDE World or Co-Existance OneWorld XE

By Tony - Last updated: Wednesday, April 5, 2006

Querying or extracting data from JD Edwards World is easier than you think. You can use SQL queries to get that data out and into excel or maybe you want to extract some data to integrate with another system, perhaps with DTS… This is all pretty easy to do, when you have the right tools.

EnterpriseOne SQL Samples

By Tony - Last updated: Thursday, March 23, 2006

JDE EnterpriseOne SQL Samples for quering various systems … GL, Purchasing, Account Payable, Address Book

RSS for Corporate Data / Intranets

By Tony - Last updated: Saturday, December 3, 2005

A RSS Revelation While I was rewriting a small web application for work (a phone book application called peoplefinder that will also show you on map, where the persons cube is located), a revelation came to me. Why not create a RSS feed for the basic phone, name, department, location information… With the link pointing [...]