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

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

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,629 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,296 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,182 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 | 96 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,442 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 | 111 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 | 816 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 | 757 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,344 reads

Using Power BI and SSRS for visualizing SQL Server and R data (Part 4)

Using R with Power BI, SSRS or RTVS for easier data visualization  Read more...
By Tomaž Kaštrun 2017/01/24 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 1,306 reads

Something I learned while unemployed

Being unemployed is difficult. Here's something I learned to help me through it.  Read more...
By Rod Falanga 2017/01/24 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 183 reads

Automating the Setup of the Local Developer Machine

On both Windows and Linux, the chore of setting up a development workstation can take several days, and there always seem to be a few configuration settings that get missed. You can reduce the time and tedium dramatically by automating the process by using Vagrant to set up the operating system, followed by your choice of provisioning, configuration management and orchestration applications such as Puppet, Chef, Ansible, Salt, Docker, Chocolatey and Boxstarter. Vishwas shows how to make it easy to do with Vagrant, Chocolatey and Boxstarter.  Read more...
By Additional Articles 2017/01/24 | Source: SimpleTalk | Category: development
Rating:  Rate this |   Briefcase | 2,892 reads

Free Webinar: An Introduction to DevOps

Despite its growing popularity, there is still some confusion over what DevOps actually means, how organizations should do it and what the best way is to get started. Redgate have invited James Betteley, Head of Education at the DevOpsGuys, to run through the basics in this free webinar. Register now.  Read more...
By 2017/01/24 (first published: 2017/01/19) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 6,264 reads

The Purpose of a Database

Why do we have databases? Steve Jones has a few thoughts.  Read more...
By Steve Jones 2017/01/23 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 83 reads

The Inside Job

Grumpy DBA or necessary corporate oversight?  Read more...
By Phil Factor 2017/01/23 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 73 reads

Join Two CSV Files with a Common Column

In this example we will join two CSV files with a common column using SQL Server.  Read more...
By Daniel Calbimonte 2017/01/23 | Source: SQLServerCentral.com | Category: join
Rating: |  Discuss |   Briefcase | 1,710 reads

SQL Server 2012 Build List

A list of the builds of SQL Server 2012. Updated with CU16 for SP2 and CU7 for SP3.  Read more...
By Steve Jones 2017/01/23 (first published: 2012/04/17) | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 18,041 reads

Getting Started with R Services in SQL Server 2016 – Part 2

SQL Server 2016 brings native support for doing advanced analytics, using R Services, in the database itself. Arshad Ali takes a look at a detailed conceptual execution flow, executing R scripts from SQL Server Management Studio and other R client tools.  Read more...
By Additional Articles 2017/01/23 | Source: Database Journal | Category: r services
Rating: (not yet rated)  Rate this |   Briefcase | 2,995 reads
<< Newer    Items 61 to 80 of 15475    Older >>