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 2012/11/12 to 2012/11/19

SQL Saturday #179 - Kharkov, Ukraine

SQL Saturday in the Ukraine. If you want a free day of training, sign up and attend.  Read more...
By Press Release 2012/11/19 | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 1,490 reads

Create SQL Server Analysis Services Partitions using AMO

When you have SSAS cubes with millions of rows of data, it is very helpful to create partitions. If you have a few cubes you could probably do this manually, but if there are many or if you want to automate this process you should look for smarter solutions such as programming the creation of partitions dynamically.   Read more...
By Additional Articles 2012/11/19 | Source: MSSQLTips.com | Category: analysis services (ssas)
Rating:  Rate this |   Briefcase | 1,907 reads

5 Reasons You Must Start Capturing Baseline Data

It is widely acknowledged within the SQL Server community that baselines represent valuable information that DBAs should capture. Unfortunately, very few companies manage to log and report on this information, and DBAs are then forced to troubleshoot from the hip and scramble to find evidence to prove that the database is not the problem. This article will make a compelling argument for why DBAs must start capturing baseline information, and will create a roadmap for subsequent posts.  Read more...
By Erin Stellato 2012/11/19 | Source: SQLServerCentral.com | Category: baselines
Rating: |  Discuss |   Briefcase | 9,596 reads

SQL Saturday #168 - Tampa BI Edition

A free day of SQL Server Business Intelligence sessions in Tampa, FL tomorrow.  Read more...
By Press Release 2012/11/16 | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 1,416 reads

Day 7 of The OLAP Sprint

The final day of Simon's journey to improve his OLAP knowledge and build a prototype cube.  Read more...
By Simon E Doubt 2012/11/16 | Source: SQLServerCentral.com | Category: olap
Rating: (not yet rated) |  Discuss |   Briefcase | 968 reads

SQL Server 2012 AlwaysOn: Multisite Failover Cluster Instance

SQL Server Failover Clustering, which includes support for both local and multisite failover configurations, is part of the SQL Server 2012 AlwaysOn implementation suite, designed to provide high availability and disaster recovery for SQL Server. The multisite failover clustering technology has been enhanced significantly in SQL Server 2012. The multisite failover cluster architecture, enhancements in SQL Server 2012 to the technology, and some best practices to help with deployment of the technology are the primary focus of this paper.  Read more...
By Additional Articles 2012/11/16 | Source: Microsoft MSDN | Category: sql server 2012
Rating: (not yet rated)  Rate this |   Briefcase | 2,048 reads

Generating SubTotals using GROUPING

This article explains how to use the GROUPING clause to generate subtotals for rows in a very easy fashion.  Read more...
By Sunil Chandurkar 2012/11/16 (first published: 2010/07/13) | Source: SQLServerCentral.com | Category: groouping
Rating: |  Discuss |   Briefcase | 26,526 reads

Day 6 of The OLAP Sprint

Day 6 brings security enhancements.  Read more...
By Simon E Doubt 2012/11/15 | Source: SQLServerCentral.com | Category: olap
Rating: (not yet rated) |  Discuss |   Briefcase | 809 reads

Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations

In this sequel to his first "Hierarchies on Steroids" article, SQL Server MVP Jeff Moden shows us how to build a pre-aggregated table that will answer most of the questions that you could ask of a typical hierarchy. Any bets on whether Santa is packin’ a Tally Table in his bag or not?  Read more...
By Jeff Moden 2012/11/15 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,198 reads

FileStream and FileTable in SQL Server 2012

SQL Server 2012 enhanced the SQL Server 2008 FileStream data type by introducing FileTable, which lets an application integrate its storage and data management components to allow non-transactional access, and provide integrated SQL Server services. Arshad Ali explains how.  Read more...
By Additional Articles 2012/11/15 | Source: Database Journal | Category: filestream
Rating: (not yet rated)  Rate this |   Briefcase | 2,462 reads

Prevent Truncation of Dynamically Generated Results in SQL Server Management Studio

While working with the Results to Text option in SSMS, you may come across a situation where the output from dynamically generated data is truncated. In this article I will guide you on how to fix this issue and print all the text for the Results to Text option.   Read more...
By Additional Articles 2012/11/14 | Source: MSSQLTips.com | Category: management studio (ssms)
Rating: (not yet rated)  Rate this |   Briefcase | 2,219 reads

Day 5 of The OLAP Sprint

Day 5, the first real day of the Summit. Amir Netz' session and a little cube work.  Read more...
By Simon E Doubt 2012/11/14 | Source: SQLServerCentral.com | Category: olap
Rating: (not yet rated) |  Discuss |   Briefcase | 943 reads

Stairway to SQL Dialects Level 2: Postgres

Level 2 of this stairway explains how to convert data declaration language (DDL) statements and data manipulation language (DML) statements from Postgres to Microsoft SQL Server.  Read more...
By Joe Celko 2012/11/14 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,638 reads

Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

SQL Server MVP Jeff Moden shows us a new very high performance method to convert an "Adjacency List" to “Nested Sets” on a million node hierarchy in less than a minute and 100,000 nodes in just seconds. Not surprisingly, the "steroids" come in a bottle labeled "Tally Table".  Read more...
By Jeff Moden 2012/11/13 | Source: SQLServerCentral.com | Category: hierarchy
Rating: |  Discuss |   Briefcase | 9,701 reads

Day 4 of The OLAP Sprint

Day 4 is the halfway point. Another pre-con, this one from Peter Myers that looks at Power View and Matrix reports.  Read more...
By Simon E Doubt 2012/11/13 | Source: SQLServerCentral.com | Category: olap
Rating: (not yet rated) |  Discuss |   Briefcase | 1,079 reads

Designing Databases for Rapid Resilience

As the volume of data increases, DBAs need to plan more actively for rapid restores in the event of failure. For this, the intelligent use of filegroups is important, particularly when the Enterprise Edition of SQL Server offers the hope of online restores. How, though, should you arrange your data on the different filegroups? What happenens if the primary filegroup gets corrupted? Why backup and restore indexes?  Read more...
By Additional Articles 2012/11/13 | Source: SimpleTalk | Category: resilience
Rating:  Rate this |   Briefcase | 2,225 reads

Viewing VMware Counters in PerfMon for SQL Server

I want to ensure that my SQL Server on a VMware Guest OS is getting the resources it should. This would go a long way towards helping isolate the performance problems we're experiencing. However, our system administrators won't give us access to VirtualCenter or any of the tools they use. Is there anything I can do? Check out this tip to learn more.  Read more...
By Additional Articles 2012/11/12 | Source: MSSQLTips.com | Category: performance tuning
Rating: (not yet rated)  Rate this |   Briefcase | 2,428 reads

SQL Server 2012 Build List

A list of the builds of SQL Server 2012 through CU#9 for SP1.  Read more...
By Steve Jones 2013/04/18 (first published: 2012/04/17) | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 10,961 reads

Day 3 of The OLAP Sprint

Day 3 was a pre-con on Business Intelligence.  Read more...
By Simon E Doubt 2012/11/12 | Source: SQLServerCentral.com | Category: olap
Rating: (not yet rated) |  Discuss |   Briefcase | 1,530 reads

Data Mining Introduction

Many people that work for years with SQL Server never use the Data Mining. This article has the objective to introduce them to this magic and exciting new world.  Read more...
By Daniel Calbimonte 2012/11/12 | Source: SQLServerCentral.com | Category: server
Rating: |  Discuss |   Briefcase | 25,324 reads