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

Welcome to

A Microsoft SQL Server community of 1,859,262 DBAs, developers and SQL Server users

Headlines today   May 24, 2016

How to deploy and execute an SSIS package from the SSISDB catalog

Beginning with SQL Server 2012, SQL Server Integration Services packages can be deployed and executed from a SQL Server database named SSISDB, which serves as a repository for SSIS packages.   Read more...
By Stan Kulp 2016/05/24 | Source: | Category: ssis package execution
Rating: |  Discuss |   Briefcase | 1,277 reads

Unified Approach to Generating Documentation for PowerShell Cmdlets

Now, it is easy to provide professional-quality documentation for PowerShell cmdlets, and to keep it in sync when you make changes, whether they are written in PowerShell or C#. While this has always been easy to do in PowerShell, it was always painful to do in C# or VB because it meant having to build your own MAML file. Michael Sorens completes his three-part series by summarising, in a wallchart, how to go about it.  Read more...
By Additional Articles 2016/05/24 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 966 reads

Inside-SQL Conference: SQL Server Deep Dives in London

14th June, Londo, UK - Inside-SQL conference offers deep dives on a range of SQL Server topics, with tracks focusing on DBAs, Developers and BI. Use the discount code "Redgate" for £40 off the price of a ticket.  Read more...
By Additional Articles 2016/05/24 | Category: inside-sql
Rating: (not yet rated)  Rate this |   Briefcase | 825 reads
Previous headlines

Sharing on-premises SQL Server Data Analyses in the Cloud with Power BI

In this article I would like to introduce you to PowerBI.Com to see how to share analyses in the cloud using SQL Server data  Read more...
By Adam Aspin 2016/05/23 | Source: | Category: power bi
Rating: |  Discuss |   Briefcase | 667 reads

Database Hardware and Infrastructure Trends

Glen Berry talks through a number of useful new developments in hardware, storage, and the Microsoft Windows and SQL Server ecosystem.  Read more...
By Additional Articles 2016/05/23 | Source: | Category: hardware
Rating: (not yet rated)  Rate this |   Briefcase | 1,805 reads

Redgate DLM Demo (with TFS, TeamCity, Octopus Deploy)

How can Redgate DLM help you improve your database development and deployment processes? Join Grant Fritchey to see a demo of the Redgate DLM tools working with TFS, TeamCity, and Octopus Deploy. You'll learn how to version control your databases, include them in your CI process, and set up automated deployments. Register for the free webinar now.  Read more...
By 2016/05/23 (first published: 2016/05/19) | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,185 reads

Natively Compiled Stored Procedures: What they are all about

What are natively compiled stored procedures? Why would we want to use them and what are the performance benefits of using them over classic disk-based stored procedures?  Read more...
By Edward Pollack 2016/05/20 (first published: 2014/08/04) | Source: | Category: sql server 2014
Rating: |  Discuss |   Briefcase | 11,010 reads

Considerations around validation errors 41305 and 41325 on memory optimized tables with foreign keys

Denzil Ribeiro looks at the validation phase of transaction lifetime.  Read more...
By Additional Articles 2016/05/20 | Source: Microsoft MSDN | Category: memory optimized tables
Rating: (not yet rated)  Rate this |   Briefcase | 1,206 reads

A Comparison of JDBC Drivers for MySQL

A brief comparison of three different JDBC Drivers built for connecting with MySQL  Read more...
By Jerod Johnson 2016/05/19 | Source: | Category: jdbc
Rating: |  Discuss |   Briefcase | 699 reads

Comparing Networking Options in Azure

What are your options for connecting to an Azure VM? Sure, a Remote Desktop Protocol (RDP) connection will get you started but you'll soon need a full secure VPN connection. Azure can provide three different options for doing this: Point-to-Site (P2S), Site-to-Site (S2S), and ExpressRoute, but what are their relative advantages, and which one is right for the way you need to use Azure?  Read more...
By Additional Articles 2016/05/19 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,758 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

RAID your backups

Let’s start with a very brief definition of some RAID levels. RAID 0 : Stripe your data across multiple disks. Writing a...  Read more...
By Kenneth Fisher 2016/05/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 789 reads

10 SQL Server Data Warehouse Design Best Practices to Follow (Part 1 )

This past Saturday I had the pleasure of speaking at SQL Saturday #552 here in beautiful Jacksonville, Florida. My good...  Read more...
By dustinryan 2016/05/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,423 reads
Question of the Day

Scoring Term Extraction

By Steve Jones 2016/05/24 | Category: term extraction transformation
Rating: (not yet rated) |  Discuss |   Briefcase | 628 reads

The output of a Term Extraction Transformation can be which two types of values? (choose 2)

Top Members (last 30 days)
# Name Score Level
30 days All-time
Iwas Bornready
976 7809 SSCertifiable  
931 931 SSC Eights!  
520 1981 SSCommitted  
384 384 Old Hand  
322 1090 Ten Centuries  
Latest forum posts