自定义博客皮肤VIP专享

*博客头图:

格式为PNG、JPG,宽度*高度大于1920*100像素,不超过2MB,主视觉建议放在右侧,请参照线上博客头图

请上传大于1920*100像素的图片!

博客底图:

图片格式为PNG、JPG,不超过1MB,可上下左右平铺至整个背景

栏目图:

图片格式为PNG、JPG,图片宽度*高度为300*38像素,不超过0.5MB

主标题颜色:

RGB颜色,例如:#AFAFAF

Hover:

RGB颜色,例如:#AFAFAF

副标题颜色:

RGB颜色,例如:#AFAFAF

自定义博客皮肤

-+
  • 博客(6)
  • 资源 (10)
  • 收藏
  • 关注

原创 推荐一款开源的SQL Server存储过程对比工具

http://www.codeproject.com/KB/database/StoredProceduresComparer.aspx 

2010-04-29 09:55:00 1342

原创 使用sys.SQL_Modules获取SQL Server数据库对象(存储过程,视图,函数)定义脚本

 USE  tempdb;goCREATE  PROC prDummyASBEGIN   SELECT 1END goCREATE  VIEW vwDummyAS   SELECT 1 ColAgo   CREATE

2010-04-27 18:21:00 1625

转载 使用T-SQL将数据设置为在线或者离线(SQL SERVER – T-SQL Script to Take Database Offline – Take Database Online)

原文:http://blog.sqlauthority.com/2010/04/24/sql-server-t-sql-script-to-take-database-offline-take-database-online/ SQL SERVER – T-SQL Script to Take Database Offline – Take Database Online from S

2010-04-26 19:33:00 2517

转载 对使用sys.dm_exec_query_stats动态视图者的警告(A Warning to Those Using sys.dm_exec_query_stats)

原文:http://sqlblog.com/blogs/adam_machanic/archive/2010/04/22/a-warning-to-those-using-sys-dm-exec-query-stats.aspx Adam MachanicAdam Machanic, Boston-based independent database consultant, wri

2010-04-26 19:08:00 1390

原创 使用数据库级触发器记录数据库更改历史

 --//CREATEgoUSE--CREATE DDLHistory( [Login] NVARCHAR(100), [Action] NVARCHAR(100), [Schema] NVARCHAR(100 ),Object TSQL )go

2010-04-26 10:25:00 1090

原创 T-SQL重建所有数据库的所有表的索引

DECLARE @Database VARCHAR(255)DECLARE @Sqlcmd VARCHAR(1000)DECLARE @Test BITSET @Test = 1DECLARE DatabaseCursor CURSOR FORWARD_ONLY READ_ONLY FORSELECT name FROM master.dbo.sysdatabases WHER

2010-04-09 14:13:00 1543

关于SQL注入的资料-3

关于SQL注入的资料-3,讲解常见的sql注入攻击及其防范

2009-05-08

关于SQL注入的资料-2

关于SQL注入的资料-2,讲述sql注入高级技巧

2009-05-08

关于SQL注入的资料-1

关于SQL注入的资料-1,讲述如何通过sql注入操纵SQL Server

2009-05-08

一个Windows界面的TableDiff表比较工具

一个Windows界面的TableDiff表比较工具,可比较表记录差异

2009-04-16

SQL Server DBA best practice

SQL Server DBA best practice by EMC2

2009-04-14

SQL Server 执行计划详解

SQL Server 2005 执行计划详解

2009-04-10

戏说面向对象程序设计C#版.pdf

戏说面向对象程序设计C#版,语言幽默风趣很适合初学者入门面向对象编程。

2009-04-03

SQL Server2005微软认证教材

MCTS Self-Paced Training Kit (Exam 70-431) - Microsoft SQL Server 2005 Implementation and Maintenance

2009-04-03

C# 多线程编程 详解

This book provides an introduction to writing concurrent programs with “threads”. A threads facility allows you to write programs with multiple simultaneous points of execution, synchronizing through shared memory. The paper describes the basic thread and synchronization primitives, then for each primitive provides a tutorial on how to use it. The tutorial sections provide advice on the best ways to use the primitives, give warnings about what can go wrong and offer hints about how to avoid these pitfalls. The paper is aimed at experienced programmers who want to acquire practical expertise in writing concurrent programs. The programming language used is C#, but most of the tutorial applies equally well to other languages with thread support, such as Java.

2009-04-03

C# 技术面试 宝典

C# 技术面试 宝典 What methods are fired during the page load? Init () When the page is instantiated, Load() - when the page is loaded into server memory,PreRender () - the brief moment before the page is displayed to the user as HTML, Unload() - when page finishes loading.

2009-04-03

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人

提示
确定要删除当前文章?
取消 删除