(Steve Jones) Recently I was working with some data and I needed to build some complex strings. However there was a catch. These strings would be used for for shell commands. I ran into an interesting problem that I solved one way, and then, while digging through BOL on another matter, I found a bet
Tag: sql server
Data-Modeling Tools Aren’t Physically Fit
(Brian Moran) In March, I pointed you to a Microsoft survey about a new data-modeling tool that Microsoft hasn’t yet announced but is presumably planning. In my commentary “Data Modelers, Arise, and Take Microsoft’s New Survey”, I asked you what design features are most important for Microsoft to in
Programming SQL Server
(Jurgen Postelmans) This article will give you an overview how you can write stored procedures, triggers and user-defined functions in SQL Server “Yukon” using C# as a programming language.
Sorting a DropDownList by Value
(Trent Miesner) The DropDownList control does not expose a sort method to sort items by either the value or the displayed text. Usually this is not a problem because the DropDownList will display the items in the order they were loaded into the control. Typically it’s easy enough to ensure the data
Opening Microsoft’s Knowledge Vault
(Susan Kuchinskas) Microsoft announced a pilot program that will let partners add to its official Knowledge Base for the first time. The announcement made during the Redmond, Wash.-based software vendor’s Valuable Professional (MVP) Summit, along with three other recent moves, may be designed to
Optimizing Microsoft SQL Server Analysis Services: Optimization Tools: Partition Wizard
(William E. Pearson, III) We briefly mentioned partitions in the first article of this series, Optimization Tools: The Storage Design Wizard, within which we introduced the Storage Design Wizard. The Storage Design Wizard, as we discovered, enables us to manage aggregations on a partition-by-partiti
The Java Connection
(Michael Otey) An estimated 8 million developers use Visual Basic (VB) 6.0—by far the most common language for writing SQL Server-based business applications. However, VB 6.0 isn’t the language of choice for many enterprise projects. VB 6.0 isn’t fully object oriented, and it relies on COM, can be d
Understanding MSBuild in Longhorn
(Jesus Rodriguez) The concepts of the build engine have changed in the recent years. As part of the code name Longhorn Microsoft propose a new build system named MSBuild. MSBuild defines what are going to be build as well as how are going to be build. In this article we explore the main MSBuild conc
Data Migration : Step by Step
(Chris Kempster) This article covers a wide variety of areas concerned with data migration. Primarily, it focuses on process, standards and some of the many issues to consider when undertaking this role. (R)
OpenRowSource and OpenRowSet in SQL Server 2000
(Muthusamy Anantha Kumar) SQL Server Data Base Administrators are often exposed to situations in running ad-hoc queries using external data sources such as MS-Access database or Excel sheets or CSV files or text files. For such frequent requests, Database Administrators usually use “linked servers”