Common Language Runtime (CLR)
|
22 results found, displaying items 1 - 20
|
SQLCLR and Collations
In this PASS Summit Unite 2009 Speaker Tip, Adam Machanic discusses how to make a SQL CLR routine behave similarly to a T-SQL routine.
SQL Server Magazine
—
Adam Machanic
CLR Stored Procedure Finds Broken Objects
Stored procedures, user-defined functions, views, and triggers can fail to execute when the objects they reference have been changed. Here's a tool you can use to detect broken objects before they cause problems.
SQL Server Magazine
—
Jameel Ahmed
CLR UDT Caveats
CLR UDTs aren't intended to turn SQL Server into a full-blown object-oriented database. Learn about the proper place of CLR UDTs and methods for overcoming common objections to using them.
SQL Server Magazine
—
Tyler Chessman
Using Large CLR UDTs in SQL Server 2008
See how the VarBinaryComp UDT takes advantage of new support for large types to store,compress, and decompress up to 2GB of binary data.
SQL Server Magazine
—
Tyler Chessman
|
[June 6, 2007]
|
|
Leveraging Managed Functions in Computed Columns
Get an introduction to the concept of managed computed columns and see a simple example of one that implements CLR integration string-parsing functionality.
Windows IT Pro
—
Derek Comingore
Don't Be Afraid of BLOBs and CLOBs
With SQL Server 2005's three new LOB data types and CLR functionality, you can easily compress and decompress large amounts of data.
SQL Server Magazine
—
Yoel Martinez
SQL Server Magazine UPDATE, November 16, 2006--What's New for You in SP2?
Last week, Microsoft announced the SQL Server 2005 SP2 CTP. Check out the preview and learn about the new SQL Server enhancements coming your way. Plus, learn about Microsoft's other important product milestones, take the Reader Challenge, and more!
SQL Server Magazine
—
Various Authors
Can I Convert This String to an Integer?
Itzik shows you T-SQL and CLR methods for checking whether a given string can be converted to an integer--handy additions to T-SQL's data-manipulation capabilities.
SQL Server Magazine
—
Itzik Ben-Gan
SQL Server Magazine UPDATE, October 12, 2006--Application Server or Database Server?
When is a database not a database? And where does SQL Server the database start and SQL Server the application server end? Explore these questions, learn to handle interoperability with humor, read FAQs about SQL Server Everywhere, and more!
SQL Server Magazine
—
Various Authors
Application Server or Database Server?
When you’re trying to avoid mixing the database and application tiers, you might run into two provocative questions. First, when is a database not a database? And second, where does SQL Server the database start and SQL Server the application server end?
SQL Server Magazine
—
Brian Moran
SQL Server Express UPDATE--August 21, 2006:What's the CLR and Should I Care?
In this issue, you'll learn how the CLR works with SQL Server 2005 Express, how to back up your database to a default directory, and what you should know if you're running MSDE and you're planning to upgrade your OS to Vista.
SQL Server Magazine
—
Various Authors
What's the CLR and Should I Care?
Learn how the CLR works with SQL Server
2005 Express.
SQL Server Magazine
—
Michael Otey
Favorite SQL Server 2005 Features, Big and Small
It’s easy to focus on high-profile SQL Server 2005 features such as the SQLCLR and partitioning, but many people might have benefited more from a lot of small enhancements.
SQL Server Magazine
—
Brian Moran
Handy CLR Functions That You Can Call from T-SQL Code
Here are 17 string-manipulation functions written in Visual Basic, Visual C#, and Visual C++ that you can call from T-SQL code.
SQL Server Magazine
—
Readers
SQL Server Magazine UPDATE, March 30, 2006--Made In Express Competition
What will you do for your summer vacation? How about developing a solution for Microsoft's Made in Express competition? Read about Made in Express, SQL Server 2005 Report Packs, when to choose the CLR over T-SQL, and more!
SQL Server Magazine
—
Various Authors
CLR or Not CLR: Is That the Question?
Some DBAs and developers look at the SQLCLR as a dangerous weapon, but when it’s used wisely, the CLR can greatly improve performance. Here’s how to know when to use the CLR--and when T-SQL is still the best choice.
SQL Server Magazine
—
Itzik Ben-Gan
5 Steps for Developing and Deploying CLR Code in SQL Server
Follow these steps to build and deploy a CLR project for use with the author's provided code examples.
SQL Server Magazine
—
Itzik Ben-Gan
Get Out the Big Guns
Some SQL Server 2005 features could change the way you think about database systems, but these features might take some work. Take a look at some of the changes you’ll see when you use the SQLCLR and Service Broker.
SQL Server Magazine
—
Matt Nunn
Using the CLR with C# DLLs
Microsoft’s Patrick Conlan explains how C# DLLs will work with the CLR in SQL Server 2005.
SQL Server Magazine
—
Microsoft's SQL Server Development Team
Developers Win Big
Check out the best of what SQL Server 2005 has for developers.
SQL Server Magazine
—
Michael Otey
|
|
Register
