Categories

A sample text widget

Etiam pulvinar consectetur dolor sed malesuada. Ut convallis euismod dolor nec pretium. Nunc ut tristique massa.

Nam sodales mi vitae dolor ullamcorper et vulputate enim accumsan. Morbi orci magna, tincidunt vitae molestie nec, molestie at mi. Nulla nulla lorem, suscipit in posuere in, interdum non magna.

SQL Server : Take offline database

EXEC sp_dboption N’mydb’, N’offline’, N’true’\r\nOR\r\nALTER DATABASE [mydb] SET OFFLINE WITH\r\nROLLBACK AFTER 30 SECONDS\r\nOR\r\nALTER DATABASE [mydb] SET OFFLINE WITH\r\nROLLBACK IMMEDIATE

\r\n

\r\n

Using the alter database statement (SQL Server 2k and beyond) is the preferred method.

\r\n

The rollback after statement will force currently executing statements to rollback after N seconds.

\r\n

The […]

How to attach a SQL Server data file MDF without LDF

To attach a MDF without LDF you can follow the steps below:\r\n

\r\n

1. Create a new database with the same name and same database (i.e. mydatabase) MDF and LDF filesÂ

\r\n

(i.e. mydatabase_data.mdf and mydatabase_log.ldf).\r\n

\r\n

2. Stop SQL server and change the name of new MDF (i.e. mydatabase.mdf to mydatabase-new.mdf) andÂ

\r\n

copy […]

SQL Injection: How To Prevent Security Flaws In PHP / MySQL

\r\n

\r\n

\r\n

\r\n

\r\n

What is SQL Injection\r\nMost new web developers have heard of SQL injection attacks, but not very many know that it is fairly easy to prevent an attacker from gaining access to your data by filtering out the vulnerabilities using MySQL extensions found in PHP. An SQL injection attack occurs when […]

Solving ReportViewer Rendering Issue on IIS7

Solving ReportViewer Rendering Issue on IIS7\r\n\r\n\r\n\r\nApplies to:\r\n

\r\n

Internet Information Services 7.0 (IIS7)

\r\n

Microsoft Report Viewer Redistributable 2005

\r\n

\r\nSymptoms:\r\n

\r\n

Unable to render ReportViewer on ASP.NET Web pages while running on IIS7.

\r\n

You have no problem viewing your reports when running on debug mode with your Visual Studio […]

Online Schema Change for mySQL

It is great to be able to build small utilities on top of an excellent RDBMS. Thank you MySQL. This is a small but complex utility to perform online schema change for MySQL. We call it OSC and the source is here (Code is also available at bottom).\r\n\r\nSome ALTER TABLE statements take too long form the perspective of some MySQL users. The fast index create feature for the InnoDB plugin in MySQL 5.1 makes this less of an issue but this can still take minutes to hours for a large table and for some MySQL deployments that is too long.\r\n\r\nA workaround is to perform the change on a slave first and then promote the slave to be the new master. But this requires a slave located near the master. MySQL 5.0 added support for triggers and some replication systems have been built using triggers to capture row changes. Why not use triggers for this? The openarkkit toolkit did just that with oak-online-alter-table. We have published our version of an online schema change utility (OnlineSchemaChange.php aka OSC). […]

MySQL – How to create a database diagram basing on the image available

Database Structure Image

Often we make some sketches of the database we plan to create on a blackboard or a sheet of paper before we actually design its structure on computer. After that we discuss the entities we’ve got, normalize them and repeat these actions several times. As a result we get a completely approved database structure in […]

Microsoft SQL Server 2008 Service Pack 2 released

Microsoft SQL Server 2008 Service Pack 2 (SP2) is released and it’s available for download. These packages may be used to upgrade any edition of SQL Server 2008. Service Pack 2 contains updates for SQL Server Utility, Data-Tier Application (DAC), as well as integration capability for Microsoft Reporting Services with the Microsoft SharePoint 2010 Technologies. Service Pack 2 introduces support for a maximum of 15,000 partitions in a database, and includes SQL Server 2008 SP1 Cumulative Update 1 to 8. \r\nYou can download Microsof t SQL Server 2008 from Microft download center.\r\nKey enhancement in Microsoft SQL Server 2008 Service Pack 2 are: […]

Page 1 of 212