Serial: An Introduction to SQL Server Features Case Scenario In the previous articles of this serial, I’ve introduced how to use SQL Server as database for
Serial: An Introduction to SQL Server Features Case Scenario For this ETL project, the requirements are listed below: Sales data will be pushed to specified
Serial: An Introduction to SQL Server Features Case Scenario After the data is loaded into the database, reports can be built using SSRS (SQL Server Reporting
Serial: An Introduction to SQL Server Features Case Scenario All the samples in this serial will focus on one virtual company that produces and sales mobile

In this article, I am going to summarize some topics regarding SQL Server 2012 together, including T-SQL, Programing, Database Maintenance, Performance Tuning, Data Types, CLR Integration, Business Intelligence, and Applications and so on. The page will be updated continuously with new blog links.

In this article, I am going to demonstrate how to use CLR (Common Language Runtime) data types and functions in SQL Server.

There are a lot of useful T-SQLs we can use in daily work to make things simple. Check transaction log files space usage DBCC SQLPERF (LOGSPACE); Backup Server
背景 我的本机已经安装VS2012以及VS2013 Preview,前几天为了帮朋友调试一个项目,我装了VS2010。没想到安装后SQL Server Data Tools在VS2012的项目中不能被加载,如下图所示: 解决方案 前至微软官方网站下载此Tool重新安装: http://msdn.microsoft.com/en-us/jj650015
背景 在Windows系统中,当我们从共享路径或者未信任的网络允许可执行程序时,如果程序未签名那么系统就会提示是否允许执行程序;只有当允许后,程序才能继续执行。当我们需要在一些自动化运行解决方案中调用此类未签名程序时,则会遇到麻烦,因为无法交互。在以前一个SSIS项目中,我们则遇到了类似的麻烦:在SSIS的Package中,需要调用一个放置于共享文件夹中的未签名的Console程序(通过Process类)或者直接添加Execute
在低版本SQL Server中,对于一些常用的查询功能,我们可能需要运用复杂的逻辑,如临时表,游标等等来实现,这样可能会导致代码难维护,同时产生性能问题。本文将简述用自带的功能去简单的实现这些操作。 注意:一些功能仅在SQL Server 2012以及以上版本支持。 1.查询分页 (OFFSET, FETCH)

Subscription

Statistics

Locations of visitors to this page