自定义博客皮肤VIP专享

*博客头图:

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

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

博客底图:

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

栏目图:

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

主标题颜色:

RGB颜色,例如:#AFAFAF

Hover:

RGB颜色,例如:#AFAFAF

副标题颜色:

RGB颜色,例如:#AFAFAF

自定义博客皮肤

-+

OK_008

No incapable except unthinkable

  • 博客(7)
  • 资源 (17)
  • 收藏
  • 关注

原创 PowerShell应用之-事务复制

概述  在之前的几篇描述了PowerShell在SQL Server对SMO(SQL Server Management Objects)的管理,现在开始描述在SQL Server Replication中如何使用PowerShell脚本实现同步复制功能。在本篇中讲述的是实现同步复制中的事务复制,涉及如何创建Publishing,Distribution, Publication,

2011-11-22 23:52:21 905

原创 还原某一个目录下的所有数据库备份文件

引述在工作中,经常为测试或开发部门搭建数据库环境,每一次搭建环境,需要还原某一个目录下的所有数据库备份文件,也就是,一次需要还原一百多个数据库。每碰到类似的情况,需要编写一个SQL脚本来实现还原数据库的功能。这里就简单介绍如何编写存储过程来实现,还原某一个目录下的所有数据库备份文件。要实现还原某一个目录下的所有数据库备份文件,首先要实现还原某一个目录下的某一个备份文件。真实世界

2011-11-04 08:13:47 806

原创 合并SQL脚本文件

概述     在平时的工作中,我会经常的碰到这样需要合并SQL脚本的问题。如,有很多的SQL脚本文件,需要按照一定的先后顺序,再生成一个合并SQL脚本文件,然后再发布到用户SQL Server服务器上。    合并SQL脚本文件,最直接的方法就是新建1个空白的SQL脚本文件,再把需要合并的SQL脚本文件内容复制到新建的SQL文件中。当初,我合并脚本的操作方法与刚说的有类似。我在Micr

2011-11-04 08:12:35 775

原创 SQL Server 同步复制中的MSSQL_REPL-2147201001問題處理

引述  首先,说我为什么写这篇文章,它让你了解到什么,对你是否有帮助。要是你是刚接触SQL Server同步复制,那么你可能会碰到各种各样的问题,你可能不会从哪里入手解决,或者你从Baidu,Google上找到解决问题的方法,但你很多时候只看到别人说的答案,很少有人去写分析其中的原因,倘若你没有找其他资料或查阅帮助文档了解为什么,以后你碰到同样问题,你也只能照搬之前的答案,有时候碰巧正

2011-11-04 08:11:49 1455

原创 了解SQL Server触发器及触发器中的事务

引述      首先, 说下我写篇文章的目的,我希望能把我对触发器的理解,分享出来与你一起学习。如果你有对触发器和事务的概念,有些了解,这篇文章,对你来说会是很简单,或能让你更进一步的了解触发器里面的一些故事,和触发器中事务个故事。在这边文章里面,我不会从触发器和事务的概念去讲述,而是从常见的两种触发器类型(DML触发器 & DDL触发器)和After触发器 &  Instead Of

2011-11-04 08:08:40 716

原创 可更新订阅的事务复制错误:列名 'msrepl_tran_version' 无效

问题描述:   首先,不知道你有没有类似的经历,在可更新订阅的事务复制,当初始化订阅时,发生了类似这样的错误:列名 'msrepl_tran_version' 无效 。(源: MSSQLSERVER,错误号: 207 )         图1.通过复制监视器来检查错误    图2.通过作业的历史记录来检查错误 问题分析:   我们知道,在

2011-11-04 08:07:44 1289

原创 在运行SSIS包时,如何动态更新变量值

实现方式:        若要动态更新变量,可以为变量创建配置,将这些配置部署到包中,然后在部署包时更新配置文件中的变量值。这样,在运行时,包就可以使用更新后的变量值。        下面通过一个简单的例子来说明如何实现动态更新变量值。例子要求:        把一张Order表从远程计算机实例“TRIY-2FE792BB5D\SQL2008DE” 根据需要输入(Order.dbo

2011-11-04 08:06:37 2298

CodeSmith Generator 7.0.2.15174 (含注册机)

CodeSmith Generator 7.0.2.15174 官方最新原版程序+注册机+教程(包含图文教程)

2015-06-13

Myeclipse+2013-SR1+破解文件和破解说明

针对Myeclipse 2013 SR1版本,可以破解!

2013-08-09

Physical Database Design (2007)

The rapidly increasing volume of information contained in relational databases places a strain on databases, performance, and maintainability: DBAs are under greater pressure than ever to optimize database structure for system performance and administration. Physical Database Design discusses the concept of how physical structures of databases affect performance, including specific examples, guidelines, and best and worst practices for a variety of DBMSs and configurations. Something as simple as improving the table index design has a profound impact on performance. Every form of relational database, such as Online Transaction Processing (OLTP), Enterprise Resource Management (ERP), Data Mining (DM), or Management Resource Planning (MRP), can be improved using the methods provided in the book. · The first complete treatment on physical database design, written by the authors of the seminal, Database Modeling and Design: Logical Design, 4th edition. · Includes an introduction to the major concepts of physical database design as well as detailed examples, using methodologies and tools most popular for relational databases today: Oracle, DB2 (IBM), and SQL Server (Microsoft). · Focuses on physical database design for exploiting B+tree indexing, clustered indexes, multidimensional clustering (MDC), range partitioning, shared nothing partitioning, shared disk data placement, materialized views, bitmap indexes, automated design tools, and more!

2013-07-26

Manning.Windows.PowerShell.in.Action

非常好的一本有关PowerShell的电子书,值得下载。 Windows has an easy-to-use interface, but if you want to automate it, life can get hard. That is, unless you use PowerShell, an elegant new dynamic language from Microsoft designed as an all-purpose Windows scripting tool. PowerShell lets you script administrative tasks and control Windows from the command line. Because it was specifically developed for Windows, programmers and power-users can now do things in a shell that previously required VB, VBScript, or C#. Windows PowerShell in Action was written by Bruce Payette, one of the founding members of the Windows PowerShell team, co-designer of the PowerShell language and the principal author of the PowerShell language implementation. From him you will gain a deep understanding of the language and how best to use it, and you'll love his insights into why PowerShell works the way it does. This book is a tutorial for sysadmins and developers introducing the PowerShell language and its environment. It shows you how to build scripts and utilities to automate system tasks or create powerful system management tools to handle the day-to-day tasks that drive a Windows administrator's life. It's rich in interesting examples that will spark your imagination. The book covers batch scripting and string processing, COM, WMI, and even .NET and WinForms programming.

2013-06-26

WPF编程%28第二版%29中文版00008

原书名: Programming WPF 原出版社: O'Reilly Media, Inc. 作者: (美)Chris Sells Ian Griffiths 译者: 金璐;夏明才[同译者作品] 出版社:机械工业出版社 这本书的设计初衷是让你快速掌握微软的Windows Presentation Foundation(WPF)技术,如果想要完全利用Windows Vista和Windows XP用户界面的功能来创建应用程序,那么这一项就是你所要学习的技术。当读到第二页时,你将会编写一个简单的WPF应用程序。当读到第一章结尾时,你就已经遍览了WPF中的主要元素。. 这本《WPF编程》第二版根据WPF正式发布版进行了更新,其中包括导航、文本与文档、打印与XPS以及3D图形等章节,另外还有一章新的附录,涵盖了微软近期发布的Silverlight平台,该平台主要通过标准Web浏览器为用户传递更为丰富的用户界面——它与Adobe Flash十分相似。

2013-06-23

SQL_Server_2000_2005_2008_2008_R2查询智能分析器RedGate_SQL_Prompt_V5.3.4.1

SQL_Prompt_V5.3.4.1 支持SQL Server 2000/2005/2008,同时也支持最新版本的SQL Server 2012 .破解文件能用

2013-05-03

SAP中英文词典

SAP中英文词典,记录有1万多条有关SAP里面应用到的中英文对照

2013-04-15

BI职业生涯规划

BI职业生涯规划,感觉说的有道理,而且全面实用。

2013-04-01

MySQL技术内幕(第4版).pdf

本书介绍了MySQL 的基础知识及其有别于其他数据库系统的独特功能,包括SQL 的工作原理和 MySQL API 的相关知识;讲述了如何将MySQL 与Perl 或PHP 等语言结合起来,为数据库查询结果生成动态Web 页面,如何编写MySQL 数据访问程序;详细讨论了数据库管理和维护、数据目录的组织和内容、访问控制、安全连接等。附录还提供了软件的安装信息,罗列了MySQL 数据类型、函数、变量、语法、程序API 等重要细节。

2013-01-15

MySQL_5.5_Help(Chinese)

这是MySQL参考手册的翻译版本,它涉及MySQL 5.5至5.5.2-alpha版本。

2013-01-14

PowerDesigner16破解

PowerDesigner 16.0 感觉不错。

2012-03-18

Programming+Python,+4th+Edition(2/2)

If you’ve mastered Python’s fundamentals, you’re ready to start using it to get real work done. Programming Python will show you how, with in-depth tutorials on the language’s primary application domains: system administration, GUIs, and the Web. You’ll also explore how Python is used in databases, networking, front-end scripting layers, text processing, and more. This book focuses on commonly used tools and libraries to give you a comprehensive understanding of Python’s many roles in practical, real-world programming. You’ll learn language syntax and programming techniques in a clear and concise manner, with lots of examples that illustrate both correct usage and common idioms. Completely updated for version 3.x, Programming Python also delves into the language as a software development tool, with many code examples scaled specifically for that purpose. Topics include: Quick Python tour: Build a simple demo that includes data representation, object-oriented programming, object persistence, GUIs, and website basics System programming: Explore system interface tools and techniques for command-line scripting, processing files and folders, running programs in parallel, and more GUI programming: Learn to use Python’s tkinter widget library Internet programming: Access client-side network protocols and email tools, use CGI scripts, and learn website implementation techniques More ways to apply Python: Implement data structures, parse text-based information, interface with databases, and extend and embed Python

2011-05-29

Programming+Python,+4th+Edition(1/2)

If you’ve mastered Python’s fundamentals, you’re ready to start using it to get real work done. Programming Python will show you how, with in-depth tutorials on the language’s primary application domains: system administration, GUIs, and the Web. You’ll also explore how Python is used in databases, networking, front-end scripting layers, text processing, and more. This book focuses on commonly used tools and libraries to give you a comprehensive understanding of Python’s many roles in practical, real-world programming. You’ll learn language syntax and programming techniques in a clear and concise manner, with lots of examples that illustrate both correct usage and common idioms. Completely updated for version 3.x, Programming Python also delves into the language as a software development tool, with many code examples scaled specifically for that purpose. Topics include: Quick Python tour: Build a simple demo that includes data representation, object-oriented programming, object persistence, GUIs, and website basics System programming: Explore system interface tools and techniques for command-line scripting, processing files and folders, running programs in parallel, and more GUI programming: Learn to use Python’s tkinter widget library Internet programming: Access client-side network protocols and email tools, use CGI scripts, and learn website implementation techniques More ways to apply Python: Implement data structures, parse text-based information, interface with databases, and extend and embed Python

2011-05-29

iBatis in action (PDF)

iBATIS in Action teaches Java developers and architects how to use the iBATIS framework to map relational databases to object-oriented programs. Written by the creator of iBATIS, this practical book presents patterns and solutions that readers can apply immediately. iBATIS in Action shows Java developers how to tackle the problem of data persistence using the elegant iBATIS framework. iBATIS helps developers solve the problem of connecting- or mapping- relational databases to object-oriented code. An extensive running example presents reusable iBATIS patterns and common solutions. The sample application shows where iBATIS fits in a typical web application as well as how iBATIS integrates with other popular frameworks like Struts. iBATIS in Action focuses on solving existing problems without introducing new ones. In addition to showing what iBATIS does, iBATIS in Action also shows how iBATIS solves problems. Readers explore the driving design philosophy behind iBATIS as presented by iBATIS creator Clinton Begin.

2010-01-28

在Linux下安装Oracle9i

在Linux下安装Oracle9i,一老外写的,非常详细。

2007-09-07

SQLServer2000常用函数大全及个人收藏

SQLServer2000常用函数大全及个人写的SQL语句整理收藏.看完看懂里面的70%,相信你至少是小牛人。(另:本人菜鸟,自感觉不错特拿来共享,希望大家喜欢。)

2007-04-30

空空如也

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

TA关注的人

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