- 博客(37)
- 资源 (2)
- 收藏
- 关注
原创 PowerShell:Power Shell 安装
Windows Power Shell是微软提供给系统管理员和IT人员的一个外壳工具和脚本运行环境,可以通过编程实现对系统的自动化管理和操作。 Power Shell最初的代号是Monad,也成为Microsoft Shell (MSH),是参考UNIX的SHELL模式,基于Windows平台下的内建脚本语言以及辅助脚本程式的工具。从2003年的第一个beta版本发布开始,微软不断的更新并完善Po
2015-06-17 15:24:21
2104
转载 T-SQL:zz检查文件夹下的文件大小
原文:Check Up Size Of Each Folder In a Path,版权归原作者. 贴过来备用:USE [DB_Maint]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF OBJECT_ID(N'[dbo].[usp_Folder_Size_Check]') IS NOT NULLBEGIN DROP PROCEDUR
2015-06-11 20:38:11
574
原创 SSRS:报表开发中的一些小技巧
1.文本多行显示的处理方法。 参考SSRS: Multiple Ways to Split a String into Multiple Lines (1) 使用VB的换行符 VBCRLF (2)使用ASCII码的转换符 CHR(10) (3)使用HTML的转换符 BR 值得注意的是,在使用HTML转换符时,需要该控件支持HTML属性,设置对应的控件的HTML属性, 例子:-- VBCR
2015-06-10 22:44:52
1486
转载 T-SQL:[zz]SQL Server NOLOCK Hint & other poor ideas.
今天逛论坛看到问NOLOCK的问题,搜到MSDN上有一篇比较好的文章,转载到这里。留爪! SQL Server NOLOCK Hint & other poor ideas
2015-05-29 21:03:08
524
原创 T-SQL: GROUP BY
GROUP BY的用法:GROUP BY (Transact-SQL) -- Declare Table variable.. DECLARE @tbA TABLE ( ID INT NOT NULL IDENTITY(1,1) ,
2015-05-26 11:42:29
1099
原创 SSRS:按月汇总的动态表头实现-Matrix Control
前言: 工具是为实现需求服务的。不同的工具提供了不同的方式,在选择过程中,选择最优最快的实现方式,这是一个成熟的码农必备的技能。本篇参考了CodeProject上的这篇文章:Using SSRS - Matrix Control to Generate Columns Dynamically 场景:SQL Server 2012 AdventureWorks2012 数据库。 目的:实现按照用
2015-05-15 12:19:34
1337
1
原创 SSRS:如何消除SSRS报表导出EXCEL出现的合并列和隐藏列
在SSRS报表开发中,经常会遇到报表导出为EXCEL格式的文档。而SSRS导出过程中,由于报表本身设计的问题,导致导出的EXCEL文档中会出现合并列或者隐藏列。本文将介绍几种常见的消除SSRS报表导出EXCEL出现的合并列和隐藏列的方法。文中的方法参考了MSDN的Blog:How to eliminate merged and hidden Cells issue from Excel Export
2015-05-13 20:33:28
3437
原创 T-SQL: JOIN的几种关系
SQL Server提供了多种JOIN机制,在联机丛书FROM (Transact-SQL)中列举了四种JOIN操作.1.INNER JOIN(交集) INNER JOIN在数学上是指两个集合的交集,数学符号∩。如下图所示,图中红色部分则为INNER JOIN的结果。 例如: {1, 2} ∩ {1, 2} = {1, 2}. {1, 2} ∩ {2,
2015-04-23 00:31:25
1091
原创 T-SQL:取最值的几种方式的简单比较.
通常情况下,都会遇到取最值的情况,T-SQL提供了多种方式实现最值比较,简单罗列几种。 1. NOT EXISTSUSE [AdventureWorks2012];GODBCC FREEPROCCACHE;GOSET STATISTICS PROFILE ON;SET STATISTICS IO ON;SET STATISTICS TIME ON;SELECT DISTINCT
2015-04-19 01:13:11
663
原创 T-SQL:提取第一次出现的数字组合
问题:提取任意字符串中第一次出现的数字组合。USE [AdventureWorks2012];GODECLARE @t_TB TABLE( ColVal VARCHAR(20));INSERT INTO @t_TB VALUES ('ABC123'), ('ENA329'), ('EEE22W33'), ('F1W2C3E8'), ('DDDDDDD'
2015-04-19 00:32:33
565
转载 怎么判断某个库中的某张表在某个时间段有没有被使用过
今天逛论坛,遇到一个经常问的问题,怎么判断某个库中的某张表在某个时间段有没有被使用过?记得以前在Aaron Bertrand的Blog上看到过,去翻一翻,找到了转过来.When was my database / table last accessed? 里面提到了几种方法,列举如下: 1.使用SQL Server审计功能,通过审计功能的记录看判断对应的数据库对象的最后访问时间。USE mas
2015-04-18 20:38:36
759
转载 学习SQL Server推荐的10本书
今天在sqlmag上闲逛,看到了这篇一年前写的文章,正好在看其中的一本,推荐给大家。原文地址:Top 10 Highly Recommended SQL Server Books.
2015-04-17 23:28:32
20171
3
原创 怎样在报表中显示HTML/RTF内容系列之二-将HTML内容存储为RTF格式
首先声明,本系列从本节开始,没有特别说明的情况下均是以SQL Server 2005和Reporting Service 2005为基础展开的讨论。将HTML内容存储为RTF格式,在基于.NET架构下有很多免费和付费控件可以参考,有基于JavaScript编写的,也有基于WinForm下的RichTextBox集成的。如下简单介绍几种常见的Web页面下使用的RichTextBox.1) F
2009-10-21 10:58:00
2267
1
原创 怎样在报表中显示HTML/RTF内容系列之一-SSRS 2008中显示HTML内容
怎样在报表中显示HTML/RTF内容系列-SSRS 2008中显示HTML内容SSRS 2008中显示HTML内容? 在一些报表项目中需要使用到对HTML内容的展示,本系列主要阐述SSRS 2005中怎样显示HTML/RTF内容的主要步骤和实现方式。但是对于SSRS 2008已经支持的技术而言,本文将简述针对SSRS 2008对HTML内容的显示,在后续的系列中将重点阐述SSRS 2005
2009-10-15 11:48:00
1635
转载 zz 0ffice 2007 something.....
1.安装 Office 2007时勿输入序列号; 2.安装完成,不要运行 Word、Excell 等任何 Office 程序组件; 3.进入目录:C:/Program Files/Common Files/Microsoft Shared/Office 12/Office Setup Controller/Proof.en;找到此 xml 文件,用记事本打开编辑: 将语句中的 AlwaysInst
2009-06-09 00:01:00
725
翻译 Reporting Services 2005 for the DBA – Reporting Services Encryption 2 of 2
Author: Steve Chowles http://sqlblogcasts.com/blogs/stevechowles/archive/2007/08/28/reporting-services-2005-for-the-dba-reporting-services-encryption-2-of-2.aspx This is the second part of my t
2008-05-24 11:42:00
2233
翻译 Reporting Services 2005 for the DBA – Reporting Services Encryption 1 of 2
Author:Steve Chowles http://sqlblogcasts.com/blogs/stevechowles/archive/2007/08/14/reporting-services-2005-for-the-dba-reporting-services-encryption-1-of-2.aspx If you understand how Reporting
2008-05-22 23:47:00
1803
1
翻译 Reporting Services 2005 for the DBA – IIS Security
Author:stevechowleshttp://sqlblogcasts.com/blogs/stevechowles/archive/2007/06/08/reporting-services-2005-for-the-dba-iis-security.aspx This is the second part of my IIS article which today covers II
2008-05-20 21:45:00
1418
翻译 Reporting Services 2005 for the DBA – IIS
Author:stevechowleshttp://sqlblogcasts.com/blogs/stevechowles/archive/2007/06/08/reporting-services-2005-for-the-dba-iis.aspx One of the most misunderstood aspects of Reporting Services is how it fi
2008-05-20 19:52:00
1639
转载 Sarbanes-Oxley compliance checklist: IT security and SQL audits
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1312646,00.html?track=NL-416&ad=637013&asrc=EM_NLT_3610732&uid=6118215Michelle Gutzait05.07.2008Problem: My company needs to meet Sar
2008-05-10 09:06:00
2815
转载 Using Reporting Services to Search the SQL Server Log
http://www.sqlservercentral.com/articles/Reporting+Services/62934/By Carolyn Richardson, 2008/05/06 Total article views: 4172 | Views in the last 30 days: 4172 Rate this | Join the discussio
2008-05-10 09:02:00
926
转载 Create DDL table in SQL Server 2005 to audit DDL trigger activity
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1312369,00.html?track=NL-417&ad=638703&asrc=EM_NLT_3593059&uid=6118215Robert Sheldon05.05.2008Prior to SQL Server 2005, you could define
2008-05-10 08:59:00
2055
转载 More with SQL Server 2005 : Top n Per Group, Paging, and Common Table Expressions
http://weblogs.sqlteam.com/jeffs/archive/2007/03/30/More-SQL-Server-2005-Solutions.aspx#38351Jeff Smith I previously wrote about a few of the new features in SQL 2005 and how they can be used to s
2008-05-09 12:58:00
1325
转载 Importing Excel data with SQL Server Integration Services and dealing with unicode and non-unicode data issues
http://www.mssqltips.com/tip.asp?tip=1393 SSIS中关于Unicode和Non-Unicode的转换,主要是添加Data Convertion 控件来转换即可,注意CodePage的属性,需要设置启用默认的codepage为True.
2008-05-03 11:11:00
1125
翻译 Reporting Services 2005 for the DBA – Changing Application Pool Identity
http://sqlblogcasts.com/blogs/stevechowles/archive/2007/07/02/reporting-services-2005-for-the-dba-changing-application-pool-identity.aspxAuthor:Steve Chowles报表服务DBA系列之应用程序缓存池身份更改 By default
2008-04-29 22:39:00
1346
翻译 Reporting Services 2005 for the DBA – Connectivity Issues
Reporting Services 2005 for the DBA – Connectivity Issues 报表服务之DBA系列 –关于连接 http://sqlblogcasts.com/blogs/stevechowles/archive/2007/07/02/reporting-services-2005-for-the-dba-connectivity-issues.a
2008-04-27 22:36:00
1381
翻译 Reporting Services 2005 for the DBA – Double Hop Authentication
By : Steve Chowles http://sqlblogcasts.com/blogs/stevechowles/archive/2007/07/03/reporting-services-2005-for-the-dba-double-hop-authentication.aspx One of the issues which crop up time and time agai
2008-04-16 00:21:00
2589
2
转载 Concatenating row values in Transact-SQL
http://www.projectdmx.com/tsql/rowconcatenate.aspxBy Umachandar Jayachandran, Linda Wierzbecki, Bruce Margolin, Roy Harvey, Eugene Kogan, Vadim Tropashko, Anub Philip.
2008-04-13 12:07:00
1240
转载 Custom Auto-Generated Sequences with SQL Server
http://www.sqlteam.com/article/custom-auto-generated-sequences-with-sql-serverBy Jeff SmithThis article by Jeff Smith covers different ways to create sequence numbers. It starts with the basic id
2008-04-13 11:37:00
1277
转载 Find Nth maximum value in SQL Server
http://www.sqlteam.com/article/find-nth-maximum-value-in-sql-serverBy Guest Authors on 11 April 2004 | 13 Comments | Tags: SELECT This aritlce is written by Hariharan Velayuthan. He writes
2008-04-10 21:52:00
1587
2
转载 To SP or not to SP in SQL Server: an argument for stored procedures
http://www.simple-talk.com/sql/t-sql-programming/to-sp-or-not-to-sp-in-sql-server-an-argument-for-stored-procedures/The database-as-API approachBy Adam MachanicThis article is adapted from Ada
2008-04-09 21:10:00
910
转载 How to check Fragmentation on SQL Server 2005
http://blogs.msdn.com/jorgepc/archive/2007/12/09/how-to-check-fragmentation-on-sql-server-2005.aspxAuthor: jorgepc I have been asked this question several times: Is there a tool in SQL Server whe
2008-04-09 21:07:00
1599
转载 Document Sarbanes-Oxley compliance with SQL Server 2005
http://blogs.techrepublic.com.com/datacenter/?p=323&tag=nl.e046 Author: Tim Chapman As the DBA for revenue-generating applications, I am frequently invited by my CIO to meetings with Sarbanes-Ox
2008-04-08 21:03:00
798
原创 Batch update table name using *sp_rename*
扩展存储过程sp_rename的使用方法:sp_rename [ @objname = ] object_name , [ @newname = ] new_name [ , [ @objtype = ] object_type ] USE [DATABASENAME]GODECLARE @i intDECLARE @count intDECLARE
2008-04-08 14:11:00
637
转载 SQL Server 2005 Service Pack 2 (SP2) Re-release and post fixes explained
http://blogs.msdn.com/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspxSQL Server 2005 Service Pack 2 (SP2) Re-release and post fixes explainedThe dust has n
2008-04-02 10:32:00
2424
2
转载 Stored procedures: Find columns and tables
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1109458,00.htmlthe author: Brian Walker is a senior database architect in an IS department that uses SQL Server 2000 and the .NET Framewor
2008-03-28 21:55:00
848
转载 [转贴]How do I find a stored procedure containing ?
http://databases.aspfaq.com/database/how-do-i-find-a-stored-procedure-containing-text.htmlI see this question at least once a week. Usually, people are trying to find all the stored procedures that
2008-03-28 21:33:00
883
SSRS: 动态表头的Matrix实现的源代码
2015-05-15
EliminateMergedAndHiddenCells
2015-05-13
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人