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

I recently came across a bug in Windows 2003 SP2 which causes a blue screen of death and SSAS was exposing the bug. In my scenario SSAS was the match, a file system cache function was the fuse and a BSOD the payload….. If your an all Windows 2008 shop then there is no need to read on and i am envious...

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...

Posted to Tony Rogerson's ramblings on SQL Server (Weblog) by tonyrogerson on Fri, May 21 2010
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 >