SQL SERVER – Differences in Vulnerability between Oracle and SQL Server

In the IT world, but not among experienced DBAs, there has been a long-standing myth that the Oracle database platform is more stable and more secure than SQL Server from Microsoft. This is due to a variety of reasons; but in my opinion, the main ones are listed below: A.…
Read More

SQLAuthority News – Hub-And-Spoke: Building an EDW with SQL Server and Strategies of Implementation

Hub-And-Spoke: Building an EDW with SQL Server and Strategies of Implementation logo-sql08.gif SQL Server Technical Article Writers: Mark Theissen, Eric Kraemer Published: February 2009 To date, the implementation of a true hub-and-spoke architecture for a data warehouse environment has been an idealized and elusive goal. Although building a centralized “hub,”…
Read More

SQL SERVER – White Paper – Partitioned Table and Index Strategies Using SQL Server 2008

Partitioned Table and Index Strategies Using SQL Server 2008 Writer: Ron Talmage, Solid Quality Mentors Technical Reviewer: Denny Lee, Wey Guy, Kevin Cox, Lubor Kollar, Susan Price – Microsoft Greg Low, Herbert Albert – Solid Quality Mentors When a database table grows in size to the hundreds of gigabytes or…
Read More

SQL SERVER – ERROR: FIX: Cannot drop server because it is used as a Distributor in replication

Replication has been my favorite subject when it comes to resolving errors. I have found that many DBAs are stuck with the solving of the problem of replication for hours; however, the solution is very easy. One of the very common errors in replication occurs when replication is removed from…
Read More

SQL SERVER – Business Intelligence – Aligning Business Metrics

Today, executive management and managers need the latest information to drive intelligent decisions for business success. More informed decisions mean more revenue, less risk, decreased cost, and improved operational control for business agility and competitiveness. Besides, in today’s fast paced, technology-driven business world, organizations are continually struggling to deal with…
Read More