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

Where in the Application Should Data Validation be Done?

Whereabouts in the application should the business logic of data-validation checks be made? The advantages of a layered approach to validation that includes database constraints, would seem to outweigh the disadvantages.   Read more...
By Additional Articles 2014/11/19 | Source: SimpleTalk | Category: data validation
Rating: (not yet rated)  Rate this |   Briefcase | 8,714 reads

Data Mining Part 21: Excel and Data Mining,validation methods

This article is part of the lesson 18 to 20 related to SQL Server Data Mining with Excel.   Read more...
By Daniel Calbimonte 2014/11/18 | Source: | Category: excel
Rating: |  Discuss |   Briefcase | 2,369 reads

Removing Rows with the DELETE Statement in SQL Server

Greg Larsen explores how to remove rows from a SQL Server table using the DELETE statement.  Read more...
By Additional Articles 2014/11/18 | Source: Database Journal | Category: delete rows
Rating: (not yet rated)  Rate this |   Briefcase | 9,556 reads

MY Data

As we gather more and more data about individuals, not only does security become an issue, but also the morality of using the data.  Read more...
By Steve Jones 2014/11/18 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 86 reads

SQL Monitor Custom Metric: Possible Duplicate Indexes

When a table has multiple indexes defined on the same columns, it produces duplicate indexes that waste space and have a negative impact on performance. This metric measures the number of possible duplicate indexes per database above a set threshold. You can then consider dropping the indexes and reverse the change.  Read more...
By Press Release 2014/11/18 | Source: Red-Gate | Category: index
Rating: (not yet rated)  Rate this |   Briefcase | 5,945 reads

Continuous Learning

It pays to continuously learn more about your job. SQL Server is so large, it really is a lifelong effort to drive yourself forward to master more and more.  Read more...
By Steve Jones 2014/11/17 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 141 reads

SQL Overview VII - SSRS Reports and Subscriptions

In the next installment of his series on the SQL Overview toolkit, David Bird looks at the information collected about SSRS.  Read more...
By David Bird 2014/11/17 | Source: | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 3,670 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 | 62 reads

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,770 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,725 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,473 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 | 110 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 | 211 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,993 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,153 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 | 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: | Category: biml
Rating: |  Discuss |   Briefcase | 29,611 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,888 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,074 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 | 163 reads
<< Newer    Items 21 to 40 of 13257    Older >>