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

   Items 1 to 20 of 13951    Older >>
 

Dynamic Grouping in SSRS Reports

This article shows how you can create a dynamic report in SQL Server Reporting Services (SSRS), walking you through the steps needed to create a dynamically-grouped report.  Read more...
By Andy Owl 2015/07/31 (first published: 2012/10/11) | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 12,895 reads

How To Keep Up with SQL Server

It can be a challenge to keep up with the rapidly evolving SQL Server platform. Andy Warren has a few ideas today.   Read more...
By Andy Warren 2015/07/31 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 97 reads

Call for Speakers - SQL Saturday Pittsburgh

SQL Saturday #440 is coming to Pittsburgh on October 3, 2015. Now is the time to submit if you'd like to speak at the event.  Read more...
By Press Release 2015/07/31 | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 1,031 reads

SQL 2014 Clustered Columnstore Index Rebuild and Maintenance Considerations

Building (or rebuilding) a Columnstore index can be a resource intensive operation. In this article, Denzil Ribeiro describes the index rebuild process and index maintenance for clustered Columnstore indexes in SQL 2014.  Read more...
By Additional Articles 2015/07/31 | Source: SQLCAT | Category: clustered columnstore index
Rating: (not yet rated)  Rate this |   Briefcase | 1,375 reads

Detecting Differences in Files on Servers

Detecting file differences on two different web servers using T-SQL.  Read more...
By Ed Wagner 2015/07/30 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,386 reads

The Security Payoff

An invitation to hack United's IT systems has resulted in vulnerabilities being found and hackers rewarded for disclosing the issues.  Read more...
By Steve Jones 2015/07/30 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 56 reads

Download tSQLt Today and Start Unit Testing

The latest version of tSQLt is now available with some SQL Prompt snippets to help you get started.  Read more...
By Press Release 2015/07/30 | Source: SQLServerCentral.com | Category: tsqlt
Rating: (not yet rated) |  Discuss |   Briefcase | 1,332 reads

SQL Server Archive and Data Retention Considerations

Tim Smith looks at what to take into consideration before building a design to archive old data in SQL Server databases.  Read more...
By Additional Articles 2015/07/30 | Source: MSSQLTips.com | Category: data retention
Rating: (not yet rated)  Rate this |   Briefcase | 1,599 reads

Stairway to SQL Server Security Level 10: Row-Level Security

Unlike some other industrial-strength database servers, SQL Server lacks a built-in mechanism for protecting individual data records, called row-level security. This stairway level explores why you might want to use such a low-level granularity of data access security and how you can implement row-level security.  Read more...
By Don Kiely 2015/07/29 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,491 reads

Hiring for Culture

Steve Jones discusses the decision to hire someone that fits in with your culture at work, and what that means.  Read more...
By Steve Jones 2015/07/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 99 reads

Free eBook: SQL Server Hardware

SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.  Read more...
By Press Release 2015/07/29 (first published: 2013/07/24) | Source: Redgate | Category: hardware
Rating:  Rate this |   Briefcase | 47,892 reads

Demystifying Oracle's Clustering Factor

One of the more confusing statistics in Oracle is one called the clustering factor. Associated with an index, it's actually dependent on the table data, more specifically the distance between 'jumps' for a given index key. Commonly, a 'jump' is the number of blocks between rows containing the given index key starting with the first block found containing that key. If that sounds confusing don't despair, David Fitzjarrell explains in detail.   Read more...
By Additional Articles 2015/07/29 | Source: Database Journal
Rating: (not yet rated)  Rate this |   Briefcase | 2,511 reads

Visualize the timeline of your SQL jobs using Google graph and email

Generate an HTML page with the timeline of your SQL jobs using Google graph and sp_send_dbmail  Read more...
By Theo Ekelmans 2015/07/28 | Source: SQLServerCentral.com | Category: jobs
Rating: |  Discuss |   Briefcase | 6,903 reads

The Importance of Maintenance on MSDB

MSDB is a system database used by SQL Server. MSDB stores all sorts of data, such as backup history, log shipping monitor history, SSIS packages and Service Broker queue data to name a few. Just like user databases, MSDB needs regular maintenance, including index optimizations and, more importantly, regular purging. In this article, Tim Radney looks at how neglecting your MSDB can negatively impact on your environment.   Read more...
By Additional Articles 2015/07/28 | Source: SQLPerformance.com | Category: msdb
Rating:  Rate this |   Briefcase | 5,070 reads

Visualizing in Space

An amazing visualization of basketball players has Steve Jones encouraging you to find your own pet project and showcase some skills.   Read more...
By Steve Jones 2015/07/28 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 83 reads

Introducing the Set-based Loop

Set-based programming doesn’t mean “no loops” or a single statement. Finding out the best ways to traverse a full hierarchy.  Read more...
By Luis Cazares 2015/07/27 | Source: SQLServerCentral.com | Category: set-based loop
Rating: |  Discuss |   Briefcase | 10,929 reads

Learning Backup to Azure

References and links to get you started in backing up your database to the Azure blob storage.  Read more...
By Site Owners 2015/07/27 | Source: SQLServerCentral.com | Category: backup to azure
Rating: (not yet rated) |  Discuss |   Briefcase | 601 reads

What We Want and What We'll Pay For

The challenges of getting enough resources for our projects aren't always apparent.  Read more...
By Steve Jones 2015/07/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 110 reads

No Downtime Deployments

Can you deploy your database changes without any downtime? Steve Jones has a few notes.  Read more...
By Steve Jones 2015/07/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 73 reads

Can Code Review Be Automated?

Code must be checked, but how? Phil Factor shares his thoughts on automating SQL code reviews.  Read more...
By Additional Articles 2015/07/27 | Source: SimpleTalk | Category: code review
Rating: (not yet rated)  Rate this |   Briefcase | 4,067 reads
   Items 1 to 20 of 13951    Older >>