Microsoft Warns of SQL Attacks

Just days after patching a critical flaw in its Internet Explorer browser, Microsoft is now warning users of a serious bug in its SQL Server database software.
Microsoft issued a security advisory late Monday, saying that the bug could be exploited to run unauthorized software on systems running versions of Microsoft SQL Server 2000 and SQL [...]

Read Full Post »

Cascade Delete in SQL

Many a times you need to delete the record but at the same time you need to make sure all the related or referenced records are also deleted. This is because you can not delete a record if it is referenced in another table. In this case you can either delete the referenced record or [...]

Read Full Post »

Data Scripter Add-in for SQL

Many a times you feel the need to script databases, tables, stored procedures etc. But you already have these utilities that help you to script these database objects. There is no script generator for the data present in the table. For e.g. you want to move data from one server to another, to accomplish this you have the script [...]

Read Full Post »

Which SQL Statements Are Currently Executing

sp_who2 is a well known utility that shows what spids are currently executing. However the information it shows is relatively limited. For example, it only shows the type of command executing as SELECT, DELETE etc, with no reference to the actual underlying SQL executing.
Knowing what SQL is executing can be vital in debugging why a [...]

Read Full Post »

New Features in SQL 2008

Top new features in SQL 2008
- Use Resource Governor to manage concurrent workloads.
Ensure consistent performance by using Resource Governor to define resource limits and priorities for different workloads and enable consistent performance.
- Enforce policy compliance consistently across the enterprise with the Declarative Management Framwork.
Manage your enterprise data infrastructure easily with Declarative Management Framework (DMF). Reduce [...]

Read Full Post »