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

SQL Server Source Control Basics

Source control can and should play a key role in the database development and deployment process, and this book will show you exactly how to get started.  Read more...
By Tony Davis, Rob Sheldon 2014/11/11 | Source: | Category: books
Rating: (not yet rated) |  Discuss |   Briefcase | 71 reads

Connection Issues

The lack of a network caused a number of problems recently for Steve Jones.  Read more...
By Steve Jones 2014/11/11 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 109 reads

Data Mining Part 20: Excel and Data Mining,accuracy, forecasting

In the lesson 18 and 19 we worked with Data Mining Models. In this new chapter we will work with more algorithms and show how to test the accuracy of the model.  Read more...
By Daniel Calbimonte 2014/11/11 | Source: | Category: excel
Rating: |  Discuss |   Briefcase | 2,833 reads

Set up a Memory Quota for SQL Server Memory Optimized Databases

You successfully entered into the In-Memory OLTP world by the hand of SQL Server 2014. After a while you notice that the In-Memory objects are using more memory than you estimated. In this tip you will learn how to proceed.  Read more...
By Additional Articles 2014/11/11 | Source: | Category: memory quota
Rating: (not yet rated)  Rate this |   Briefcase | 6,580 reads

SQL Server Luxembourg: Wait Watchers

On November 19, 2014, the SQL Server Luxembourg User Group and Dell Software will be hosting a free event. Richard Douglas will be be presenting a double bill: SQL Server 2014 features everyone can use, and Wait watchers - Gain Performance Increases Fast! This event is free to registered attendees.  Read more...
By Press Release 2014/11/11 | Source: | Category: events
Rating:  Rate this |   Briefcase | 6,076 reads

Using Comments to Quickly Test CTEs

A quick tip for using a combination of block and line comments to test CTEs   Read more...
By Carl P. Anderson 2014/11/10 | Source: | Category: formatting
Rating: |  Discuss |   Briefcase | 6,799 reads

Acceptance Testing with FitNesse: Database Fixtures, Project Overview

There aren't many frameworks for writing acceptance tests for databases, including SQL Server. FitNesse is an obvious choice since it is designed with a Wiki-style interface that, once it is configured and set up correctly, makes it very easy for a non-specialist to set up individual tests.  Read more...
By Additional Articles 2014/11/10 | Source: SimpleTalk | Category: testing
Rating:  Rate this |   Briefcase | 4,700 reads

An Unlikely Taste for Documentation and Archiving

So, in general, what information (Scripts, configuration information, lists and documents) ought DBAs to retain about the databases and servers they are responsible for?  Read more...
By Phil Factor 2014/11/10 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 98 reads

Pay It Forward

Steve Jones looks at the dilemma of training developers and having them leave, or maybe, just having them stay untrained.  Read more...
By Steve Jones 2014/11/10 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 167 reads

ETL Performance Auditing - Part 2: Auditing Data Staging Phase

Easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.  Read more...
By Frank A. Banin 2014/11/07 (first published: 2012/06/12) | Source: | Category: performance tuning
Rating: |  Discuss |   Briefcase | 8,598 reads

The 2014 PASS Summit - Thursday

Steve Jones looks at some of the events from Day 2.  Read more...
By Steve Jones 2014/11/07 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 67 reads

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,501 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,212 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 | 98 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,720 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 | 8,037 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,210 reads

Byte Me: Chilling Memories

Your definition of treat may vary. 
By Bob Lang 2014/11/05 | Source: | Category: byte me
Rating: |  Discuss |   Briefcase | 286 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,694 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,244 reads
<< Newer    Items 41 to 60 of 13257    Older >>