THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server   (RSS)
Showing page 2 of 53 (527 total posts)
  • 24 hours of PASS is back!

    The most important free on-line event on SQL Server and Business Intelligence is back! The 24 Hours of PASS is coming back with a great edition fully based on the new features of SQL Server 2014. Register now at this link. No matter from what part of the world you will follow the event, the important thing is to know that it will be 24 ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on June 5, 2014
  • Columnstore Case Study #2: Columnstore faster than SSAS Cube at DevCon Security

    Preamble This is the second in a series of posts documenting big wins encountered using columnstore indexes in SQL Server 2012 & 2014.  Many of these can be found in my big deck along with details such as internals, best practices, caveats, etc.  The purpose of sharing the case studies in this context is to provide an ...
    Posted to Jimmy May (Weblog) by aspiringgeek on May 26, 2014
  • Columnstore Case Study #1: MSIT SONAR Aggregations

    Preamble This is the first in a series of posts documenting big wins encountered using columnstore indexes in SQL Server 2012 & 2014.  Many of these can be found in this deck along with details such as internals, best practices, caveats, etc.  The purpose of sharing the case studies in this context is to provide an easy-to-consume ...
    Posted to Jimmy May (Weblog) by aspiringgeek on May 19, 2014
  • Annual SQL Server conference in Poland - SQLDay 2014

    We had a great 3-days conference this year in Poland. The SQLDay (7th edition) is an annual community conference. We started in 2008 as a part of C2C (community to communities) conference and after that, from 2009 the SQLDay is the independent event dedicated to the SQL Server specialists.  This year we had almost 300 people and speakers ...
    Posted to Damian Widera (Weblog) by Damian Widera on May 16, 2014
  • Restart Framework added to SSIS Reporting Pack

    On 31st March 2014 I released version 1.2.0.0 of SSIS Reporting Pack, my open source project that aims to enhance the SSIS Catalog that was introduced in SSIS 2012. This is a big release because it includes an entirely new feature  -the Restart Framework. Introduction The Restart Framework exists to cater for a deficiency within SSIS, ...
    Posted to Jamie Thomson (Weblog) by jamiet on April 12, 2014
  • SQL Server 2014 has come into the light - the RTM will be available on 1st April

    ''Today I am very happy to announce SQL Server 2014 has been released to manufacturing and will be generally available on April 1.''  More details here: http://blogs.technet.com/b/microsoft_blog/archive/2014/03/18/sql-server-2014-released-to-manufacturers-will-be-generally-available-april-1.aspx and ...
    Posted to Damian Widera (Weblog) by Damian Widera on March 18, 2014
  • SSDT gets some small enhancements for SQL Server 2014

    Release-to-manufacturing of SQL Server 2014 was announced today and with it comes some welcome news about some small enhancements to SSDT: The SSDT team has been heads down getting our SQL Server 2014 release ready to go.  However we've made time to make some targeted improvements in this area.  In our upcoming release for SQL Server ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 18, 2014
  • Strange behaviour on CHECK constraint

    Last Friday I asked myself: imagine I have a CHECK constraint enabled on a column in a table. What would happen if I try to enable it again? My question is not about ''expecting some error'' - I expect that the engine will check if the constraint is enabled and if it is - nothing will be made.If the constraint was off and the on - the SQL ...
    Posted to Damian Widera (Weblog) by Damian Widera on March 16, 2014
  • How In-Memory Database Objects Affect Database Design: Getting Started

    Weird, somehow I lost text in the middle of this post after it was posted... I created it a few days back and set it to post later... Corrected. So I put in the following abstract for Devlink (and may for SQL Saturday Orlando and/or PASS Summit.) I don't know if I will get accepted, but I am pretty excited to work on this topic one ...
    Posted to Louis Davidson (Weblog) by drsql on March 10, 2014
  • Capturing query and IO statistics using Extended Events

    The commands SET STATISTICS TIME ON SET STATISTICS IO ON   return information about query executions and are very useful when doing performance tuning work as they inform how long a query took to execute and the amount of IO activity that occurred as a result of that query. These are very effective ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 5, 2014
< Previous 1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement