Thursday, September 27, 2007

Screencast: SQL Server Analysis Services what's in it for me?

›
SQL Server Analysis Services is a very powerful tool, which was introduced with SQL Server 2000. In SQL Server 2005 it is far more powerful...
Friday, September 21, 2007

SQL Teaser PASS Special: Table Size

›
What will be the outcome of this script? First we create a table with a total of 6000 bytes Next we increase col2 from 1000 to 2000 bytes, t...
Wednesday, September 19, 2007

SQL Injection Cheat Sheet

›
What is SQL Injection? From wikipedia : SQL injection is a technique that exploits a security vulnerability occurring in the database layer...
Tuesday, September 11, 2007

Cumulative update package 3 for SQL Server 2005 Service Pack 2 is available

›
Cumulative update package 3 for SQL Server 2005 Service Pack 2 is available. How to obtain Cumulative Update 3 for SQL Server 2005 Service P...
Monday, September 10, 2007

SQL Gotcha: Do you know what data type is used when running ad-hoc queries?

›
This is for SQL Server 2000 only, SQL Server 2005 is a lot smarter which is another reason to upgrade. When running the following query you ...
Wednesday, September 05, 2007

Microsoft SQL Server 2008 CTP 4 Released

›
Microsoft SQL Server 2008 CTP 4 has been released 20070831 (yes that is ISO format) So I have been sleeping for the last couple of days and ...
1 comment:
Friday, August 31, 2007

Download LINQPad

›
Can't wait for C# 3.0 and LINQ? Well you don't have to! Dynamically query SQL databases today in LINQ: no more struggling with antiq...
Friday, August 24, 2007

Spam so bad it is funny

›
Hahaha, is this a babelfish translation? FROM: BILLY BANGURAABUJA,NIGERIA E-MAIL: billy_bangura2005@yahoo.co.uk DEAR ONE PERMIT ME TO INFOR...
Thursday, August 23, 2007

Summer SQL Teaser #13 Numeric

›
Hi and welcome to another fascinating SQL summer teaser. Summer it is except inPrinceton where it was 50 degrees this week. There was no tea...
3 comments:
Wednesday, August 22, 2007

geekSpeak recording - Real World SQL Server Integration Services with Matthew Roche

›
Channel 9 has posted a SQL Server 2005 Integration Services screen cast. From the site: This geekSpeak is all about SQL Server 2005 Integrat...
Tuesday, August 21, 2007

Late Summer Cleaning

›
I have too many CDs and decided to throw out some 'old' software. I either have newer versions or no need for it anymore.

Microsoft Gains Momentum in Business Intelligence Market as It Prepares to Launch Major BI Offerings

›
Microsoft Corp. today announced key milestones achieved within the business intelligence (BI) marketplace, including IDC’s recognizing Micro...

SQL Server 2008 Live Meeting Event on August 21st on DateTime function

›
Don't forget, today is the day of the SQL Server 2008 Live Meeting Event. Here is what I got in my inbox: We wanted to remind you that o...
Monday, August 20, 2007

Do you know how NULLIF and non-deterministic functions work?

›
Run this first CREATE TABLE #j (n varchar (15)) DECLARE @a int SET @a = 1 WHILE @a BEGIN INSERT #j SELECT NULLIF ( REPLICATE ( '1...

Article: LINQ to SQL (Part 6 - Retrieving Data Using Stored Procedures)

›
LINQ to SQL is a built-in O/RM (object relational mapper) that ships in the .NET Framework 3.5 release, and which enables you to model relat...
Monday, August 13, 2007

SQL Server 2008 Webchat and Live Meeting Series

›
SQL Server 2008 July CTP Web Chat July CTP Public Web Chat 08/13/07 Add to my Calendar SQL Server 2008 July CTP Live Meeting Schedule Enterp...
Friday, August 10, 2007

Summer SQL Teaser #12 Missing Dates

›
Stole this tease from my friend Mark . The teaser for this week is not really a teaser, this time you will have to write some code instead o...
1 comment:
Thursday, August 09, 2007

SQL Server Monitor Gadget for Windows Vista Sidebar

›
Conchango are making available version 1 of our SQL Server Monitor Gadget for Windows Vista Sidebar The gadget does exactly what it says on ...
Tuesday, August 07, 2007

Agile: Planning Poker and Scrum

›
Who said you can’t gamble at work and what is Scrum anyway? Scrum is an agile process for developing software. With Scrum, projects progress...

Showtime You Tricked Me, Shame On You

›
A couple of days ago I was flipping channels (like any man ought to do without interference from the wife/girlfriend). I noticed The Hills H...