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

Welcome to SQLServerCentral.com

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

Rss
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: SQLServerCentral.com | Category: ssis package execution
Rating: |  Discuss |   Briefcase | 1,101 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 | 823 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 | 721 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: SQLServerCentral.com | Category: power bi
Rating: |  Discuss |   Briefcase | 653 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: SQLPerformance.com | Category: hardware
Rating: (not yet rated)  Rate this |   Briefcase | 1,761 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,066 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: SQLServerCentral.com | Category: sql server 2014
Rating: |  Discuss |   Briefcase | 10,988 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,177 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: SQLServerCentral.com | Category: jdbc
Rating: |  Discuss |   Briefcase | 696 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,725 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 | 688 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,063 reads
Question of the Day

Scoring Term Extraction

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

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

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Iwas Bornready
976 7809 SSCertifiable  
2.
Amour
931 931 SSC Eights!  
3.
ShaynThomas1983
520 1981 SSCommitted  
4.
rudwk7003
384 384 Old Hand  
5.
shahm10
322 1090 Ten Centuries  
Latest forum posts