(graz) As SQL Server 2005 rolls out DBA’s are going to be forced to learn either C# or Visual Basic or both. Until now these were client side languages and not knowing them had little impact on your job. And if you write code in these languages your going to have to learn to use Visual Studio. This

(Kevin Kline) I’ve worked with a lot of database platforms over the years — everything from Oracle to DB2 UDB, MySQL to PostgreSQL, Sybase to SQL Server. One of the things I’ve always enjoyed about SQL Server is the genuine ease of administration that Microsoft has built into its native toolkit.

(Arthur Fuller) Depending on your job specs, you may work solely with SQL Server, or you may use SQL along with various front-end applications, written in .NET, Java, or Delphi. In such languages, you are accustomed to the concept of reusability. However, SQL developers rarely (if ever) think of

(Adam Machanic) In reference to your article, Say goodbye to system tables in SQL Server 2005, do you mean system tables are really gone or no longer actively supported? If it is really gone then I have more up front work to do. If it is no longer actively supported I might have more time for ch

(Sérgio Fontes) Structured Query Language (SQL) is the most widely used commercial relational database language. It was developed by IBM and the current ANSI/ISO standard is called SQL: 1999.

(William Pearson) In this article, we will continue the examination of the TopCount() function that we began in the previous article of the MDX Essentials series, Basic Set Functions: The TopCount() Function, Part I. Before getting “hands-on” with TopCount() in our last session, we introduced the fu

(Allan Mitchell) This article is as a result of a requirement from the Beta Newsgroups. Jamie Thomson from Conchango wanted a destination adapter that did nothing but consume rows with no setup requirement from himself. He uses this type of component when he’s debugging amongst other things. There a

(Brian Moran) Extreme performance is a term that a colleague and I coined 5 years ago to define the SQL Server performance-tuning approach that we recommended to our consulting customers. Understanding and implementing the extreme-performance philosophy might help you avoid performance-tuning mistak

(poodull76) The article explains how to prepare a table as XML using its DataSet’s schema, then sending it to a stored procedure to execute an Update and Insert. The problem I saw for my needs was that the MSDN solution requires a function and a stored procedure for each table.

(Stephen Swoyer) Time after time, in market after market, Microsoft has used a similar recipe for success: Make it easy to use, abstract the underlying complexity of what’s involved, and customers will come—in truckloads most of the time.