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

<< Newer    Items 41 to 60 of 13247    Older >>

Backup and Restore Strategies in SQL Server ā€“ Part 2

In this article of the series Arshad Ali discusses different types of restore processes and backup and restore scenarios.  Read more...
By Additional Articles 2014/11/07 | Source: Database Journal | Category: backup / restore
Rating: (not yet rated)  Rate this |   Briefcase | 9,179 reads

Is Database Mirroring Causing The Transaction Log To Fill Up

In this article, I describe some steps a DBA can take to check for mirroring on SQL Server, give a status of the mirroring state and some options for resolving any problems with the transaction log that might be caused by Database Mirroring.  Read more...
By C.J. Garcia 2014/11/06 | Source: | Category: database mirroring
Rating: |  Discuss |   Briefcase | 3,176 reads

The 2014 PASS Summit Report - Day 1

A few highlights from the first full day of the Summit.  Read more...
By Steve Jones 2014/11/06 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 95 reads

Free SQL in the City Seminar Washington DC ā€“ Dec 5, 2014

SQL Server MVP Grant Fritchey and Steve Jones will present the Stairway to Continuous Delivery in Washington DC again this December. Learn how to build an efficient development and deployment process for your organization. Register for this free event.   Read more...
By Press Release 2014/11/06 | Source: Red-Gate | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 5,565 reads

Stop Relying on Cloud File Stores as a Backup Strategy

There is a growing assumption that Cloud file-storage services represent an ideal way of backing up files. It seems a compelling idea because it is so easy and seems secure. The truth is, as always, more complicated. There is more to any backup strategy than just cloud storage.  Read more...
By Additional Articles 2014/11/06 | Source: SimpleTalk | Category: backup
Rating:  Rate this |   Briefcase | 7,804 reads

Stairway to SQL Server Indexes: Level 1, Introduction to Indexes

Indexes are the database objects that enable SQL Server to satisfy each data access request from a client application with the minimum amount of effort, resulting in the maximum performance of individual requests while also reducing the impact of one request upon another. Prerequisites: Familiarity with the following relational database concepts: Table, row, primary key, foreign key  Read more...
By David Durant 2014/11/05 (first published: 2011/02/17) | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 50,012 reads

Byte Me: Chilling Memories

Your definition of treat may vary. 
By Bob Lang 2014/11/05 | Source: | Category: byte me
Rating: |  Discuss |   Briefcase | 280 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 2014/11/05 (first published: 2014/02/26) | Source: Red-Gate | Category: replication
Rating:  Rate this |   Briefcase | 23,628 reads

SQL Server Database Development Career Questions

Tim Smith covers some starting points for people interested in becoming a SQL Server database developer or interested in SQL Server database development.  Read more...
By 2014/11/05 | Source: | Category: career
Rating:  Rate this |   Briefcase | 7,178 reads

SSRS - Report for Stored Procedure with Parameters

You receive a request from an analyst for a report to be built from a procedure they wrote. It will require parameters based on values currently in the database and ones that allow free-typing. This article will provide a basic walk-through on handling this type of request.  Read more...
By Shawn Melton 2014/11/04 | Source: | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 6,390 reads

Summit 2014

The PASS Summit is this week in Seattle, and Steve Jones has a few thoughts.  Read more...
By Steve Jones 2014/11/04 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 85 reads

Getting Data Into and Out of PowerShell Objects

You can execute PowerShell code that creates the data of an object, but there is no cmdlet to generate the 'object notation' code from an existing PowerShell object; until now, that is. Phil Factor also produces a ConvertTo-YAML function and explains how they both work, with illustrative code.  Read more...
By Additional Articles 2014/11/04 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 7,896 reads

A Fundamental Security Mistake

Steve Jones thinks Microsoft is making a fundamental security mistake in the way they build features for the various editions of SQL Server. Read today's editorial and see if you agree.  Read more...
By Steve Jones 2014/11/03 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 375 reads

Data Science for SQL Folks: Leveraging SQL and R

Learn about how to build value driven analytics with SQL Server and R.   Read more...
By Frank A. Banin 2014/11/03 | Source: | Category: sql and r
Rating: |  Discuss |   Briefcase | 6,947 reads

Normalizing Performance

Determining the best performance value you can get for your effort is not as straightforward as you might think.  Read more...
By Steve Jones 2014/11/03 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 148 reads

Red Gate Software to unveil Database Lifecycle Management at PASS Summit

PASS attendees will get the chance to learn about Database Lifecycle Management (DLM) straight from its chief proponent: Red Gate Software, the database and .NET tooling company.  Read more...
By Press Release 2014/11/03 | Source: Red-Gate | Category: dlm
Rating: |  Discuss |   Briefcase | 145 reads

Format Durations in SQL Server Analysis Services

I have a fact table in my data warehouse that tracks durations of certain events as the total number of seconds that have passed. When users browse the cube, Iā€™d like to show these durations formatted as time using the hh:mm:ss format. How can I do this in Analysis Services (SSAS)? - Koen Verbeeck responds.  Read more...
By Additional Articles 2014/11/03 | Source: | Category: analysis services (ssas)
Rating:  Rate this |   Briefcase | 5,632 reads

ETL Performance Auditing - Part 1: Introduction to ETL Auditing

This article shows an easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.  Read more...
By Frank A. Banin 2014/10/31 (first published: 2012/06/05) | Source: | Category: etl performance
Rating: |  Discuss |   Briefcase | 15,827 reads

The Data Center that Exploded

A while back, in a Simple-Talk editorial meeting, someone bet Phil Factor that he couldn't come up with a Halloween story. To our surprise he said he could, as long as he didn't have to keep to the strict literal truth. In the end, he came up with a story about a story, and it is true that he first told the story in a data Centre at Halloween!  Read more...
By Additional Articles 2014/10/31 | Source: SimpleTalk | Category: fun
Rating:  Rate this |   Briefcase | 8,744 reads

The Geek Costume

This Friday Steve Jones has another fun poll. A question on the geek costume that might excite you the most.  Read more...
By Steve Jones 2014/10/31 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 96 reads
<< Newer    Items 41 to 60 of 13247    Older >>