MS SQL Server Tutorials, Tools & More
Welcome to the Petri SQL Server Center! Check out our extensive tutorial articles on installing, managing, and troubleshooting MS SQL Server databases.
SQL Server Updates
[VIDEO] SQL Server 2008: The Powerhouse
Learn Microsoft's Data Platform Vision and new capabilites of SQL Server 2008.
Interview with Don Jones at Windows Connections 2011
TrainSignal recently had the opportunity to sit down with Don Jones at Windows Connections 2011 in Orlando to discuss the importance of learning PowerShell. The overriding message of the interview is that if you plan to learn one thing in 2011, it should be PowerShell. Video and transcript included.
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.
Recommended Reading:
- FREE Download: Lync Server Administration Guide & PowerShell SupplementLearn how to do all the things in the Lync Server Administration Guide by using PowerShell. Now available as MS Word document for download.
- Data Warehousing 2.0 and SQL Server: Architecture and VisionArchitecture and data warehousing are not static. From the first notion of a data warehouse to a full-blown analytical processing architecture that includes data marts, ETL, near line storage, exploration warehouses, and other constructs, data warehousing and its associated architecture continue to evolve.
- StreamInsight 1.2 – New in SQL Server Code Name “Denali” CTP3The upcoming SQL Server Code Name “Denali” release will include key improvements for StreamInsight. This video covers the highlights 4 major areas which are part of SQL Server Code Name "Denali” CTP3.
- FREE eBook Preview: Microsoft SQL Server Code Name “Denali” [PDF]Introducing a new free eBook in draft preview: Microsoft SQL Server Code Name "Denali". Special excerpt from the soon-to-be-released complete book, includes chapters on High Availability and Disaster Recovery Enhancements, AlwaysOn Availability Groups, Active Secondaries, AlwaysOn Failover Cluster Instances, Support for Deploying SQL Server Denali on Windows Server Core and more!!
SQL Server Tutorials
How to Install SQL Server 2008
While a SQL Server 2008 installation is fairly straight forward, a little planning and background knowledge can ensure the a successful install. Microsoft SQL MVP Sean McCown shares his insight with the readers.
Troubleshooting a Slow Database Server: Is SQL Server the Cause?
Sean McCown, Microsoft SQL MVP, offers valuable insight on using Perfmon to determine if database slowness is being caused by SQL issues.
How to Create a Simple Backup Job in SQL Server
Because users don't want to manually backup their SQL databases every day, Sean McCown Microsoft SQL MVP, provides us with several ways to create a backup job in SQL Server 2008.
More SQL Server Insights from the Midnight DBA's
- How to Plan SQL Server Database Files
- How to Design and Build SQL Server Tables
- How to Manage SQL Server Database Files
- How to Design a Backup Strategy in SQL Server
- SQL Server Recovery Models
- Troubleshoot a Slow Database in SQL Server 2008
- How to Choose a SQL Server Authentication Mode
- How to Gain Exclusive Access to a SQL Server Database
Tools for SQL Administrators
SQL Server 2008 Value Calculator
Considering a better data management solution? Do the Math on SQL Server value and you’ll see the efficiencies add up.
Featured SQL Downloads
- Download SQL Server 2012As the foundation of the cloud-ready information platform, SQL Server 2012 will help organizations unlock breakthrough insights across the organization as well quickly build solutions and extend data across on-premises and public cloud backed by mission critical confidence.
- SolarWinds FREE SQL Monitor ToolSolarWinds' Free WMI Monitor with built-in SQL support makes it easy to monitor your Microsoft® SQL servers and gives you amazing visibility into real-time performance with a slick desktop dashboard.
- FREE Download: SQL Server 2008 R2 Resource KitComprehensive bundle of product specs, FAQs and whitepapers to get you started with your Microsoft SQL Server 2008 R2 implementation.
- Download Microsoft SQL Server Data Tools CTP4SQL Server Data Tools (SSDT) is an integrated toolset that allows database developers and DBAs to develop, debug and deploy SQL Server and SQL Azure databases. SSDT supports Azure and versions of SQL Server 2005 and later, including SQL Server 2012.
Further Reading
- Interview with Don Jones at Windows Connections 2011
- Beginning SSIS: How to Create a Basic Data Load Package in SQL Server Integration Services
- Changing SQL Server Job Owners with PowerShell
- Finding What You Need in PowerShell
- PowerShell Basics for DBAs
- Why Should DBAs Care About PowerShell?
- Creating an Enterprise Scripting Template in PowerShell
- Scripting Database Objects with Advanced Scripting Options in PowerShell
- Scripting Database Objects in PowerShell
- Introduction to Indexes in SQL Server
- How to Create and Edit a Report in SQL Server Reporting Services
- SQL Server Reporting Services: An Introduction
- How to Move Database Files in SQL Server: Part 2
- How to Move Database Files in SQL Server: Part 1
- Introduction to the SQL Server Integration Services (SSIS) Development Environment
- Monitoring Your Database with SQL Profiler
- String Data Types in SQL Server: VARCHAR vs. CHAR
- Gaining Exclusive Access to a SQL Server Database
- How to Install SQL Server 2008
- Troubleshooting a Slow Database Server: Is SQL Server the Cause?
- How to Plan SQL Server Database Files
- Train Signal Releases SQL Server 2008 Administration Training
- What is Parallel Data Warehouse?
- What is PowerPivot?
- What is Application and Multi-server Management in SQL Server 2008 R2?
- What is StreamInsight?
- Create Tables in SQL Server 2008 - Part 1 of 2
- How to Design and Build SQL Server Tables - Part 2 of 2
- SQL Server Recovery Models
- Top 4 Reasons to Move to Microsoft SQL Server 2008 R2
- Troubleshoot a Slow Database in SQL Server 2008
- How to Design a Backup Strategy in SQL Server
- How to Choose a SQL Server Authentication Mode
- How to Manage SQL Server Database Files
- How to Create a Simple Backup Job in SQL Server
- How to Quickly Analyze your Windows Server 2008 Performance Monitor Logs
