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/30 to 2013/10/07

SQLServerCentral Changes - Oct 2013

We've made a few changes to the site, and we want you to check them out.  Read more...
By Press Release 2013/10/07 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 1,269 reads

How to implement SHA-2 in SQL Server 2005 or 2008 with a CLR assembly

SQL Server 2012 supports SHA-256 and SHA-512 through the HASHBYTES() function, but earlier versions of SQL Server do not. SHA-256, SHA-384 and SHA-512 can, however, be implemented in SQL Server 2005 or SQL Server 2008 with the CLR assembly described in this article.  Read more...
By Stan Kulp 2013/10/07 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 3,516 reads

DAX Statistical Functions

Following on from his first four articles on using Data Analysis Expressions (DAX) with tabular databases, Robert Sheldon dives into some of the DAX statistical functions available, demonstrating which are the most useful and examples of how they work.  Read more...
By Additional Articles 2013/10/07 | Source: SimpleTalk | Category: dax
Rating:  Rate this |   Briefcase | 2,354 reads

SQL Saturday #227 - Charleston

SQL Saturday is coming to Charleston, SC on October 12, 2013. SQL Saturday is a free training event for SQL Server professionals and those wanting to learn about SQL Server. Don't miss Charleston's first SQL Saturday.  Read more...
By Press Release 2013/10/04 | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 2,133 reads

RD Licensing Configuration on Windows Server 2012

The Microsoft Performance Team discusses the steps in installing/configuring Windows Server 2012 Remote Desktop Services Licensing in your environment using various available options.  Read more...
By Additional Articles 2013/10/04 | Source: Microsoft MSDN | Category: licensing
Rating: (not yet rated)  Rate this |   Briefcase | 2,437 reads

Group Islands of Contiguous Dates (SQL Spackle)

Fill in another bit of your T-SQL knowledge by learning how to quickly group ranges of contiguous dates without RBAR.  Read more...
By Jeff Moden 2013/10/04 (first published: 2010/12/07) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 14,887 reads

Replication: Distribution Agent Monitoring

Learn about the distribution agent and how to identify replication bottlenecks.  Read more...
By Brian Wilson 2013/10/03 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 2,984 reads

Lab Ops 2–The Lee-Robinson Script

Marcus Robinson adapted PowerShell scripts by Thomas Lee to build a set of VMs to run a course in a reliable and repeatable way. With Marcus’s permission, Andrew Fryer has put that Setup Script on SkyDrive, and provided notes on the script.  Read more...
By Additional Articles 2013/10/03 | Source: Microsoft MSDN | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,383 reads

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,578 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,100 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,647 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,508 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