SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,885,517 DBAs, developers and SQL Server users

Rss
Headlines today   May 22, 2017

Azure DWH part 9: Azure PHP and ASDW

In this new Azure Data Warehouse article, we will show how to insert data and retrieve it using PHP.  Read more...
By Daniel Calbimonte 2017/05/22 | Source: SQLServerCentral.com | Category: php
Rating: |  Discuss |   Briefcase | 161 reads

Step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster - Part 4

Continuing his series covering a step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster, Edwin Sarmiento looks at adding a node to an existing SQL Server 2016 failover clustered instance (FCI).  Read more...
By Additional Articles 2017/05/22 | Source: MSSQLTips.com | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 1,010 reads

Webinar: Extending DevOps practices to SQL Server databases

In this free demo webinar, Steve Jones and Arneh Eskandari will show how Redgate’s database DevOps solution works to improve your database development and deployment processes. With a focus on using Team Foundation Server (TFS) work items, the webinar will demonstrate how Redgate tools plug into TFS, TFS Build, and Microsoft Release Management. Register now.  Read more...
By Press Release 2017/05/22 | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 759 reads
Previous headlines

Forecasting with SQL

Can you use SQL Server to extrapolate out trends from your data? Lots of companies would have you buy a BI solution instead, but new author Mark Wojciechowicz brings us a great example of how you could forecast something in T-SQL.  Read more...
By Mark Wojciechowicz 2017/05/19 (first published: 2010/02/09) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 16,130 reads

Installing SQL Server Agent on Ubuntu Server

Manvendra Singh explains how to install SQL Server Agent on an Ubuntu server, so that you can create SQL Server Agent Jobs to schedule repetitive tasks.  Read more...
By Additional Articles 2017/05/19 | Source: MSSQLTips.com | Category: sql server agent
Rating: (not yet rated)  Rate this |   Briefcase | 1,447 reads

Do you use Visual Studio Code?

Visual Studio Code is rapidly gaining in popularity, but is it all it could be, or is there room for improvement? Redgate is embarking on some research to better understand how you are using this lightweight editor, and where it can be improved. Have your say by filling in this short survey!  Read more...
By Additional Articles 2017/05/19 (first published: 2017/05/17) | Source: Redgate | Category: visual studio code
Rating: (not yet rated)  Rate this |   Briefcase | 4,298 reads

Some of my greatest mistakes

You are never too experienced to make mistakes. An occasional dose of humble pie serves as a reminder to up our game.  Read more...
By David Poole 2017/05/18 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,951 reads

Using the DbFit Framework for Data Warehouse Regression Testing

It is ironic that the users of database application need to rely on the very technologists that created the system to then devise and run their acceptance tests. Surely someone has devised a test system for databases that is simple enough for ordinary tech-savvy people to use and for them to create the tests? Yes they have. Fitnesse DbFit is a mature product that can, and does, test SQL Server databases, and Nat Sundar explains how to set it up and do it.  Read more...
By Additional Articles 2017/05/18 | Source: SimpleTalk | Category: data warehouse
Rating:  Rate this |   Briefcase | 1,898 reads

How Redgate helped define a truly automated database deployment process

At the end of 2016, Redgate interviewed Bob Walker, a Lead Application Developer, to find out how he went about setting up automated database deployments using Redgate tools, and also to find out what lessons he learned during the process - the highlights make for interesting reading. Read the interview write-up.  Read more...
By Additional Articles 2017/05/18 | Source: Redgate | Category: automated deployment
Rating: (not yet rated)  Rate this |   Briefcase | 1,920 reads
 

Ask SQL Server Central

From the SQLServerCentral Blogs

SQL Azure Databases - Active Secondary - How to configure? - Part 1

Dear all, I have taken the azure dive at last :) In case if you are new to azure, azure is the Microsoft...  Read more...
By 2017/05/22 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 592 reads

General Notes on Security in Azure SQL Data Warehouse

I’m still learning about Azure SQL Data Warehouse (ADW, cause I’m lazy). ADW is a deceptively deep topic. Initially you...  Read more...
By Grant Fritchey 2017/05/22 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 529 reads
Question of the Day

Who can recycle the error log?

By Steve Jones 2017/05/22 | Category: error log
Rating: (not yet rated) |  Discuss |   Briefcase | 473 reads

I want to allow a fellow employee to recycle the error log every week or two for a SQL Server 2016 instance, without restarting the instance. What are the minimal...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Jeff Moden
29893 114079 SSC Guru  
2.
GilaMonster
27836 113743 SSC Guru  
3.
Steve Jones - SSC Editor
20123 81338 SSC Guru  
4.
Grant Fritchey
15651 54504 SSC Guru  
5.
Lynn Pettis
11959 50756 SSC Guru  
Latest forum posts