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 14028    Older >>


This week Steve Jones wants to know about your efforts to create bonds with co-workers and build a team. Does your company do anything to help facilitate this?  Read more...
By Steve Jones 2015/08/07 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 101 reads

Introduction to SQL Server 2016 Temporal Tables

Temporal tables - also known as system-versioned tables, but not to be mistaken with temporary tables - are a new feature of SQL Server 2016 that allow SQL Server to automatically keep a history of the data in the table. This tip from Koen Verbeeck introduces the new feature by explaining how to create a system-versioned table.  Read more...
By Additional Articles 2015/08/07 | Source: | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 4,195 reads

Hadoop For SQL Folks: Architecture, MapReduce and Powering IoT

As the de-facto big data processing and analytics engine, the Hadoop ecosystem is also leading the way in powering Internet of Things (IOT)  Read more...
By Frank A. Banin 2015/08/06 | Source: | Category: hadoop
Rating: |  Discuss |   Briefcase | 6,894 reads

Product Review: GenesisOne T-SQL Source Code Unscrambler

MVP Jody Roberts reviews GenesisOne T-SQL Source Code Unscrambler, a tool that aims to clarify code and server environments with simple diagrams and plain English.  Read more...
By Jody Roberts 2015/08/06 | Source: | Category: review
Rating: |  Discuss |   Briefcase | 1,537 reads

Amateur Data Analysis

Learn how you can display information based on data to improve your career.   Read more...
By Steve Jones 2015/08/06 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 203 reads

Byte Me: Model Employee

Pose the question. 
By Bob Lang 2015/08/05 | Source: | Category: byte me
Rating: |  Discuss |   Briefcase | 353 reads

Stairway to Columnstore Indexes Level 4: Catalog Views

In this level, we will first take a look at how to recognize columnstore indexes in some of the generic catalog views. After that we will investigate the new catalog views that have been added just for columnstore indexes.  Read more...
By Hugo Kornelis 2015/08/05 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,957 reads

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...
By Press Release 2015/08/05 (first published: 2013/08/07) | Source: Redgate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 62,916 reads

Microsoft and Database Lifecycle Management (DLM): The DacPac

The Data-Tier Application Package (DacPac), together with the Data-Tier Application Framework (DacFx), provides an alternative way to automate the process of scripting out, or deploying a SQL Server database, reporting on changes, or checking version-drift. As such, it seems to provide an obvious cost-free start for tackling automated Database Delivery as part of Database Lifecycle Management (DLM). We asked Phil Factor if it is ready for Prime-time.  Read more...
Rating:  Rate this |   Briefcase | 4,183 reads

Cloud Security Issues

The cloud is always going to be a challenge for security, but is it harder or easier than on premises? Steve Jones has a few comments.  Read more...
By Steve Jones 2015/08/04 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 118 reads

Display SSIS package version on the Control Flow design surface

In this article I will show a simple trick to display version information on the Control Flow surface, so we immediately see which version and build we are modifying.  Read more...
Rating: |  Discuss |   Briefcase | 2,948 reads

Running SQL Server with Hyper-V Dynamic Memory - Best Practices and Considerations

There are unique considerations that apply to virtual machines that run SQL Server workloads in such environments. This document provides insight into considerations and best practices for running SQL Server in Hyper-V Dynamic Memory configurations on Windows Server.  Read more...
By Additional Articles 2015/08/04 | Source: Microsoft MSDN | Category: hyper-v
Rating: (not yet rated)  Rate this |   Briefcase | 3,054 reads

Do It Yourself Load Balancing with SSIS

This article takes a simple look at loading data in parallel from a single data source, be it a flat file of a database  Read more...
By Adam Aspin 2015/08/03 | Source: | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 4,920 reads

Learning Columnstore Indexes

References and links to learn more about columnstore indexes.  Read more...
By Site Owners 2015/08/03 | Source: | Category: columnstore index
Rating: (not yet rated) |  Discuss |   Briefcase | 2,301 reads

Be Professional

Today Steve Jones talks about the impressions we make as career minded individuals.  Read more...
By Steve Jones 2015/08/03 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 200 reads

Change operating modes for SQL Server Database Mirroring

SQL Server Database Mirroring offers two methods for exchanging data: synchronously and asynchronously. Sometimes there may be a need to switch between modes for an existing mirror and in this tip we will look at how this can be done.  Read more...
By Additional Articles 2015/08/03 | Source: | Category: database mirroring
Rating: (not yet rated)  Rate this |   Briefcase | 2,887 reads

But we've always done it that way…

Inspired by his visit to the battlefield of Waterloo, Grant Fritchey explains the dangers of doing things the way you've always done them and the need to challenge constantly your beliefs and understanding of how the technology you manage works.  Read more...
By Grant Fritchey 2015/08/03 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 102 reads

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: | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 14,432 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: | Category: editorial
Rating: |  Discuss |   Briefcase | 292 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: | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 2,219 reads
<< Newer    Items 61 to 80 of 14028    Older >>