Browse by Tags

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 11-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 06-07-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 02-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 02-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 Simon Sabin UK SQL Consultant's Blog (Weblog) by simonsabin on 09-02-2008
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

Posted to SQLBits (Weblog) by simonsabin on 09-02-2008
New MSDN SQL Server Wiki

The Volunteer Moderators and Answerers who support the Microsoft MSDN SQL Server Forums have created a new wiki to present Solutions to Common T-SQL Problems at http://code.msdn.microsoft.com/SQLExamples . At the moment mere mortals can't update the solutions but you can leave comments.

Posted to Jon Sayce (Weblog) by jonsayce on 04-17-2008
SqlClrProject version 2.6 Released

I have just released a new version - 2.6 - of the deployment tool for SQLCLR assemblies. It is a minor release, but it implements some changes that are fundamental for coming versions and also fixes a couple of minor bugs. The download page for it is here , and if you want general information about what...

Posted to Niels SQL Server Blog (Weblog) by nielsb on 02-27-2008
Certification path for SQL Server 2008, whats your choice?

Are you ready for your SQL Server 2008 Certification? As SQL Server 2008 is still in CTP process Microsoft learning has already announced the process in getting certification in this new version. Not only with Learning opportunities Microsoft Press also offering freebies by the way of ebooks and press...

Posted to SQL Server Knowledge Sharing Network (SqlServer-qa.net) (Weblog) by ssqa.net on 02-12-2008
Using ...WHERE NOT IN (SELECT... with NULLs

I was asked to look at a query today and explain why using a NOT IN clause wasn't returning any rows. Switching the NOT IN to an IN resulted in 38 rows, and removing the clause completely returned 431 rows. So what was happening to the other 393? Surely if a row is not in IN, then it should be in NOT...

Posted to Jon Sayce (Weblog) by jonsayce on 12-03-2007

Page 1 of 5 (42 items) 1 2 3 4 5 Next >