SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2013/09/24 to 2013/10/01

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 | 5,440 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: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 2,960 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: Redgate | Category: sql in the city
Rating: (not yet rated)  Rate this |   Briefcase | 3,689 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,730 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: Redgate | Category: sql in the city
Rating: (not yet rated)  Rate this |   Briefcase | 3,775 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 | 6,350 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,965 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 | 427 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,813 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 | 15,557 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,945 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: Redgate | Category: events
Rating: (not yet rated) |  Discuss |   Briefcase | 368 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 | 3,201 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 | 20,964 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: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 2,859 reads

Five Rules For Successful Conversations With DBAs

As a developer working with SQL Server, you'll need to work with DBAs at one point or another. Here are some easy ways to make those conversations go smoothly.  Read more...
By Joshua Feierman 2015/04/10 (first published: 2013/09/24) | Source: SQLServerCentral.com | Category: dba
Rating: |  Discuss |   Briefcase | 18,015 reads

Manage SQL Server Reporting Services in Management Studio

Most maintenance for SSRS is performed either in Report Manager online or within the Report Services Configuration Manager from the desktop. The SSRS Management Studio connection is certainly no replacement for either of these tools, however, several benefits can be obtained using SSMS. First, you are able to connect to the SSRS even if you are having browser issues; second, it is often quicker to just switch from using Management Studio for the Database Engine.  Read more...
By Additional Articles 2013/09/24 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating:  Rate this |   Briefcase | 4,643 reads