Home > Articles > Data > SQL Server

SQL Server

RSS Feed Subscribe to this topic  RSS details

179 Items

Sort by Date | Title

Optimizing Transact-SQL Code
By Baya Dewald, Kevin Kline
Aug 9, 2002
Here are some tips and tricks for avoiding common pitfalls and writing good T-SQL code, as well as some advanced options that you might find useful.
Options Affecting SQL Server Locking Behavior
By Baya Dewald, Kevin Kline
May 31, 2002
If you need to alter SQL Server's default locking behavior, learn about the query hints and SET options that can also be used to alter the way SQL Server locks resources.
Oracle versus SQL Server in the Enterprise
By David Hull
Mar 25, 2005
Can Oracle kick SQL Server's behind? Oracle expert David Hull throws down the gauntlet to Microsoft devotees.
Oracle vs. SQL Server, Part 5 - Dissecting Oracle 9i
By Rob Hawthorne
Aug 30, 2002
See the pure power of this awarding-winning RDBMS by looking at the outstanding features and benefits that it has to offer you.
Oracle vs. SQL Server, Part 3 - A Closer Look at SQL Server
By Rob Hawthorne
Aug 2, 2002
Explore Microsoft's SQL Server 2000, looking at features and benefits of this relational database management system.
Oracle vs. SQL Server, Part 4 - The Softer Side of SQL Server 2000
By Rob Hawthorne
Aug 9, 2002
See the conclusion of Rob Hawthorne's review of the good, the bad, and the ugly in Microsoft's SQL Server 2000. And there's more on Oracle to come!
Oracle Web Application Programming for PL/SQL Developers: Remote Server Access
By Susan Boardman, Melanie Caffrey, Solomon Morse, Benjamin Rosenzweig
Jun 20, 2003
Get the basics of remote server access as well as how you can benefit from this access today. You will experience workable examples that will bring you to an immediate and practical understanding of remote server access.
Performing General Administration Tasks in SQL Server 2000
By Rob Hawthorne
Oct 5, 2001
Many database administration tasks can be done automatically with SQL Server 2000. In this excerpt from SQL Server 2000 Database Development From Scratch, author Rob Hawthorne discusses the administrative tasks that can be automated by setting up ...
Populating a Data Warehouse with SQL Server 2000
By Baya Dewald
Nov 9, 2001
In this article, Baya Pavliashvili provides a tutorial for populating data warehouses. The article includes a number of tips for choosing the storage model, indexing fact and dimension tables, and much more.
Practical Business Intelligence with SQL Server 2005: Data Mining
By John C. Hancock, Roger Toren
Nov 10, 2006
This sample chapter looks at how to use some of the data mining features in SQL Server Analysis Services 2005 to perform tasks such as customer segmentation and market basket analysis.
Preface to Microsoft SQL Server 2014 Unleashed
By Ray Rankins, Paul Bertucci, Chris Gallelli, Alex T. Silverstein
May 26, 2015
The authors of Microsoft SQL Server 2014 Unleashed introduce their book and discuss its intended audience, what the book covers, and conventions used in the book.
Recommended Practices for SQL Server Analysis Services 2005/2008 Design
By Baya Dewald
Feb 8, 2010
Baya Dewald offers recommendations for avoiding the most commonly encountered dimension/partition design pitfalls for SQL Server Analysis Services 2005 and 2008.
Relational Databases 101
By William R. Vaughn
Sep 14, 2007
Design relational databases that can perform better, be easier to maintain, and be more successful.
Relational Databases 101
Dec 29, 2006
Relationships Should NOT Be Natural!
By Peter Petroski
Apr 30, 2004
Using naturally occurring data can have negative impact on database performance. We should restrict ourselves to using cold, hard, sequential numbers, and forget about those warm, comfortable relationships with data that are so familiar.
Replicating Code Modules in SQL Server
By Baya Dewald
Oct 15, 2004
Replicating table articles can help you maintain multiple databases in sync. But what about stored procedures, views, and user defined functions? Do you have to apply the same code changes on a multitude of servers you manage? Fortunately, there is a way to synchronize the schema of non-table articles; and replicating the execution of stored procedures can provide better performance than replicating individual commands when adding, modifying, or removing rows from tables. Read on to find out how!
Replicating Code Modules with SQL Server 2005
By Baya Dewald
Sep 15, 2006
As with previous releases of the software, SQL Server 2005 enables you to replicate code modules. Baya Pavliashvili gives you an overview of replicating code modules and explains when it is beneficial to do so.
Reporting Services Architecture in SQL Server 2005
By Michael Lisin
Jun 30, 2006
SSRS is a comprehensive and extensible reporting platform, which includes an integrated set of processing components, programmatic interfaces, and tools. Processing components are the basis for the multilayered architecture of SSRS and interact with each other to retrieve data, process layout, render, and deliver a report to a target destination.
Serve SQL Data in XML Format
By Ivan Pepelnjak
Sep 28, 2007
Learn how to extract data from SQL databases and serve it to an AJAX application running in a web browser.
Server and Client Configuration and Troubleshooting
By Sharon Dooley
Jun 22, 2001
This sample chapter covers SQL Server 7's startup, some of its configuration options, and its interaction with NT. Also discussed is server troubleshooting and client setup and configuration. Finally, this chapter shows you a few SQL Server tricks.

<< < Prev Page 3 4 5 6 7 Next >