in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » SQL (RSS)

Browse by Tags

  • Loads of things going on at #SQLBits

    Wow its been a busy few weeks in SQLBits land. Session Voting We’ve opened up voting for the sessions for SQLBits 10 http://sqlbits.com/information/PublicSessions.aspx Make sure you vote so we pick the sessions you want. You’ve got to register on the SQLBits site (this is different from the username...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Sat, Dec 17 2011
  • Denali CTP3 - Semantic Search features

    Long time since I posted but the last post I did mentioned the Semantic Search feature potentially coming in SQL Server. Well its finally here and I finally got to test it out on the Denali CTP3 build. It is not feature complete and only allows Key terms to be analysed - the holy grail for text indexing...
    Posted to The SQLARTIST Blog (Weblog) by sqlartist on Tue, Oct 18 2011
  • SSAS Exposes a W2K3 bug

    This blog has been migrated to blog.calvett.co.uk . Please update your feeds. This post can be found at http://blog.calvett.co.uk/2011/04/06/ ssas-exposes-a-w2k3-bug/
    Posted to Andrew Calvett (Weblog) by ACALVETT on Wed, Apr 6 2011
  • SQL Windowing screencast session for Cuppa Corner - rolling totals, data cleansing

    In this 10 minute screencast I go through the basics of what I term windowing, which is basically the technique of filtering to a set of rows given a specific value, for instance a Sub-Query that aggregates or a join that returns more than just one row (for instance on a one to one relationship). http...
  • Code formatter for SSMS

    I was searching recently for a code formatter for T-Sql and I came accross this nice little utility that I wanted to share: http://www.wangz.net/cgi-bin/pp/gsqlparser/sqlpp/sqlformat.tpl I've been dealing with a lot of legacy code latley and there is nothing I find more infuriating than unformatted...
    Posted to The Tao Of Sql Server (Weblog) by blakmk on Fri, Apr 30 2010
  • Using PowerPivot to read my perfmon Data

    Last week I attended SQL Bits V and I can say it was a great experience it is definitely a must go event, if you missed it, keep you eyes open to SQL Bits VI. Anyway, on the Friday sessions we had Donald Farmer talking about PowerPivot for Excel/SharePoint 2010 and also the always energetic Brent Ozar...
    Posted to RebornDBA (Weblog) by david.castro on Thu, Nov 26 2009
  • Thinking outside the box - impressive

    I cant believe I have missed this blog for so long but I came across a site last night that is just plain exciting for people who love Transact-SQL. "Thinking outside the box" - http://weblogs.sqlteam.com/peterl/Default.aspx has some of the best and unique examples of working with sql I have...
    Posted to The SQLARTIST Blog (Weblog) by sqlartist on Sun, Jun 7 2009
  • SQL - Wrong results in Isoweek function

    See my previous post ( http://sqlblogcasts.com/blogs/repieter/archive/2009/02/24/sql2008-isoweek-in-datepart-function.aspx ) In our organisation we use the ISOweek function to determine weeknumbers for a given date. This function appears to be dependant of the language setting (@@DATEFIRST) on the SQL...
    Posted to SQL Blog - Pieter van Maasdam, Macaw (Weblog) by Repieter on Tue, Feb 24 2009
  • SQL_VARIANT datatype and behaviour changes

    When you use sql_variant datatype in sql server 2000 , and add data to a table using union all, it will work though datatype of data differs from each other declare @test table ( variant_column sql_variant ) insert into @test select 'test' union all select 345 union all select getdate () union...
    Posted to Madhivanan (Weblog) by Madhivanan on Fri, Feb 20 2009
  • SQLBits evening do

    We have finally got finalised that, at SQLBits, we will be having a drinks reception after the sessions finish. There will FREE beer (other drinks will be available) and pizza. We've also got some entertainment planned so it should be a good evening - var height=90;var width=720;
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Sep 2 2008
Page 1 of 5 (47 items) 1 2 3 4 5 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems