SQL Stuff
Get flash to fully experience Pearltrees
E - Homepage
Summary The TPC-E benchmark uses a database to model a brokerage firm with customers who generate transactions related to trades, account inquiries, and market research. The brokerage firm in turn interacts with financial markets to execute orders on behalf of the customers and updates relevant account information. The benchmark is “scalable,” meaning that the number of customers defined for the brokerage firm can be varied to represent the workloads of different-size businesses.
SQL Server resources and information - SearchSQLServer.com
SQL Server Platforms The SQL Server platform topics page provides resources for the enterprise database administration and development community covering the last three releases of Microsoft SQL Server: 2000, 2005 and 2008. Here you'll find details on the features, enhancements, service packs and upgrades for SQL Server 2005 and 2008, plus valuable advice for using Microsoft's legacy database management system, SQL Server 2000. Browse the SQL Server platform subtopics below to discover the latest news, expert technical advice and more.
SQL Server Customer Advisory Team - SQL Server Best Practices
The Technical Reference Guides for Designing Mission-Critical Solutions provide planning and architecture guidance for various mission-critical workloads deployed by users. These guides reflect the knowledge gained by the CAT team while working with customers on mission-critical deployments, many of these deployments being the result of deep customer engagements by the CAT organization. Each guide provides not only the key technical concepts and information helpful for design, but also “lessons learned,” best practices, and references to customer case studies. The Technical Reference Guides for Designing Mission-Critical Solutions cover three workloads: Online Transactional Processing (OLTP) These guides cover transactional and batch processing, relational and “beyond relational” data, scale-up and scale-out, data center optimization, compliance, high availability and disaster recovery, and data access.Pivot Tables
Microsoft masters-level certifications validate the deepest level of product expertise, as well as the ability to design and build the most innovative solutions for complex on-premises, off-premises, and hybrid enterprise environments using Microsoft technologies. The Microsoft Certified Master (MCM) certification program has evolved into the Microsoft Certified Solutions Master (MCSM) certification program to better reflect the broader and deeper skills required to build solutions on-premises or in the cloud. If you’re new to the master-level certification program, we recommend you start by exploring our new MCSM certifications . Note that the MCM training classes are no longer available.
New Path to Microsoft Certified Master: Microsoft SQL Server 2008
How to: Install SQL Server 2008 R2 from the Command Prompt
Before you run SQL Server Setup, review Planning a SQL Server Installation . Installing a new instance of SQL Server at the command prompt enables you to specify the features to install and how they should be configured. You can also specify silent, basic, or full interaction with the Setup user interface. Regardless of the installation method, you are required to confirm acceptance of the software license terms as an individual or on behalf of an entity, unless your use of the software is governed by a separate agreement such as a Microsoft volume licensing agreement or a third-party agreement with an ISV or OEM. The license terms are displayed for review and acceptance in the Setup user interface. Unattended installations (using the /Q or /QS parameters) must include the /IACCEPTSQLSERVERLICENSETERMS parameter.
Problem description: Feature request One of the most frequently asked questions in Reporting Services (RS) forums and newsgroups is: Why did not RS include the option to render documents into MS Word (.doc) format? According to BOL , Reporting Services 2005 has the ability to render/output documents into: CSV Acrobat (PDF) file Excel Web archive TIFF File XML Why did I marked XML? Because RS is not only able to output the results to raw XML format but also can make transformations based on XSLT stylesheets!
Reporting Services & MS Word format (.doc) rendering. | My daily work with SQL Server and Microsoft products.
SQLIO Disk Subsystem Benchmark Tool - Microsoft Download Center - Download Details
Overview SQLIO is a tool provided by Microsoft which can also be used to determine the I/O capacity of a given configuration. SQLIO is provided ‘as is’ and there is no support offered for any problems encountered when using the tool. Please refer to the EULA.doc for the license agreement prior to using this tool. Top of page
This article describes the SQLIOSim tool. You can use this tool to perform reliability and integrity tests on disk subsystems. These tests simulate read, write, checkpoint, backup, sort, and read-ahead activities for Microsoft SQL Server. However, if you have to perform benchmark tests and to determine I/O capacity of the storage system, you should use the SQLIO (http://www.microsoft.com/downloads/en/details.aspx?
How to use the SQLIOSim utility to simulate SQL Server activity on a disk subsystem
Introducing Business Intelligence Development Studio
The default menus that appear in Business Intelligence Development Studio are identical to those in Visual Studio. When you first open Business Intelligence Development Studio, before you modify the environment, open a solution, or open any projects, Business Intelligence Development Studio includes the following menus: When you open a specific project type in Business Intelligence Development Studio, additional menus are added to the menu bar and new options may appear on the default menus in Business Intelligence Development Studio.
