Home > Articles > Data > SQL Server

SQL Server

RSS Feed Subscribe to this topic  RSS details

179 Items

Sort by Date | Title

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?

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