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

<< Newer    Items 21 to 40 of 13247    Older >>
 

Practical PowerShell Unit-Testing: Getting Started

If you're using PowerShell for automation, you'll probably need to automate the unit-testing of the PowerShell scripts themselves. Michael Sorens introduces you to Pester, the leading test framework for PowerShell, and shows how it can make it easier to produce reliable scripts  Read more...
By 2014/11/14 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 6,211 reads

It's Not Just Poor Coding

It's not just poor coding that threatens security, as a new survey shows.  Read more...
By Steve Jones 2014/11/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 201 reads

Overcoming the OPENQUERY Record Limit for AD

Sometimes you have to pull more than 50,000 records. A script to do that inside the 1000 record limit.  Read more...
By Steven Burns 2014/11/13 | Source: SQLServerCentral.com | Category: openquerry
Rating: |  Discuss |   Briefcase | 4,909 reads

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 | 6,869 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 | 130 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,446 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,539 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 | 23,785 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 | 140 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 | 64 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 | 107 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,708 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,414 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 | 5,926 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,720 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 | 96 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,623 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 | 163 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,518 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 | 66 reads
<< Newer    Items 21 to 40 of 13247    Older >>