SQL Server

LATEST

SQL Server 2014 Released to Manufacturing

Microsoft SQL Server 2014 has been released to manufacturing, and customers can download the new version on April 1st.

View Article

SharePoint Planning: Understanding SQL Server High Availability Options

Need to recover a SQL Server? Learn how to wield these helpful SQL Server solutions: SQL database mirroring, SQL server clustering, and SQL Server AlwaysOn.

View Article

What’s New in SQL Server 2014

Curious what new features Microsoft SQL Server 2014 offers? We’ve updated this guide with the latest info to help you decide if you’re due for an upgrade.

View Article

How to Connect CentOS Web Server to a SQL Server

Learn how to set up an internal CentOS web server to talk to a SQL server in this handy how-to article.

View Article

Beginning SSIS: How to Create a Basic Data Load Package in SQL Server Integration Services

Step-by-step guide by Jennifer McCown on creating a basic data load package in SQL Server Integration Services. SSIS is used to extract data from sources such as SQL Server databases, flat files, Excel files, Oracle and DB2 databases, perform data manipulation and transformation, and deliver it to one or more data destinations.

View Article

Changing SQL Server Job Owners with PowerShell

Using PowerShell for changing job owners in SQL Server. Sean McCown demonstrates how PowerShell is a more efficient option than SSMS or T-SQL when changing job owners in bulk.

View Article

Finding What You Need in PowerShell

Sean McCown provides an overview of working with cmdlets in PowerShell. Covers how to run help on cmdlets, and search specific cmdlets to learn what’s available in PowerShell, including the use of format-table and get-member to control how resulting information is displayed.

View Article

PowerShell Basics for DBAs

Overview of PowerShell basics by Sean McCown. PowerShell makes it possible for DBAs to easily manage multiple servers at once, often with very little coding. This article explains how PowerShell is organized, and how to get information about the different drives you work with.

View Article

Why Should DBAs Care About PowerShell?

Why Should DBAs Care About PowerShell? Sean McCown answers this question by demonstrating the simplicity of scripting in PowerShell, in contrast to T-SQL and VBScript, through a variety of real world examples.

View Article

Scripting Database Objects with Advanced Scripting Options in PowerShell

Sean McCown takes us beyond the basics of scripting database objects in PowerShell. This article explains how to set advanced scripting options using SMO.

View Article
Go to page