Thursday, June 28, 2007

Guess What I Will Be Doing Tomorrow (June 29th 2007) At 6PM

›
Did you think I would be waiting in line like a dummy to purchase the iPhone? Wrong my friend, I will pick up a birthday cake for my wife. A...
2 comments:
Friday, June 22, 2007

Summer SQL Teaser #4 Nulls and Counts

›
First create this table CREATE TABLE Teaser (ID int) INSERT Teaser VALUES (1) INSERT Teaser VALUES (2) INSERT Teaser VALUES (1) INSERT ...
Thursday, June 21, 2007

Good Distributed Partitioned Views / Federated Databases Article

›
The Microsoft SQL Server Development Customer Advisory Team has a nice blog post about Distributed Partitioned Views / Federated Databases ...
Monday, June 18, 2007

Which SQL Server 2005 Analysis Services Book Should I Get?

›
Who can recommend a good SQL Server 2005 Analysis Services book? I know SQL Server 2000 Analysis Services but did not work with SQL Server 2...
3 comments:
Thursday, June 14, 2007

Book Review: Expert SQL Server 2005 Development By Adam Machanic

›
If you are an advanced or intermediate SQL Server developer then this is the book for you. Adam understands real world scenarios and underst...

C# IsNullOrEmpty Function In SQL Server

›
Mladen Prajdic has created a SQL equivalent of the C# IsNotNullOrEmpty I looked at it and thought that there was way too much code Here is ...
3 comments:
Wednesday, June 13, 2007

SQL Myth: Truncate Cannot Be Rolled Back Because It Is Not Logged

›
I am still amazed at how many people still think that TRUNCATE TABLE is not logged. There is some logging going on but it is minimal, here i...
6 comments:
Friday, June 08, 2007

Three New SQL Server Best Practices Articles On TechNet

›
Predeployment I/O Best Practices The I/O system is important to the performance of SQL Server. When configuring a new server for SQL Server ...

SQL Teaser NULL vs COALESCE

›
Without running the code, try to guess the output DECLARE @v1 VARCHAR (3) DECLARE @i1 INT SELECT ISNULL (@i1, 15.00) /2, COALESCE ...
1 comment:
Wednesday, June 06, 2007

How To Protect Yourself From Fat-Finger Sally, Crazy Bosses and Other SQL Villains

›
You all have been through this at least once in your life. In your shop there is this one person who likes to use Enterprise Manager as thei...
Monday, June 04, 2007

SQL Server 2008 Is RTM (According to SERVERPROPERTY('productlevel'))

›
SELECT @@VERSION , SERVERPROPERTY ( 'productversion' ), SERVERPROPERTY ( 'productlevel' ) Microsoft SQL Server code name &q...

SQL Server 2008 (Katmai) Cannot Be Installed On A PC With SQL Server 2000 On It

›
I tried installing the SQL Server 2008 – June CTP on one of my machines which had SQL Server 2000 installed; it does not let you do that. I ...

SQL Server 2008 June CTP now available!

›
From the connect site Preview upcoming Releases: SQL Server 2008 June CTP now available ! We are always working on something new to make SQ...
2 comments:

SQL Server 2008/Katmai Webcast

›
TechNet Webcast: The Next Release of Microsoft SQL Server: Overview (Level 200) Simulcast from Microsoft Tech·Ed 2007 in Orlando, FL. This s...
Sunday, June 03, 2007

Did You Know SQL Server Has A Black Box Like An Airplane?

›
Paul Randal writes: "Kimberly mentioned that SQL Server has a 'black-box' trace, similar to an aircraft flight-recorder, which ...

Excel 2007 Files Are WinZip/WinRAR Files In Disguise

›
I am not going to say anything about the ribbon or the diamond, this not a post about that. Create a new file in Excel 2007 with 250000 (tha...
Thursday, May 31, 2007

Sam Gentile Reviews RubyMicrosoft Essay By Martin Fowler

›
Martin Fowler asked Sam Gentile to review and contribute thoughts to his very important new essay RubyMicrosoft . This piece presents the vi...
Wednesday, May 30, 2007

Speed Up Performance And Slash Your Table Size By 90% By Using Bitwise Logic

›
You have all seen websites where you can pick a bunch of categories by selection a bunch of check boxes. usually what you do is store those ...
1 comment: