全部博文（69）
发布时间：2015-03-28 12:50:25
Installation Steps:1. DownloadWindows server 2012 evaluation (180 days)2. Download SQL Server 20123. Download SharePoint 2013 evaluation trial key: NQTMW-K63MQ-39G6H-B2CH9-FRDWJAfter installation of SQL Server and SharePoint, I was going through the SharePoint Configuration .........【阅读全文】
发布时间：2015-02-12 03:40:03
SQL2012 提示评估已过期 解决方案提示评估已过期的解决方法和 sql2008一样第1步：进入SQL2012配置工具中的安装中心第2步：再进入维护界面，选择版本升级第3步：进入产品密钥，输入密钥第4步：一直点下一步，直到升级完毕。密钥MICROSOFT SQL SERVER 2012 DEVELOPER 版（开发版）序列号：YQWTX-G8T4R-QW4XX-B.........【阅读全文】
发布时间：2014-12-15 17:26:02
/*There is a column with data like 'plase20080412OK', 'jdjldk19351123', please write a query to get the Date value.*/Create table #GetDateStr (String1 varchar(50))insert into #GetDateStr values ('please20080412ok'), ('Jane19880416Hi'), ('euout19950612dk');/*The subquery is used to trim th.........【阅读全文】
发布时间：2014-12-13 15:08:18
Today, I delete some rows from a table accidentally, and the worst is that I didn't backup any databases including log. Fortunately, I found a original copy in another sql server, so I added the server link to get the rows back.IF EXISTS(SELECT * FROM sys.servers WHERE name = N'.........【阅读全文】
发布时间：2014-11-12 03:28:51
During Learning of MSBI Stack: SSIS, SSAS, SSRS, I got a lot from the following sharing:1. BIWORK -- http://www.cnblogs.com/biwork/from http://www.cnblogs.com/Summarized very well, I really understood SSAS from here.2. 专注微软平台的商业智能解决方案http.........【阅读全文】
