Articles on Sql Server

SQLPass 2008: Thursday Keynote

(SQLblog.com - The SQL Server blog spot on the web)

Introduction
So, it's a few minutes before the PASS Summit 2008 Thursday keynote, and I'm settled into the Press Table behind the sound board. Tony Davis is here. Steve Jones is here. And I'm seated beside Brent Ozar.
Rushabh Mehta
To complement Wayne Snyder's entrance on a bike yesterday, Rushabh Mehta showed up this morning on a cool-looking scooter - a scooter that...
More from SQLPass 2008: Thursday Keynote
Original

Here's we go again - PASS Keynote Day 2

(The SQLTeam.com Weblogs)

As I type this, I've just sat down at the Press/Bloggers table in the General Session are waiting for the keynote address. The lights have dimmed and the smoke machine has begun pumping fog onto the stage. Once again, "Born to be Wild" is blaring on the PA System. The curtain drops and Rushabh Mehta, PASS' current Executive Vice President of Finance and Technology is on a Vespa motor scooter!...
More from Here's we go again - PASS Keynote Day 2
Original

PASS 2008: D-Day (a.k.a. Main Conference Day 1)

(The SQLTeam.com Weblogs)

Things got off to a great start with PASS President Wayne Snyder coming on stage to the tune Born to Be Wild with appropriate video clip and real motorcycle (and don't forget the shades!).� Lots of awesome things coming soon to a database server near you.� Joe Webb has a great summary of this morning's Keynote.
Given my current work situation, I play a lot of different roles, so I fully...
More from PASS 2008: D-Day (a.k.a. Main Conference Day 1)
Original

Storing files to database and downloading it using ASP.NET

(The SQLTeam.com Weblogs)

1) First create a new column and set it as varbinary(MAX) for the datatype.
2) Use this code to store the file to database:
��//Read File to Bytes �� FileStream st = new FileStream(<Location of the file>, FileMode.Open); �� byte[] fileData= new byte[st.Length]; �� st.Read(fileData, 0,...
More from Storing files to database and downloading it using ASP.NET
Original

Early TPC-C and H reports for Shanghai relative to Barcelona and Dunnington

(SQLblog.com - The SQL Server blog spot on the web)

Below are the first performance numbers for the new AMD 45nm Opteron (Shanghai) relative to other recent AMD and Intel Xeon results.
4-way TPC-C
Opteron 8360 Quad-core 2.5GHz (Barcelona) 2M L2, 471,883 (DL585G2)
Opteron 8384 Quad-core 2.7GHz (Shanghai) 6M L2, 579,814 (DL585G2)
Xeon 7350 Quad-core 2.93GHz (Tigerton) 2x4M L2, 407,079 (DL580G5)
Xeon 7460...
More from Early TPC-C and H reports for Shanghai relative to Barcelona and Dunnington
Original

Defensive database programming: fun with changing column widths.

(SQLblog.com - The SQL Server blog spot on the web)

In Transact SQL you can assign a 10-character value to a VARCHAR(5) variable, as follows: DECLARE @c VARCHAR ( 5 ); SET @c = '1234567890' ; PRINT @c 12345 The value will be silently truncated without raising an error. Because of this behavior it may be very easy to make mistakes. For example, consider the following table and stored procedure: CREATE TABLE Data . Codes ( Code VARCHAR ( 5 ),...
More from Defensive database programming: fun with changing column widths.
Original

PASS Keynote, Wednesday: "Delivering on Our Data Platform Vision"

(SQLblog.com - The SQL Server blog spot on the web)

The keynote today was delivered by Ted Kummert, Corporate VP, Data and Storage Platform Division at Microsoft. Before Ted started, Wayne Snyder showed up on stage, sitting on a hog and surrounded by smoke or dry ice or something. He talked about how PASS has grown over the past year in several areas:
chapters (136)membership (32,000+)summit + pre-con registrations (60% over last year)He...
More from PASS Keynote, Wednesday: "Delivering on Our Data Platform Vision"
Original

Some of my reasons for upgrading to SQL Server 2008

(SQLblog.com - The SQL Server blog spot on the web)

So Aaron posted My reasons for upgrading to SQL Server 2008

I thought it was an interesting list, not as interesting as the one by Jason Massie (10 Reasons to Upgrade to SQL Server 2008) but still interesting :-) I would like to give you my list.

Date data type
We have data that goes back to 1896 so we cannot use smalldatetime instead of datetime....
More from Some of my reasons for upgrading to SQL Server 2008
Original

Cumulative update package 2 for SQL Server 2008 has been released

(SQLblog.com - The SQL Server blog spot on the web)

Cumulative update package 2 for SQL Server 2008 has been released, this build of the cumulative update package is also known as build 10.00.1779.00
To see all the fixes and how to obtain Cumulative update package 2 for SQL Server 2008 go here: http://support.microsoft.com/default.aspx/kb/958186/en-us
Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | ...
More from Cumulative update package 2 for SQL Server 2008 has been released
Original