|
SQL Server 2008 |
|
|
By greg on
4/23/2009 5:14 AM
|
|
|
|
Microsoft has now released SQL Server 2008 SP1. So if you are running SQL Server 2008 you should considering installing the latest service pack.
|
 |
|
|
More...
|
|
|
Free Training |
|
|
By greg on
7/9/2008 10:26 PM
|
|
|
|
Want some free SQL Server training? If so keep your eyes open for SQL Saturday events in your area. SQL Saturday is a mini-summit that uses the multiple presentation and track format. These sessions are presented by industry experts and peers that have a desire to sharing information related to SQL Server.
So far a number different SQL Saturday events have already been held, and more are being organized all the time. At the present time SQLSaturday event #5 and #6 are calling for speakers, and open for registration. Go to SQLSaturday.com to find out more about where these events are being held. If one is being held locally in your area and you have a passion for speaking consider submit a session abstract. If speaking isn’t your thing then at least register for the event to reserve your spot since seating at these events are limited.
|
|
|
|
|
More...
|
|
|
|
SQL Server Patch Management Methodology |
|
|
By greg on
4/24/2008 4:58 AM
|
|
|
As most of you probably already know Cummulative Update #7 for SQL Server 2005 was released on April 17th. (http://support.microsoft.com/kb/949095). Also Microsoft has now said they will be providing a Service Pack 3 sometime after SQL Server 2008 has been release to manafacture (http://blogs.technet.com/dataplatforminsider/archive/2008/04/15/sql-server-2005-sp3-coming-soon.aspx). So one way or another you should consider how you plan to patch your SQL Server 2005 machines.
As I see it there are three different patch management strategies you can take. The first option is every 8 weeks when a ...
|
|
|
|
|
More...
|
|
|
SQL Server Networking |
|
|
By greg on
4/12/2008 11:34 AM
|
|
|
Did you think this post had something to do with the routers, switches and wires connecting SQL Server machines to the World Wide Web? If so you are wrong. This post has to do with my experience working one of the vendor booths at the “Heroes Happen Here” launch last week. For those of you that don’t know what the “Heroes Happen Here” launch is all about let me give you the scoop. These are events held all over the world , and this is where Microsoft is communicating to the IT community all the great things that about the new Visual Studio, Window Server and SQL Server 2008 versions have to offer. If you need more information about these events and want to find a launch near you check out this website: http://www.microsoft.com/heroeshappenhere/regi ...
|
|
|
|
|
More...
|
|
|
SQL Server 2008 Certification |
|
|
By greg on
4/7/2008 8:46 PM
|
|
|
|
Last week there was a forum post about getting certified for SQL Server. The poster was asking about resources and how one should prepare for the MCDBA certification. The MCDBA certification is a SQL Server 2000 certification. At one point a number of years back it was the certification to have if you where a DBA, but now with SQL Server 2000 soon to be two versions back you probably should focus on one of SQL Server 2005 certifications, or wait for SQL Server 2008 certification to come out.
Certifications are a great way to get your foot in the door and show potential employers that you know something about the technology for whatever job you might be applying for. Even having an old certification is better than having no certification at all. So what should one do now if they want to get certified in SQL Server?
|
|
|
|
|
More...
|
|
|
Is T-SQL dead? |
|
|
By greg on
4/3/2008 9:23 PM
|
|
|
|
On Tuesday I went to the SQL Server 2008 launch in Seattle. Of course the launch was more than just SQL Server 2008, it also included Windows Server 2008 and Visual Studio 2008. So there was a lot of BUZZ about 2008 stuff going on.
I attended one of the presentations on Visual Studio 2008 that was talking about LINQ. LINQ stands for Language Integrated Query. In this presentation they talked about how programmers can now get SQL Data into a object model using something called “LINQ to SQL”. So I browsed the web for LINQ to SQL document and here is a blurb from a Microsoft document :
“In LINQ to SQL, the data model of a relational database is mapped to an object model expressed in the programming language of the developer.”
Now by looking at this statement I get the impression that Microsoft thinks developers don’t use T-SQL as a programming language. So I wonder if LINQ w ...
|
|
|
|
|
More...
|
|
|
SQL Server 2008 DATATIME2 data type |
|
|
By greg on
3/19/2008 10:01 PM
|
|
|
I was spending some time over the last few weeks researching new features in SQL Server 2008 for a presentation I gave today at the Olympia Area SQL Server User Group in Tumwater, Washington, USA. So of course I had to take a closer look at the new date/time data types as part of this review.
Most everyone knows that there are a number of different date/time related data types coming out with SQL Server 2008. But for this BLOG post I want to focus in on just one new data type, DATETIME2. The new DATETIME2 data type is much like the existing DATETIME data type, except that it allows more percision for the time portion of the date/time. This new data type can now support time values that are accurate to 100 nanoseconds.
This new DATETIME2 data type allows you to specify how much percision you want to store in the time portion. The more percision you want the more disk space it take. A DATETIME2 data type takes from 6 to 8 bytes depending on the percision.
|
|
|
|
|
More...
|
|
|
Think Green |
|
|
By greg on
3/16/2008 8:03 AM
|
|
|
|
As Saint Patrick’s Day approaches I’m sure a number of you will be thinking about lifting a few green beers at your local watering hole. Why you are thinking about all the green items that come along with Saint Patty’s day, how about thinking green for your SQL Server environment.
So about now you are probably wondering what the heck I am talking about. Well I’m talking about how you might reduce that carbon foot print for your SQL Server installations. How are you planning on reducing your consumption of rack/floor space, power, and cooling expenses?
My green effort is to consider consolidation as our organization starts contemplating moving toward SQL Server 2008.
I am researching how I can leverage virtualization along with consolidation to reduce the total cost of ownership for SQL Server 2008. I’m researching Microsoft Virtual Server (
|
|
|
More...
|
|
|
SQL Server 2008 Test Databases |
|
|
By greg on
3/13/2008 8:01 AM
|
|
|
|
I suppose by now all of you know about the lastest SQL Server 2005 beta (CTP6), which was released in February. If you have downloaded and installed this beta or any one of the prior CTP’s you will noticed there are no sample databases installed, which of course is normal.
If you are going to play with SQL Server 2008 you can create your own database. Then use those databases to experiment and play around with the new features of SQL Server 2008. But I personally like to use the sample databases provided from Microsoft.
The advantages of using sample databases is they are already populated and normally have lots of objects and code that take use the new features of SQL Server. Using these sample DBs allow you to explore the new features of SQL Server without building your own DB. Also when you are building examples to share like I do on my site (http://sqlserverexamples.com ...
|
|
|
|
|
More...
|
|