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

SSIS 2012 Projects: Setup, Project Creation and Deployment

It used to be that SQL Server Integration Services (SSIS) packages had to be deployed individually. Now, they can be all deployed together from a single file by means of the Project Deployment Model introduced in SSIS 2012. Where there are tens or hundreds of SSIS packages to deploy, this system is essential.   Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 6,521 reads

Prepping for Winter

As winter approaches, many of us get ready in our personal lives, but Steve Jones notes that we might want to make sure we have regular preparation taking place on our systems for difficult times.  Read more...
By Steve Jones 2014/11/17 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 61 reads

ETL Performance Auditing - Part 3: Auditing Data Warehouse 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/14 (first published: 2012/06/19) | Source: | Category: business intelligence
Rating: |  Discuss |   Briefcase | 6,664 reads

Bucket List Data

This Friday Steve Jones is looking to see what data you're tracking about your life.  Read more...
By Steve Jones 2014/11/14 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 97 reads

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,317 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: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 206 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: | Category: openquerry
Rating: |  Discuss |   Briefcase | 4,939 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: | Category: alerting
Rating:  Rate this |   Briefcase | 7,004 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: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 132 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: | Category: biml
Rating: |  Discuss |   Briefcase | 29,505 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,705 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,920 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: | Category: books
Rating: (not yet rated) |  Discuss |   Briefcase | 148 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: | Category: books
Rating: (not yet rated) |  Discuss |   Briefcase | 66 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 | 108 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,778 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,547 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,037 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,754 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
<< Newer    Items 21 to 40 of 13250    Older >>