(Mark J. Miller) This is the first in what I plan to be a series of articles examining the Common Language Runtime (CLR) hosted by SQL Server 2005. This installment looks at the security model of the CLR. Following articles will address performance and stability of the CLR as a whole, performance of
Other News
Oracle/PLSQL: Grant/Revoke Privileges
You can grant users various privileges to tables. These privileges can be any combination of select, insert, update, delete, references, alter, and index. Below is an explanation of what each privilege means.
Say hello to XPath 2.0
(Ed Tittel) Amidst the many new recommendations approved by the W3C on January 23, 2007, you’ll find a brand spanking new version of XPath—namely, 2.0—to ponder. Formally entitled TR/xpath20/XML Path Language (XPath) 2.0, this document caps off what some might call the “Holy Trinity” of XML, all of
MERGE and TRUNCATE [DB2 9 for z/OS]
(Craig Mullins) Two additional new SQL statements available in DB2 Version 9 are the MERGE and TRUNCATE statements.
Returning a Random set of Records
(Parthasarathy Mandayam) The NEWID() function returns a uniqueidentifier for each row of data that is returned.
MySQL: ibdata files do not shrink on database deletion [innodb]
(CrazyToon) One very interesting thing I noticed with MySQL was that if you delete a database, ibdata file doesn’t shrink by that much space to minimize disk usage. I deleted the database and checked usage of /usr/local/mysql/var folder and noticed that ibdata file is still the same size. So the pro
Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables
Microsoft Office Excel 2007 takes advantage of most of the features in Microsoft SQL Server 2005 Analysis Services. To take full advantage of these features, it is important to keep in mind the end-user experience in Office Excel 2007 when you are designing cubes. (doc)
IBM Upgrades High-End System i5 Servers
(Timothy Prickett Morgan) The rumor mill panned out on this one. Two months ago, I told you that I was hearing that IBM was considering upgrading its high-end System i5 595 server with its fastest Power5+ processors, and that has indeed come to pass. In addition to upgrading the i5 595 processors, t
The Read Consistency Trap in Sql Tracing
(yas) There are some important things to consider when interpreting sql trace files. One of the most important ones is the read consistency trap as it is called in the documentation.
Creating a Data-Bound Grid in C# with ADO.NET
(Irina Medvinskaya) Data access is a core of most applications and an ability to efficiently access and modify a database is required for developers on a regular basis. In this article, you will look at accessing SQL-based data utilizing C# and ADO.NET and displaying the data in a data-bound grid co