(Bill Graziano) Identity columns are commonly used as primary keys in database tables. These columns automatically assign a value for each new row inserted. But what if you want to insert your own value into the column? It’s actually very easy to do.
Other News
Is ‘YYYY-MM-DD’ always treated as year, month, date?
(Tibor Karaszi) Most of you already know the answer to this question: no.
How do I… Use PHP with PostgreSQL?
(Melonfire) It’s no secret that PHP and MySQL go well together. Both PHP and MySQL are open-source projects, are widely used in the developer community, and play well together because of PHP’s built-in MySQL support. While MySQL has been getting the lion’s share of attention, PostgreSQL also deserve
What’s new in SQL 2008 Part 1
(Don Schlichting) SQL Server 20008 will be released approximately February of 2008, along with a new version of Visual Studio and Windows. A CTP (Community Technology Preview) of SQL 2008 is currently available for download from the Microsoft URL http://www.microsoft.com/sql/prodinfo/futureversion/d
Using Scripting to Help Manage Your Databases
Featured Article(s) Using Scripting to Help Manage your Databases I was discussing my issue with this Windows Admin friend of mine, and he suggested that we use a script to get all the information that I needed. After speaking with him for only a few minutes, I was surprised at how much he claimed that he could do with a […]
IT Vision and the SQL Server DBA
Featured Article(s) Tips for using SQL Server 2005 Transactional Replication (Part 2) Here are some helpful tips to performance tune and optimize SQL Server 2005 Transactional Replication. Don’t Miss the Latest Weekly SQL Server Show Watch SelectViews Here – online and on your computer. Our weekly show goes into tips, tricks, things happening in the world of databases and more. […]
Oracle to charge for four 11g database add-ons
(China Martens) Oracle has issued details on pricing for its new 11g enterprise database, with the vendor making some of the most talked-about features available as extra-cost add-ons.
XMLIndex Part 2 – XMLIndex Path Subsetting
(Marco Gralike) As said in the former post, one of the disadvantages of creating a full blown XMLIndex, indexing on all possible values, is that the size of the XMLIndex is most of the time larger in size then the table itself.
Create Dynamic XAML Forms with the Presentation Model Pattern
(John Wheeler) This article presents an advanced technique that lets you bind multiple editable line items to a collection using Windows Presentation Foundation and the Presentation Model pattern. It assumes you are familiar with basic WPF data binding techniques as well as design patterns that obje
Oracle to DB2 Conversion Guide for Linux, UNIX, and Windows
(Whei-Jen Chen, An Na Choi, Marina Greenstein, Scott J Martin, Fraser McArthur, Carlos Eduardo Abramo Pinto, Arthur V Sammartino and Nora Sokolof) IBM DB2 has long been known for its technology leadership. This IBM Redbooks publication, intended for technical staff who are involved in an Oracle to D