Have You Seen the Latest SQL Server Show? Check out SelectViews – it’s an online show about the database world, including tips, news happenings. [Watch the Show Here] Are You Working with New Database Platforms? There are so many different things happening with new database platforms. From cloud-based alternatives that look and feel like your existing servers to cloud-based systems […]
Other News
jQuery Data Linking in ASP.NET
(Hajan) We already know that Microsoft actively supports the jQuery project and is direct contributor to the three yet new but well-known plugins:
ColdFusion Custom Tags Cannot Act As ColdFusion Component Mixins
(Ben Nadel) The other night, I was laying in bed, thinking about ColdFusion code (as I often times find myself doing), and it suddenly occurred to me that I wasn’t sure of the expected behavior of ColdFusion custom tags that execute within a ColdFusion component context.
How to Bin Deploy SQL Compact Edition 4.0 and Razor web projects
(Anh) With the release of VS2010 SP1 Beta1, Web Matrix, and Razor QFE, we can build web projects containing SQL Compact Edition 4.0 sdf file and ASP.NET Web Pages with Razor syntax. However, this might be a problem when you are ready to deploy your project on a server that doesn’t have the assembli
inline SQL PL vs compiled SQL PL (Part 2)
(Serge Rielau) In the first post of this “mini-series” I introduced inline SQL PL and compiled SQL PL; when they were introduced along with a time line of added capabilities.
2010’s 10 Most Popular Replication Topics for DB2
(david t) These are the ten topics that I felt were the most popular with the sales teams and customers I worked with in 2010. As with last year’s list, this year’s based solely on my own experience. No way I’m going to try to reconcile my colleagues’ opinions and come up with a composite list 🙂 T
Querying XML Columns in SQL Server 2008
(Jeremy Wiebe) We make use of XML columns in a few places on our current project. XML columns are great for storing “blobs” of data when you want to be able to change the schema of the stored data without having to make database changes (it also provides flexibility in what you store in that column
XQuery for the Non-Expert – Binary Values
(Jason Strate) In the value() method post of my XQuery for the Non-Expert series I discussed how to take element and attributes and return them as column values. Those methods works all fine and dandy for most data but when it comes to binary data things get a little muddled.
Oracle lock types
(Gerald Venzl) Did you know that there are 202 different lock types in Oracle 11.2 but only 4 of them which are a direct result of a SQL statement?
Pulling data from a text file to query
(Karen Morton) I have the following query I’m running, please see below: