There are so many new features in SQL Server 2005 that there's one that can make a significant impact in solving many different types of problems. Andy Warren takes a look at one of the features that has been enhanced and is extremely useful, albeit quirky: TOP.
Is your company trying to accelerate cycle times, lower costs, improve responsiveness, ensure compliance with policies and best practices, and increase customer satisfaction? Well, of course! That's why you need a comprehensive approach to managing your organization's business rules
Dealing with text, image, and other large object data types can be confusing for many people, in all aspects of working with them. However one place that is important is performance. SQL Server MVP Simon Sabin brings us a few thoughts on improving performance with these columns and the Text in Row setting.
Tim Chapman discusses using table valued functions with the APPLY function.
In this video, you'll learn how to write basic select statements. This beginner video takes you from the ground up writing T-SQL.
Security in SQL Server is not too complex, following a fairly simple framework for allowing and preventing access to data. However there are a few places where it can get tricky and some concepts that many people do not understand. Rob Farley brings us an explanation of one of those areas: ownership chaining. Read about how ownership chaining can be useful and also how it may open security holes in your environment.
Mairead introduces you to how to create your database project using the latest edition of Visual Studio Team System - Team Edition for Database Professionals. Check out this quick 10 minute demo to get a whirlwind tour of project creation within VSTE for DB Pro.
This article explains how desktop applications can use SQL Server 2005 Data Mining to analyze in-memory data.
We're blowing out inventory again to make room for new books. Stock up your SQL Server library with a few of our titles.
SQL Server 2005 has made it much easier to work with XML data in your database applications than ever before. In this article, new author Jack Hummer examines how you can use XML to move data through stored procedures.
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
By Steve Jones
“You don’t need more time because you already have all the time that you...
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Wa:082374977784 Jl. Tarum Barat Blk. E No.5, RT.4/RW.10, Wil. Kota, Kec. Duren Sawit, Kota...
Wa:082374977784 Jl. Sultan Hairun No.24, Kel Honipopu, Kec. Sirimau, Kota Ambon, Maluku 97124
Comments posted to this topic are about the item What Did Healthy Look Like?
How many types of DML triggers are there?
See possible answers