|
|
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 (11)
|
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...
|
|