|
|
SQL Server Dashboard |
|
Greg
|
By greg on
1/18/2010 8:00 AM
|
|
|
|
Another version of the SQL Server Dashboard is being put together that works via SQL Server Reporting Services stay tuned.
|
 |
|
|
More...
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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 ...
|
|
|
|
|
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 ...
|
|
|
|
|
More...
|
|
|
SQL Server 2008 Certification |
|
Greg
|
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? |
|
Greg
|
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...
|
|