(Dorababu M) I have seen many articles on the GridView control with scrolling headers. I tried several forums and websites, but didn’t come up with a good solution that work well enough. Some work with the browser compatibility and some others don’t work.
Other News
Dynamic row format for MEMORY tables
(Laurynas Biveinis) The latest Percona Server release has one new feature: now MEMORY tables can have BLOB and TEXT columns, and VARCHAR columns will not waste space due to implicit extension to CHAR.
SQL Server Multi Server Administration
(Bradley Upton) I have multiple SQL Servers that need the exact same SQL Server Agent Job created. I know I can script a SQL Server Agent Job out and run the T-SQL script on multiple servers or bounce from server to server creating the SQL Server Agent Jobs, but isn’t there an easier way?
Auto-Pilot and Your Systems – Trust but Verify
Check out the latest free show: SSWUG TV – We’ve unveiled a new name for our video-based content, which will be one of many upcoming site revitalization efforts. In this episode, we have a two-part interview with SQL Azure MVP Ike Ellis and updates coming from the Microsoft Build conference. [Watch the Show] Featured Article(s) The State of Database Administration […]
Microsoft SQL Server, PDW reach out to Hadoop for big data processing
(Jason Sparapani) “Big data” is weighing on a lot of minds lately, including those at Microsoft. Last month, the company released a community technology preview for two connectors to the open source distributed computing framework Hadoop for big data processing, one for SQL Server and one for SQL Se
Effective Xml Part 1: Choose the right API
(Pawel Kadluczka) This is the first part of a mini-series of blog posts about using Xml on .NET Framework platform in an effective way. Although I will be focusing on .NET Framework platform I hope that at least some of the information will be general enough to apply to working with Xml on any platf
Quick SQL Tips – Indexed Views
(Susan Ibach) Although not a new feature, Indexed views can still be a useful tool for increasing query performance. Of course you have to be careful of the trade-offs. Just like indexing a table, indexing a view may speed up a query, but will increase your storage requirements and slow down insert
Oracle 11g XE Installer
(Michael McLaughlin) Finally, I got to install Oracle Database 11g Express Edition (XE) tonight. Unfortunately, I ran into an error during the installation. A quick Google search landed me in the forum, where it gave me the impression it wouldn’t work on Windows 7, 64-bit. However, I’m tenacious wit
Representational State Transfer: A Short Walkthrough
(Diptee Warudkar Dalal) As the internet has evolved over the last decade, the infrastructure required to host its services and the development paradigms to support such scale have also undergone a significant change.
Generating Default Values for Nulls with Coalescing Operator
(Peter Vogel) Generally speaking, developers hate nulls. While an integral part of relational database theory (where they represent an unknown value), eventually nulls get passed to some variable that won’t accept them and your code blows up.