There are several reasons why it is beneficial to use parameters in the queries. It mitigates security risks by protecting from SQL Injection. Moreover, it helps with the performance. Query optimization is expensive and resource-intensive process. SQL Server reduces that cost by keeping execution pl

(Pinal Dave) I think we the series on various reports, we come to a logical point. We covered all the reports at server level. This means the reports we saw were targeted towards activities that are related to instance level operations.

(Allen White) We recently learned how to set up a Microsoft Azure virtual machine (VM) with SQL Server, but in a “real world” environment, there’s a lot more configuration you need to do to set up SQL Servers.

(blakhani) Below are the most common search terms when someone is sees a big file with extension LDF and identifies that it’s used by SQL Server.

CodeFluent Entities can use SQL Server specific data types such as Geography, Geometry and HierarchyId.

(Sunil Agarwal) As described in the blog http://blogs.msdn.com/b/sqlserverstorageengine/archive/2014/07/27/clustered-column-store-index-concurrency-and-isolation-level.aspx , the clustered column store index has been optimized for typical DW scenario supporting nightly or trickle data load with fas

(Marcin Policht) Management of Azure SQL Databases has been greatly simplified by introduction of the Azure PowerShell module, which includes a collection of cmdlets that handle the most common administrative tasks targeting cloud-resident SQL Server instances and their databases.

(Kenneth Fisher) When you use the SchemaBinding keyword while creating a view or function you bind the structure of any underlying tables or views. So what does that mean?

(Pinal Dave) The month of June till mid of July has been the fever of sports. First, it was Wimbledon Tennis and then the Soccer fever was all over. There is a huge number of fan followers and it is great to see the level at which people sometimes worship these sports.

(Chris Skorlinski) While troubleshooting a customers environment I encountered the following 9003 Exception error message captured in SQL Server Profiler.