Additional Articles

Disk Partitiona Alignment Best Practices for SQL Server

by Additional Articles

SQLServerCentral

Performance Tuning

Disk partition alignment is a powerful tool for improving SQL Server performance. Configuring optimal disk performance is often viewed as much art as science. A best practice that is essential yet often overlooked is disk partition alignment. Windows Server 2008 attempts to align new partitions out-of-the-box, yet disk partition alignment remains a relevant technology for partitions created on prior versions of Windows.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2009-08-18

3,407 reads

How to Specify Command Line Parameters for DTEXEC Using Command Files

by Additional Articles

MSSQLTips.com

Integration Services (SSIS)

Everything I've read about the built-in configuration options is that you can retrieve values from a SQL Server table, an XML file, etc. but I really prefer to just use the command line options. I'm currently specifying 10 or more command line options on average. Do you have any ideas on a better way to do this?

2009-08-18

3,212 reads

Granting limited permissions to create views in another schema in SQL Server - Part 2

by Additional Articles

MSSQLTips.com

Schemas

In a previous tip, Granting limited permissions to create views in another schema in SQL Server, I showed how to use the CREATE VIEW permission and the ALTER SCHEMA permission to allow users to create new views using the same schema as the tables. However, I have found that the users can alter and drop tables in this schema which is beyond what I want them to do. A DENY CREATE TABLE does not work, so what can I do to prevent them from touching the tables in this way? In this tip I will show you how you can use a DDL trigger to prevent this unneeded access.

2009-08-17

3,444 reads

How SQL Server recovery models impact your SharePoint ...

by Additional Articles

SQLServerCentral

Backup and restore

SharePoint administrators can minimize data loss by selecting the appropriate SQL Server recovery model. But which model is right for your enterprise?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2009-08-17

4,000 reads

How to isolate the current running commands in SQL Server

by Additional Articles

MSSQLTips.com

Administration

Examining what has already occurred, while valuable in some cases is most likely not as important as what is currently taxing your server. This being the case, how do you examine the currently executing statement for each of the requests issued against your SQL Server instance?

2009-08-14

4,448 reads

Using Twitter and PowerShell to Find Technical Information and Join a Community

by Additional Articles

SimpleTalk

Twitter

Using PowerShell and a little bit of .NET Framework and XML knowledge, it is possible to delve a little deeper into the information which is potentially available to you from Twitter. Jonathan explains about Twitter and shows how to use Powershell to access twitter automatically.

2009-08-14

2,643 reads

Auto alert for SQL Agent jobs when they are enabled or disabled

by Additional Articles

MSSQLTips.com

SQL Agent

It is often the case in large DBA teams where multiple DBAs can administer the same SQL Servers and it is not apparent to one DBA the importance of some of the jobs to another DBA. In this tip I show how you can be alerted of these changes.

2009-08-13

3,880 reads

Using Transfer SQL Server Objects Task and Execute SQL Tasks in SSIS

by Additional Articles

SQLServerCentral

Integration Services (SSIS)

The Transfer SQL Server Objects Tasks is a very useful tool in SQL Server 2005 to move objects between SQL Server Instances.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2009-08-13

2,578 reads

Q&A: The skinny on Reporting Services 2008

by Additional Articles

SQLServerCentral

Reporting Services (SSRS)

Get the inside scoop on SSRS 2008 with Michael Lisin and Jim Joseph, co-authors of the new book, "Microsoft SQL Server 2008 Reporting Services Unleashed."

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2009-08-12

4,114 reads

Where is my app.config for SSIS?

by Additional Articles

SQLServerCentral

Integration Services (SSIS)

Sometimes when working with SSIS you need to add or change settings in the .NET application configuration file, which can be a bit confusing when you are building a SSIS package not an application. First of all lets review a couple of examples where you may need to do this.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2009-08-12

3,085 reads

All authors

Additional Articles

Disk Partitiona Alignment Best Practices for SQL Server

How to Specify Command Line Parameters for DTEXEC Using Command Files

Granting limited permissions to create views in another schema in SQL Server - Part 2

How SQL Server recovery models impact your SharePoint ...

How to isolate the current running commands in SQL Server

Using Twitter and PowerShell to Find Technical Information and Join a Community

Auto alert for SQL Agent jobs when they are enabled or disabled

Using Transfer SQL Server Objects Task and Execute SQL Tasks in SSIS

Q&A: The skinny on Reporting Services 2008

Where is my app.config for SSIS?

Blogs

Exploring DiskANN: Part I: Understanding the Algorithm before the disk

Learning Tool – Deepstash

New article – migrating from a named instance

Forums

Understanding Temp Tables and Table Variables in SQL Server

The Data API Builder MCP Server Tools

Collecting Data Is Hard

Question of the Day

The Data API Builder MCP Server Tools