Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2013/09/25 to 2013/10/02

SQL in the City Charlotte 2013

Join Red Gate on the day before PASS Summit for a full-day of free training from SQL Server MVPs and top presenters. Get $200 off your PASS conference ticket when you register for SQL in the City Charlotte, which takes place on Monday October 14.   Read more...
By Press Release 2013/10/02 (first published: 2013/08/29) | Source: Red-Gate | Category: sql in the city
Rating: (not yet rated)  Rate this |   Briefcase | 3,645 reads

Stairway to MDX - Level 1: Getting Started with MDX

To learn MDX, there is really no alternative to installing the system and trying out the statements, and experimenting. William Pearson, the well-known expert on MDX, kicks off a stairway series on this important topic by getting you running from a standing start.  Read more...
By Bill Pearson 2013/10/02 (first published: 2011/03/02) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 61,571 reads

Get CPU and Cores for SQL Server 2012 Licensing

With SQL Server 2012, Microsoft introduced a new licensing model; licensing per core replaced the licensing per processor. We need to adjust budget to reflect licensing changes for our next Enterprise Agreement renewal, but we do not have processor core information from any of our server inventory tools. This tip explains how to quickly gather information about each server's processor cores without logging in to each server.  Read more...
By Additional Articles 2013/10/02 | Source: MSSQLTips.com | Category: licensing
Rating: (not yet rated)  Rate this |   Briefcase | 3,272 reads

Data Mining Introduction Part 7: Microsoft Association

This article is part of the Data Mining introduction series. This article is about the Microsoft Association algorithm.   Read more...
Rating: |  Discuss |   Briefcase | 4,098 reads

SQL Monitor Performance Metric: SQL Server: Plan Cache: Cache Pages Total

This metric collects the total amount of memory, in kilobytes, used by the plan cache of an instance to help identify memory pressure or plan cache pollution. It is similar to the SQL Server: memory manager: SQL cache memory counter, but instead of providing the number of 8-kilobyte pages that make up the plan cache, it provides the total memory used.  Read more...
By Additional Articles 2013/10/01 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 2,646 reads

SQL in the City Atlanta 2013

SQL in the City is coming to Atlanta on October 11. The second stop on the SQL in the City US Tour brings you SQL Server MVP experts including, Steve Jones and Grant Fritchey. Learn top tips and best practices for SQL Server database development and administration, discover the latest Red Gate tools, and network with fellow data professionals.   Read more...
By Press Release 2013/10/01 (first published: 2013/08/28) | Source: Red-Gate | Category: sql in the city
Rating: (not yet rated)  Rate this |   Briefcase | 3,356 reads

Database Backup and Recovery in the Age of Big Data

Big data is the latest craze. Hardware and software vendors have overwhelmed IT departments with high-speed analytical software, proprietary high-performance hardware, and columnar-based data stores promising quick access and lightning-fast answers to ad hoc analytical queries. Forgotten in this blast of technology are the database administrators' most important responsibilities: backup and recovery.   Read more...
By Additional Articles 2013/10/01 | Source: Database Journal | Category: big data
Rating:  Rate this |   Briefcase | 3,346 reads

SQL in the City Pasadena 2013

SQL in the City is coming to Pasadena on October 9. Register for a full day of free SQL Server training the Red Gate way. Top tips and best practices for SQL Server database development and administration will be presented by SQL Server MVP experts, including Steve Jones and Grant Fritchey. You’ll also see Red Gate tools in action and have the chance to network with other data professionals.   Read more...
By Press Release 2013/09/30 (first published: 2013/08/27) | Source: Red-Gate | Category: sql in the city
Rating: (not yet rated)  Rate this |   Briefcase | 3,456 reads

The Fundamentals of SQL Server Replication by Sebastian Meine

Many of my clients need to make data that lives on one server available on another server. There are many reasons for such a requirement. You might want to speed up cross-server queries by providing a local copy of the data. Or you might want to make the data available to resource intensive reporting queries without impacting the OLTP load, maybe even with an intentional delay so you're always reporting against complete days only. Finally, you might be looking to implement high availability. In all these situations, SQL Server Replication is a viable option to look at when planning for the implemen­tation of such a requirement.  Read more...
By Sebastian Meine 2013/09/30 | Source: SQLServerCentral.com | Category: books
Rating: |  Discuss |   Briefcase | 5,507 reads

Developing for Delivery, a Practical Example

Richard Morris interviewed Michael Stoop, a database developer at Calvi, Europe's leading provider of Telecom Invoice Management software. The discussion focused on how Calvi transformed their database delivery process to accommodate massive database growth, statutory regulations, and developments in their application. Here's their story.  Read more...
By Additional Articles 2013/09/30 | Source: SimpleTalk | Category: database deployment
Rating:  Rate this |   Briefcase | 2,634 reads

An Interview with Allen Kinsel, PASS Board Candidate

Allen Kinsel is running for the board of directors of PASS. He took a little time to answer some questions from Steve Jones  Read more...
By Steve Jones 2013/09/27 | Source: SQLServerCentral.com | Category: interviews
Rating: (not yet rated) |  Discuss |   Briefcase | 421 reads

Generating Random Numbers in SQL Server Without Collisions

From time to time, I see a requirement to generate random identifiers for things like users or orders. People want to use random numbers so that the "next" identifier is not guessable, or to prevent insight into how many new users or orders are being generated in a given time frame, but they don't want to run into any duplicates. We can trade a bit of disk space and relatively predictable (but not optimal) performance for the guarantee of no collisions, no matter how many random numbers we've already used.   Read more...
By Additional Articles 2013/09/27 | Source: MSSQLTips.com | Category: generate numbers
Rating: (not yet rated)  Rate this |   Briefcase | 3,569 reads

Extended Properties Introduction

Part one of a four part series intent on demystifying and making more accessible SQL Server extended properties  Read more...
By Adam Aspin 2013/09/27 (first published: 2011/03/17) | Source: SQLServerCentral.com | Category: metadata
Rating: |  Discuss |   Briefcase | 14,834 reads

Calculating Elapsed Times (SQL Spackle)

Calculating elapsed time between time values can be an interesting problem that is easily solved even when data anomalies are present.  Read more...
By Dwain Camps 2013/09/26 | Source: SQLServerCentral.com | Category: sql elapsed times
Rating: |  Discuss |   Briefcase | 6,807 reads

Red Gate will be exhibiting at SQL Server Live! Orlando

SQL Server Live! is coming to Orlando November 18-22. SQL Server Live! provides comprehensive education and knowledge share on SQL Server database management, data warehouse/BI model design, performance tuning, troubleshooting and more.   Read more...
By Press Release 2013/09/26 | Source: Red-Gate | Category: events
Rating: (not yet rated) |  Discuss |   Briefcase | 367 reads

A Practical Guide to Microsoft Hyper-V Replica: Part II

A Hyper-V replica installation provides rapid disaster-recovery by asynchronously replicating a VM running at a primary site to a replica site. Know how to prepare for something to go wrong at the Primary Server/Site? In this article Nirmal Sharma presents the Replication options for a Replica Virtual Machine with a focus on Hyper-V Failover.  Read more...
By Additional Articles 2013/09/26 | Source: SimpleTalk | Category: virtualization
Rating:  Rate this |   Briefcase | 2,470 reads

Stairway to SQL PowerShell Level 2: SQL PowerShell Setup and Config

Now that you know how to get started with PowerShell, it is time to configure PowerShell for SQL Server use. This level covers the components you'll need and how to configure them.  Read more...
By Ben Miller 2013/09/25 (first published: 2012/08/15) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 14,412 reads

SSIS 2012 - Introduction to Windows Azure SQL Databases

When discussing SQL Server 2012 Integration Services, we have been dealing mainly with the traditional data management model, where the entire SQL Server environment resides on-premise. This once predominant paradigm is obviously changing, with hosted solutions (in the form of both private and public clouds) becoming increasingly common. In order to properly account for this trend, we turn our attention to the role that SSIS can serve in a mixed environment, where a part of the SQL Server estate is located in Windows Azure.  Read more...
By Additional Articles 2013/09/25 | Source: Database Journal | Category: sql azure
Rating: (not yet rated)  Rate this |   Briefcase | 2,355 reads