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,563 DBAs, developers and SQL Server users

Rss
Headlines today   May 23, 2017

Yet another SSIS XML Destination

See a simple script to generate an XML file in SSIS.  Read more...
By Adán Bucio 2017/05/23 | Source: SQLServerCentral.com | Category: ssis
Rating: |  Discuss |   Briefcase | 497 reads

Azure Networking for SQL Server DBAs

The network is important to any DBA because so much performance is dependent on I/O, because of the importance of security, and ensuring that everyone get the right access. DBAs generally need not become experts in Azure networks, but it helps to understand the concepts and language. If you are running a SQL Server Virtual Machine in Azure, then VNets, Subnets, Network Security Groups, VNet peering and VPN gateways are all worth knowing about in order to to keep SQL Servers running smoothly.  Read more...
By Additional Articles 2017/05/23 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 802 reads

How to document multiple SQL Server databases using SQL Doc and PowerShell

You can use SQL Doc’s command-line parameters to automate database documentation, but when you try with a group of databases on a server, they sometimes don’t give you enough control over the job. Phil Factor provides a solution that allows both automation and flexibility.  Read more...
By Additional Articles 2017/05/23 | Source: Redgate | Category: sql doc
Rating: (not yet rated)  Rate this |   Briefcase | 1,172 reads
Previous headlines

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 | 204 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,234 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 | 1,010 reads

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,235 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,545 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,426 reads
 

Ask SQL Server Central

From the SQLServerCentral Blogs

Copy-SqlJob, a handy dbatools cmdlet

One of the things I’ve often needed to do is move jobs around between instances of SQL Server. I’ll often...  Read more...
By Steve Jones 2017/05/23 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 743 reads

Power BI Custom Visuals Class (Module 50 – Narratives)

In this module you will learn how to use the Narrative Power BI Custom Visual.  The Narrative visual is developed...  Read more...
By Devin Knight 2017/05/23 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 536 reads
Question of the Day

Super Grand Total MDX

By Devendra Thakur 2017/05/23 | Category: mdx
Rating: (not yet rated) |  Discuss |   Briefcase | 421 reads
Suppose you are running the following MDX script against Sample cube provided by Microsoft.

SELECT
FROM
[Adventure Works]
It returns a numeric value (in my case $80,450,596.98). What it represents?
  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Jeff Moden
29827 114342 SSC Guru  
2.
GilaMonster
27856 114014 SSC Guru  
3.
Steve Jones - SSC Editor
20091 81520 SSC Guru  
4.
Grant Fritchey
15536 54583 SSC Guru  
5.
Lynn Pettis
11943 50834 SSC Guru  
Latest forum posts