Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

<< Newer    Items 61 to 80 of 15484    Older >>
 

Introducing Minion CheckDB by MinionWare

Minion CheckDB completes the MinionWare maintenance and backups suite in style. Each solution is plug-and-play for the busy DBA, and deeply configurable for those shops with in-depth needs.  Read more...
By Press Release 2017/02/01 | Source: SQLServerCentral.com | Category: minionware
Rating: (not yet rated) |  Discuss |   Briefcase | 462 reads

Planning for Successful Data Management

It is the data, in particular, that sets Database Lifecycle Management apart from the mainstream of application delivery. Data entities, and the way that organisations understand and deal with them, have their own lifespan. If we neglect the management of data, we risk disaster for the organisations that use it. If we take data management seriously, databases become a lot easier.  Read more...
Rating:  Rate this |   Briefcase | 4,591 reads

A Wide Variation in Skill

We all have different levels of skills, and it's not always because we don't try. Sometimes it's a question of timing.  Read more...
By Steve Jones 2017/01/31 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 115 reads

Loading Non Duplicated Data Using SSIS

Learn how you can easily load data from a file that isn't duplicated, discarding those rows that are.  Read more...
Rating: |  Discuss |   Briefcase | 1,211 reads

SQL Server v.Next : STRING_AGG Performance, Part 2

Aaron Bertrand starts digging deeper into the performance of string concatenation methods STRING_AGG and FOR XML PATH.  Read more...
By Additional Articles 2017/01/31 | Source: SQLPerformance.com | Category: string_ag
Rating:  Rate this |   Briefcase | 2,784 reads

The New DBA is a Developer

Today Steve Jones says the lines between developers and DBAs is blurred.  Read more...
By Steve Jones 2017/01/30 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 182 reads

Azure SQL Data Warehouse with PowerShell

We will teach how to create a new SQL Azure Data Warehouse using Powershell  Read more...
By Daniel Calbimonte 2017/01/30 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 417 reads

DevOps and Database Lifecycle Management

Database Lifecycle Management (DLM) aims to provide a roadmap of what is required, and when, to deliver and maintain effective databases that can respond quickly to business change. How does the DevOps movement, as it applies to databases, fit into this? William Brewer explains how DevOps provides the organisational change between delivery and operations to make important parts of the process easier to introduce.  Read more...
By Additional Articles 2017/01/30 | Source: SimpleTalk | Category: devops
Rating:  Rate this |   Briefcase | 2,623 reads

The vNext Bleeding Edge

Microsoft has a new early access program for SQL Server.  Read more...
By Steve Jones 2017/01/30 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 55 reads

Hyper-V and PowerShell: The Basics

Because it is important with maintaining Virtual Machine environments to be able to repeat routine tasks completely accurately, Windows PowerShell has grown in importance for the job. Now you can manage the Hyper-V environment via PowerShell without needing to use the Hyper-V Manager console. It opens up many opportunities for automation.  Read more...
By Additional Articles 2017/01/27 | Source: SimpleTalk | Category: hyper-v
Rating:  Rate this |   Briefcase | 4,667 reads

How Much Code Can You Review?

Code reviews are a part of many developers' lives, but is there a limit to what you can do effectively?  Read more...
By Steve Jones 2017/01/27 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 82 reads

The Elusive Conditional WHERE Clause

What's this, a conditional WHERE clause that doesn't use dynamic SQL?  Read more...
By John Hick 2017/01/27 (first published: 2013/04/18) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 37,308 reads

Changing Linked Server Passwords

How to article on changing passwords for linked servers via TSQL and SSMS.  Read more...
By Thomas Liddle 2017/01/26 | Source: SQLServerCentral.com | Category: linked server
Rating: |  Discuss |   Briefcase | 1,214 reads

The New SQL Server 2016 Edition Limits

There are some changes to memory limits in SQL Server 2016 SP1 Standard Edition.  Read more...
By Steve Jones 2017/01/26 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 97 reads

Importance of Performing DBCC CHECKDB on all SQL Server Databases

The SQL Server model database is one of the core system databases, but it seem to get less attention in terms of importance. This post from Simon Liew will demonstrate the havoc the model database can cause when database integrity checks exclude the model database and corruption goes undetected.  Read more...
By Additional Articles 2017/01/26 | Source: MSSQLTips.com | Category: dbcc checkdb
Rating: (not yet rated)  Rate this |   Briefcase | 4,452 reads

The Future is Now - An Internet of Things Infographic

A look at the positive and negative aspects of IoT in this infographic.  Read more...
By Site Owners 2017/01/25 | Source: SQLServerCentral.com | Category: internet of things
Rating: (not yet rated) |  Discuss |   Briefcase | 217 reads

The War Room

When things go wrong, how do you handle them? Steve Jones comments on crisis management using a great example from Amazon.  Read more...
By Steve Jones 2017/01/25 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 112 reads

Get Started with Azure Data Warehouse

In this article, we will learn how to use Visual Studio to query Azure SQL Data Warehouse tables and how to create a new table.  Read more...
By Daniel Calbimonte 2017/01/25 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 824 reads

SQL Server 2016 Build List

A list of all builds for SQL Server 2016. Updated with CU1 for SP1 and CU4 for RTM.  Read more...
By Site Owners 2017/01/25 | Source: SQLServerCentral.com | Category: sql server 2016
Rating: |  Discuss |   Briefcase | 766 reads

Columnstore Indexes and Computed Columns in SQL Server 2016

You can’t do everything with a columnstore index — but SQL Server’s optimizer can get pretty creative so it can use a columnstore index in ways you might not expect. Kendra Little explains.  Read more...
By Additional Articles 2017/01/25 | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 3,354 reads
<< Newer    Items 61 to 80 of 15484    Older >>