SQL Server Questions and Answers

Welcome

Help

O'Reilly Answers is a community site for sharing knowledge, asking questions, and providing answers that brings together our customers, authors, editors, conference speakers, and Foo (Friends of O'Reilly). More »

Send us feedback

Topics: SQL Server

SQL Server Feed SQL Server Open Questions Feed SQL Server Email Open Questions via Email

How to Configure SQL Reporting Services Integration with SharePoint 2010

By Alanle [MS} : 27 August 2010 - 04:36 AM
In a TechNet Magazine article I wrote, called Working Together: SQL Server 2008 R2 Reporting Services Integration in SharePoint 2010 I cover how to configure SQL Reporting Services for SharePoint Inte...
Tags:
1Vote

0Comments
How to Use SQL Server Agent

By adfm : 01 June 2010 - 09:01 AM
If you'd like to automate some of your SQL server tasks, check out SQL Server Agent. With it you can schedule jobs, restart services, send email alerts, and perform other automation. This excer...
Tags:
0Votes

0Comments
Copying User Accounts, Tables, Views, and Other Objects from One SQL Server Database to Another

By adfm : 22 April 2010 - 02:29 PM
If you manage a Microsoft SQL Server 2008 installation and would like to automate some of your migration tasks you'll appreciate this excerpt from William R. Stanek's Microsoft SQL Server 2008 Admin...
Tags:
0Votes

1Comment
Tips for Protecting Against SQL Injection in SQL Server 2008

By adfm : 21 April 2010 - 03:14 PM
SQL injection attacks are one of the most prevalent security concerns today. In this excerpt from Itzik Ben-Gan, et al.'s Inside Microsoft SQL Server 2008: T-SQL Programming you'll learn a few tips ...
Tags:
0Votes

0Comments
SQL Server OPENQUERY limits

Asked by John.Peters : 04 November 2009 - 08:00 AM
Tags:
0Answers

0Comments
How to Use SQL to Search for Keywords Without the LIKE Operator

By andr3w : 27 October 2009 - 10:06 PM
You can do a simple keyword search using the LIKE operator. Unfortunately, this can be slow. Fortunately, an efficient keyword search is available in many systems.Often you must store ...
Tags:
1Vote

0Comments