MS SQL Server Tutorials, Tools & More
SQL Overview
First released for IBM OS/2 in 1989, Microsoft SQL Server has developed over the years into one of the leading relational database management system (RDMS) platforms for the enterprise for the Windows Server platform. The most current version is SQL Server 2012, which is available in Standard, Enterprise, and Business Intelligence editions.
Sponsored | SQL
Recent SQL Articles
How to Connect CentOS Web Server to a SQL Server
Setting up an internal CentOS web server to talk to a SQL server can be quite the process. Peter Washburn walks you through the steps.
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
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
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
Featured Solutions | Sponsored
Editor's Picks
How to Connect CentOS Web Server to a SQL Server
Setting up an internal CentOS web server to talk to a SQL server can be quite the process. Peter Washburn walks you through the steps.
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
How to Plan SQL Server Database Files
It’s a common misconception that you will get a performance gain by using several log files. Although this is something we see quite often, Sean McCown,
SQL Server Recovery Models
In SQL Server 2008 there are 3 recovery models you can use: simple, bulk-logged, and full. These recovery models really just define how log management behaves
How to Design a Backup Strategy in SQL Server
Designing a backup strategy in SQL is fairly straightforward, but it can get complicated when you’ve got a lot of moving pieces in your scenario. Sean McCown,
Featured Content for SQL | Sponsored
- FREE eBook: Introducing Microsoft SQL Server 2012 [PDF]Microsoft SQL Server 2012 is Microsoft’s first cloud-ready information platform. It gives organizations effective tools to protect, unlock, and scale the power of their data, and it works across a variety of devices and data sources, from desktops, phones, and tablets, to datacenters and both private and public clouds.
- 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.
- Microsoft Hyper-V Server 2012 - Download Free TrialOne of the most common uses for Hyper-V Server is in Virtual Desktop Infrastructure (VDI) environments. Hyper-V Server gives IT professionals a cost effective VDI solution with simplified administration, flexible storage options, and dynamic allocation of resources.
