|
T-SQL Best Practices |
|
Greg
|
By greg on
6/19/2009 6:54 AM
|
|
|
|
Over the last month or so I've been busy preparing some T-SQL Best Practices. Read this blog to find out more information and download my presentation on T-SQL Best Practices
|
 |
|
Comments (4)
|
More...
|
|
|
SQL Server 2008 |
|
Greg
|
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.
|
|
|
|
Comments (0)
|
More...
|
|
|
You may be a tech wiz...but are you certifiable? |
|
Greg
|
By greg on
3/9/2009 12:24 PM
|
|
|
|
Consider yourself a tech prodigy? Here is your chance to prove yourself in the ultimate knowledge game. Choose an avatar, select your expertise, and pit yourself against a worldwide community in a quest for Tech IQ supremacy, a top spot on the leader board, and ultimate bragging rights!
|
|
|
|
Comments (0)
|
More...
|
|
|
|
Free Training |
|
Greg
|
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.
|
|
|
|
Comments (1)
|
More...
|
|
|
|
SQL Server 2008 Features by Edition |
|
Greg
|
By greg on
5/9/2008 7:12 AM
|
|
|
|
Over the last few months Microsoft has been having many different launch events worldwide for their 2008 products: Visual Studio 2008, Windows 2008, and SQL Server 2008. I had the opportunity to attend one of these launch events Being a SQL Server DBA I attended the Data track of their rollout. In this track they discuss all the new features that are being incorporated into SQL Server 2008. What this presentation missed was discussion related to the different editions available with SQL Server 2008, and which features where available by edition To me it seems like a lot of the cool new features all seem to be implemented in the Enterprise edition. But there are still a number of exciting new features in the other editions as well. Here are some links you can use to compare the features by edition.
Compare the Enterprise and Standard Edition:
|
|
|
|
Comments (0)
|
More...
|
|
|
SQL Server Patch Management Methodology |
|
Greg
|
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 ...
|
|
|
|
Comments (13)
|
More...
|
|
|
GIS Data Types in SQL Server 2008 |
|
Greg
|
By greg on
4/15/2008 6:17 PM
|
|
|
|
SQL Server 2005 has some new GIS data types. How many of you are GIS savvy? Well I’ll by the first one to admit that I don’t work with GIS data. But I am starting to look at SQL Server 2008 and trying to encourage our GIS guy to look at the new GIS data types within SQL Server.
Today the Redmond Magazine has an article where John Baleja, senior product manager at mapping software provider ESRI says “…will be easier integration with other applications, more security and possibly better performance.&rdquo ...
|
|
|
|
Comments (0)
|
More...
|
|
|
SQL Server Networking |
|
Greg
|
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 ...
|
|
|
|
Comments (0)
|
More...
|
|