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

Configuring Critical SQL Server Alerts

What do you do when you want to receive critical server health alerts?  Read more...
By Additional Articles 2014/11/13 | Source: MSSQLTips.com | Category: alerting
Rating:  Rate this |   Briefcase | 7,352 reads

Double Up During Trips

When you develop software, it pays to write efficient code. However it doesn't seem that many companies truly believe this as they aren't always investing in their staff.  Read more...
By Steve Jones 2014/11/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 135 reads

What is Biml? - Level 1

An introduction to the Biml language from Andy Leonard that helps  Read more...
By Andy Leonard 2014/11/12 (first published: 2013/07/17) | Source: SQLServerCentral.com | Category: biml
Rating: |  Discuss |   Briefcase | 29,680 reads

Database Configuration Management for SQL Server

It is not just the rapid and painless testing, deployment and update of databases that requires care in the retention and management of configuration information. Configuration information is also essential for audit, resilience, and support. The range of documentation varies widely with the database and its setting, but the underlying principles remain the same. Without appropriate configuration management, automation is likely to be futile.  Read more...
By Additional Articles 2014/11/12 | Source: SimpleTalk | Category: configuration files
Rating:  Rate this |   Briefcase | 8,975 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Red Gate's SQL Backup tool.  Read more...
By Press Release 2014/11/12 (first published: 2014/03/05) | Source: Red-Gate | Category: ebook
Rating: (not yet rated)  Rate this |   Briefcase | 24,153 reads

SQL Server Internals: In-Memory OLTP

In this book, Kalen Delaney explains how the new In-Memory OLTP engine works, how it stores and manipulates data, and how, even with all data stored in memory and no locking or latching, it can still guarantee the ACID properties of all transactions.  Read more...
By Kalen Delaney 2014/11/11 | Source: SQLServerCentral.com | Category: books
Rating: (not yet rated) |  Discuss |   Briefcase | 173 reads

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: SQLServerCentral.com | Category: books
Rating: (not yet rated) |  Discuss |   Briefcase | 79 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: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 111 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: SQLServerCentral.com | Category: excel
Rating: |  Discuss |   Briefcase | 2,877 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: MSSQLTips.com | Category: memory quota
Rating: (not yet rated)  Rate this |   Briefcase | 6,638 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: SQLServerCentral.com | Category: events
Rating:  Rate this |   Briefcase | 6,112 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: SQLServerCentral.com | Category: formatting
Rating: |  Discuss |   Briefcase | 6,837 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: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 102 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,768 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: SQLServerCentral.com | 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: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 8,639 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: SQLServerCentral.com | 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,528 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: SQLServerCentral.com | Category: database mirroring
Rating: |  Discuss |   Briefcase | 3,236 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: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 98 reads
<< Newer    Items 41 to 60 of 13263    Older >>