- Setting Up Transactional Replication with SQL Server
- Mar 26, 2004
- Setup isn't the only piece of the replication puzzle; yet getting it wrong can cause many headaches. In this second episode of his replication series, Baya Pavliashvili teaches you how to set up replication through wizards and through scripts.
|
- Setting Up Transactional Replication with SQL Server 2005
- Aug 11, 2006
- Baya Pavliashvili walks us through the use of the SQL Server 2005 wizards and scripts for setting up transactional replication and points out some of the cool new features of the latest version.
|
- Sorting Retrieved Data from SQL Databases
- Jun 18, 2004
- In this lesson, taken from Sams Teach Yourself SQL in 10 Minutes, you will learn how to use the SELECT statement's ORDER BY clause to sort retrieved data as needed.
|
- SQL 2005 Beta: .NET Strengths, Web Weaknesses
- Aug 13, 2004
- Businesses are testing Microsoft's SQL Server 2005 as a way of meeting diverse needs. Jacqueline Emigh interviewed Long & Foster's Lance Morimoto to get his take on how promising the beta looks for the real estate firm where he works.
|
- SQL Building Blocks and Server Settings
- Aug 6, 2004
- This chapter covers the building blocks available to the database designer and database user to create and modify database objects and data. The SQL Data Types will be covered along with data representation as literals (constants) and expressions.
|
- SQL Profiler
- Jan 25, 2002
- In this excerpt from his book Essential SQL Server 2000: An Administration Handbook, Buck Woody gives a quick overview of the SQL Profiler tool, which is used to monitor SQL Server, all the way down to the individual SQL statements.
|
- SQL Queries for Mere Mortals: Thinking in Sets
-
By
Michael J. Hernandez
- Nov 30, 2007
- This sample chapter discusses the concept of a set along with each of the other major set operations in SQL.
|
- SQL Server 2000 and the XDR Schema
- Sep 21, 2001
- Schemas, Microsoft's version of XML schemas, create XML views of relational data which can then be queried via XPath expressions. This article looks at XDR Schemas and how they work with SQL Server 2000.
|
- SQL Server 2000 and XML
- Aug 8, 2003
- Discover the many different ways SQL Server 2000 supports XML with a comprehensive look at both out-of-the-box support and the SQLXML 3.0 add-on.
|
- SQL Server 2005 DB Snapshot: Imperfect Yet Useful?
- Jan 20, 2006
- SQL Server 2005 offers a new tool, Database Snapshot, which helps protect against user errors. It's a great feature, in some ways. But Ravindra Okade cautions against relying on it as an all-purpose rescue device.
|
- SQL Server 2005 Setup and Deployment
- Oct 28, 2005
- SQL Server 2005 setup is designed to minimize installation failures and improve the overall setup experience. This chapter introduces the concepts related to SQL Server 2005 setup and deployment. Topics covered include which edition is right for you, the hardware and software requirements, and walks you through the upgrade process.
|
- SQL Server 2005 Transactional Replication Agents
- Oct 20, 2006
- SQL Server 2005 replication agents are configured optimally out of the box, but occasionally you might need to alter the default behavior by tweaking the agent's parameters. Baya Pavliashvili encourages you to learn the new options available with each replication agent and how to fine-tune these options for your applications.
|
- SQL Server 2005: Two Little Known Features That Matter Big!
- Jan 28, 2005
- SQL Server 2005 brings a host of new features to the table. Ravindra Okade details a couple of nuggets that are not easy to find but can be very useful to every developer and DBA. Synonyms are very handy for managing database objects. And non-clustered index included columns, although a mouthful, is a unique feature that can drastically optimize queries.
|
- SQL Server 2005's Snapshot Isolation
- Dec 23, 2004
- SQL Server 2005 is just around the corner. Are you looking to justify the upgrade to your management? Here is a great feature to include: Snapshot Isolation. Read Ravindra Okade's discussion to see what Snapshot Isolation is all about and to learn how to implement it.
|
- SQL Server AlwaysOn and Availability Groups
- Jun 29, 2015
- SQL Server's AlwaysOn is taking the database world by storm. This chapter from Microsoft SQL Server 2014 Unleashed dives into the AlwaysOn new features and availability groups.
|
- SQL Server Analysis Services 2005/2008 Administration
- Jan 22, 2010
- Baya Dewald shows you the skills required for administering the latest versions of Analysis Services and how they compare to managing relational databases.
|
- SQL Server and OPENXML
- May 1, 2002
- Going through thousands of lines of XML can quickly degrade performance. That’s why it is nice to have the OPENXML function, which does the parsing work for you fairly efficiently.
|
- SQL Server Attacks: Hacking, Cracking, and Protection Techniques
- Nov 29, 2002
- Seth Fogie and Dr. Cyrus Peikari uncover two main methods for hacking SQL servers – and show how you can guard against them.
|
- SQL Server Forensic Investigation Scenario
- Apr 13, 2009
- This chapter walks through an actual forensic investigation scenario, showing the logical progression of events during an investigation.
|
- SQL Server Kicks Oracle's Butt
- Mar 25, 2005
- Oracle enthusiasts love to bash SQL Server, and Buck Woody thinks it's high time that the debate is taken to a professional form. If it's to be an argument, he wants to involve the discipline of logic to see which is better: SQL Server or Oracle. Care to see who wins?
|