Accidental DBA Workshop Today
Now is the time to get registered and get to the workshop. Go Register now! It starts at 11:00 Central Time so you have time to get there. If you’re not sure if this is the best use of your time, click on Register and view the contents for each of the sessions. Steve also has a quick video with an overview of the Workshop. Steve has a very effective way of communicating the things you need to know in order to be effective.
[More Information Here]
Webcast Coming Tomorrow: SQL Server and SharePoint Data Integration
SharePoint’s Data View web part can do much more than just view data. It can serve as a complete front-end to your SQL Server (and other data store) information allowing you to create robust applications without writing code. In this session, you will see just how to create such an application including conditional graphics. You’ll even learn how to pass data from SQL Server into a SharePoint Designer workflow for business process automation.
Presented by: Ricky Spears
> Register Now
> Live date: 10/6/2010 at 12:00 Pacific
Featured Article(s)
Tips for using SQL Server 2008 constraints
In this article, you can find some tips to performance tune and optimize SQL Server 2008 constraints.
Featured White Paper(s)
Developing Something for Nothing with SQL Server: A Closer Look at SQL Server Express and How it Can Work for You
In this new Quest Software technical brief, learn about SQL Server Express – Microsoft’s free version of SQL Server – and how… (read more)
All Things SQL Server are Not Alike
We are all aware that Microsoft has many versions of SQL Server, each with different capabilities, designed to meet the needs of various applications, One of the things that is of interest to me, and I always seem to miss in the side by side comparisons of the different products, is that the 64 bit versions do not always have the same capabilities as the 32 bit counterparts.
For example, in SQL Server 2008 R2 – SSIS all data sources are not available. Surprisingly, one of the data sources for which there is no 64 bit driver is Jet which supports MS Access and Excel file sources.
Not only do the 64 bit versions have different capabilities in the released products, they behave differently as well. Often this is due to the difference in the base operating system (Windows 32 vs Window 64).
There are difference in how SQL Server interacts with the Operating System that occurring in 64 bit versions that do not occur in 32 bit versions. One example is the paging of buffer pool memory as defined by this Microsoft Support Article.
So, don’t just plug and play. Take time to be aware of the versions you are supporting. Not just the release version, but the differences for 32 bit, 64 bit and Itanium based systems.
Feel free to drop me a note with your experience that highlights versions of SQL Server for which our readers need to be aware. Send your comments to btaylor@sswug.org.
Cheers,
Ben