Microsoft SQL Server 2014 has been released to manufacturing, and customers can download the new version on April 1st.
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.
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.
Learn how to set up an internal CentOS web server to talk to a SQL server in this handy how-to article.
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.
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.
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.
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.
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.
Sean McCown takes us beyond the basics of scripting database objects in PowerShell. This article explains how to set advanced scripting options using SMO.