(Murali Krisnan) One of my client’s requirements is to migrate and consolidate his company departments’ databases to SQL Server 2008. As I know the environment, they are using MySQL , MS-Access and SQL Server with different applications.
Other News
Does Your SQL Server Service Have Too many Permissions?
SelecTViews Shows to Watch: SelecTViews – Open source projects and SQL Server, FrontPage Lives?!, Business Intelligence is profiling…. or is it? SQL Server tools and the cloud, featured blog, Chris Shaw on the show and MUCH more. [Watch the Show] Previously… Database applications and tablet devices, toasters (er, appliances), and the SQL Server Tip of the Day. Also, Wendy Pastrick, […]
Using Charts to Effectively Communicate Data
(DaveMcG) Altova first added support for charts and reporting the Altova MissionKit with the launch of Version 2011 last September.
Get Selected Row from ASP.NET MVC 3 WebGrid
(Malcolm Sheridan) Every website has to display data and every website has a Grid control. In ASP.NET MVC 3 there’s the WebGrid, which is part of the Microsoft Web Helpers library. This can be downloaded through NuGet (formerly NuPack). NuGet is a free open source package manager that makes it easy
Optimizer Stats: Treat some tables different than AutoTask does
(Uwe Hesse) This posting was inspired by an OTN thread. Since 10g, we have an Automatic Maintenance Task (AutoTask) that gathers Optimizer Statistics during the night. This task uses DBMS_STATS.GATHER_DATABASE_STATS with default values. For whatever reason, we may consider these defaults not appropr
An Open-Source DB2 SQL Graphical Tool That You Can Use for All Your Databases
(Thomas Snyder) As you start using embedded SQL more frequently within your RPG code, you’ll soon find that your SQL statements are becoming larger and larger and the interactive SQL tool on the green-screen starts becoming quite cumbersome. In this article, I will introduce Squirrel SQL, which is a
How to detect if a MySQL server is an active replication slave
(Giuseppe Maxia) Sometimes you know for sure. And sometimes you wonder: Is this server part of a replication system? And, most specifically, is it an active slave?
SQL SERVER – CXPACKET – Parallelism – Advanced Solution – Wait Type – Day 7 of 28
(Pinal Dave) Earlier we discussed about the what is the common solution to solve the issue with CXPACKET wait time. Today I am going to talk about few of the other suggestions which can help to reduce the CXPACKET wait.
A Look at Electronic Publication (EPUB)
(Darla Ferrara) The introduction of Amazon Kindle has brought about a technological revolution in the world of publishing.
Heading to SHARE
(Troy Coleman) I’ll be on hand for the SHARE conference in Anaheim, Calif., from Feb. 27 to March 4.