Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

<< Newer    Items 61 to 80 of 13433    Older >>
 

Archiving Hierarchical, Deleted Transaction Using XML

When you delete a business transaction from the database, there are times when you might want to keep a record of the data for posterity. In this article, Dwain Camps looks at a tidy means of doing just that.  Read more...
By Additional Articles 2015/01/08 | Source: SimpleTalk | Category: xml
Rating: (not yet rated)  Rate this |   Briefcase | 10,874 reads

Stairway to PowerPivot and DAX - Level 8: Function / Iterator Function Pairs: The DAX COUNT() and COUNTX() Functions

As a part of his “Function / Iterator Pairs” mini-series, Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX COUNT() and COUNTX() functions, discussing similarities and differences. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in generating counts to meet differing needs within our PowerPivot model designs.  Read more...
By Bill Pearson 2015/01/07 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,821 reads

Test Your Situation

One of the important things is to be able to recover your environment. That doesn't mean you need to know everything about SQL Server and potential disasters, but you should know their affect on your situation.  Read more...
By Steve Jones 2015/01/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 98 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2015/01/07 (first published: 2014/02/26) | Source: Red-Gate | Category: replication
Rating:  Rate this |   Briefcase | 31,077 reads

Importance of Statistics and How It Works in SQL Server – Part 1

SQL Server Query Optimizer uses statistical information to estimate the cardinality in a query result. This enables the SQL Server Query Optimizer to create a high-quality query execution plan. Read on to learn how to use statistics and why it’s needed.  Read more...
By Additional Articles 2015/01/07 | Source: Database Journal | Category: query optimizer
Rating:  Rate this |   Briefcase | 7,053 reads

Scrubbing Personally Identifiable Information

Managing personally identifiable information when moving databases to unsecure environment can be challenging. With this flexible and extendable solution for scrubbing it, you can save yourself some time and effort.  Read more...
By Daniel Brown 2015/01/06 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 6,523 reads

Recovering from Bad Deployments

When you deploy software, what do you do if things don't go well? Steve Jones talks about a few options you might have.  Read more...
By Steve Jones 2015/01/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 109 reads

Add a linear trendline to a graph in SQL Server Reporting Services

In this article, Koen Verbeeck illustrates how to add a linear trendline to a graph in SSRS, similar to the way it would appear if done Excel.  Read more...
By Additional Articles 2015/01/06 | Source: MSSQLTips.com | Category: ssrs
Rating:  Rate this |   Briefcase | 6,630 reads

SQL Monitor Custom Metric: Identity Columns Near Limit

If your application relies on identity columns, this metric is a useful measure of the number of identity columns that are near to the limit per database. You can then avoid logical problems in your application and SQL Server errors.  Read more...
By Press Release 2015/01/06 | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 5,713 reads

Adding an Article Without a Full Snapshot

Have you got transactional replication in your SQL environment? Do you need to add a new table to your publication, but can't afford the time necessary to create a full new snapshot? Here is a step-by-step guide. Thankfully, adding a single table is easier than I thought.  Read more...
By Nick Burns 2015/01/05 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 2,716 reads

Staying Successful

What helps people be successful in a company? Perhaps a little analytic work can help employers determine this.  Read more...
By Steve Jones 2015/01/05 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 189 reads

Salesforce: A Very Straightforward Cloud Development Platform

Force.com is an enigma; a Platform-as-a-Service that is designed to appeal to a broad church of developers, to make it quick and easy to write simple cloud-based applications. Robert Sheldon explains, as simply as possible, why this unusual data-centric, and metadata-driven platform is attracting so much interest in the industry.  Read more...
By Additional Articles 2015/01/05 | Source: SimpleTalk | Category: salesforce
Rating: (not yet rated)  Rate this |   Briefcase | 6,382 reads

DBA of the World

Conference travel enhances our minds with more than just SQL. It exposes us to new cultures, people and possibilities.  Read more...
By Rodney Landrum 2015/01/05 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 81 reads

Creating a heat map in Reporting Services

Use custom assemblies to generate a heat map matrix in SQL Server Reporting Services  Read more...
By Andy Owl 2015/01/02 (first published: 2012/08/30) | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 15,320 reads

What's Coming True?

Steve Jones looks forward to the new year and asks in this poll what you think will happen.  Read more...
By Steve Jones 2015/01/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 124 reads

High Availability and Disaster Recovery for Small Businesses

Too often in the past, High Availability and Disaster Recovery have been marketed as expensive choices for businesses with deep pockets. The truth is that, with careful planning, there are sensible and economic solutions for small businesses that can maintain business continuity when disaster strikes.  Read more...
By Additional Articles 2015/01/02 | Source: SimpleTalk | Category: high availability (ha)
Rating: (not yet rated)  Rate this |   Briefcase | 8,589 reads

Growing Your SQL Server Skills without Breaking the Bank

Learning more about SQL Server doesn't have to cost a small fortune. If you're willing to invest the time, you can learn.   Read more...
By Mike Hillwig 2015/01/02 (first published: 2013/08/05) | Source: SQLServerCentral.com | Category: learning
Rating: |  Discuss |   Briefcase | 13,788 reads

A Beginners Look at Hadoop

Hadoop has been making a lot of noise in the Big Data world. Despite my lack of Linux experience I decided to take the plunge and this is what I found.  Read more...
By David Poole 2015/01/01 (first published: 2013/06/05) | Source: SQLServerCentral.com | Category: hadoop
Rating: |  Discuss |   Briefcase | 20,881 reads

Byte Me: Out With the Old

A scheduled task.  Read more...
By Bob Lang 2015/01/01 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 295 reads

Getting Started with HDInsight - Part 3 - Creating an HDInsight Cluster in Microsoft Azure Cloud

In this tip we will look at two different ways of creating an HDInsight Cluster: Creating an HDInsight Cluster through Azure Management Portal, and creating an HDInsight Cluster through Windows Azure PowerShell.  Read more...
By Additional Articles 2015/01/01 | Source: MSSQLTips.com | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 5,323 reads
<< Newer    Items 61 to 80 of 13433    Older >>