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

<< Newer    Items 41 to 60 of 15273    Older >>
 

Experience SQL Server 2016 in Microsoft Luxembourg’s Intelligent Office

The SQL Server Luxembourg User Group invites you to join us at our next event, in Microsoft’s new Intelligent Offices, for Tom van Zele’s SQL 2016 presentation. Tom’s road-show session highlights SQL Server 2016’s new features: End-to-end mobile BI, advanced analytics, cloud integration and lots of other new stuff will be addressed.   Read more...
By Additional Articles 2016/11/28 (first published: 2016/11/28) | Source: SQLServerCentral.com | Category: sql server 2016
Rating:  Rate this |   Briefcase | 2,583 reads

What is Azure SQL Data Warehouse?

Azure SQL Data Warehouse is a cloud-based, scale-out database capable of processing massive volumes of data, both relational and non-relational. Built on our massively parallel processing (MPP) architecture, SQL Data Warehouse can handle your enterprise workload.  Read more...
By Additional Articles 2016/11/22 | Source: Microsoft MSDN | Category: azure sql data warehouse
Rating: (not yet rated)  Rate this |   Briefcase | 32 reads

Configuring Integration Services in a SQL Server 2016 Cluster

In this post I will show a procedure to configure Integration Services in a SQL Server 2016 Cluster.  Read more...
By Ganapathi varma Chekuri 2016/11/22 | Source: SQLServerCentral.com | Category: ssis
Rating: |  Discuss |   Briefcase | 226 reads

Why Would I Ever Need to Partition My Big ‘Raw’ Data?

Whether you are running an RDBMS, or a Big Data system, it is important to consider your data-partitioning strategy. As the volume of data grows, so it becomes increasingly important to match the way you partition your data to the way it is queried, to allow 'pruning' optimisation. When you have huge imports of data to consider, it can get complicated. Bartosz explains how to get things right; not perfect but wisely.  Read more...
By Additional Articles 2016/11/22 | Source: SimpleTalk | Category: big data
Rating:  Rate this |   Briefcase | 2,675 reads

Monitor All the Changes

Today Steve Jones looks at the potential downfalls of monitoring every change without lots of filtering.  Read more...
By Steve Jones 2016/11/22 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 78 reads

SSC 2016 User Survey and Competition

What do you want to see more of on SQL Server Central? Anything you think we should get rid of? Let us know in this 17-question user survey, and at the end you can choose to be entered into a draw to win a $100 Amazon gift card. Thanks to everyone who's already answered, we greatly appreciate the feedback!  Read more...
By 2016/11/22 (first published: 2016/11/07) | Source: SQLServerCentral.com | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 6,320 reads

Service Broker Error Handling

How to handle errors raised during Service Broker Queue Processing.  Read more...
By Paul Milligan 2016/11/21 | Source: SQLServerCentral.com | Category: service broker
Rating: |  Discuss |   Briefcase | 724 reads

Implementing a custom sort

Rob Farley discusses some solutions and gotchas for implementing a custom sort using ORDER BY in T-SQL queries.  Read more...
By Additional Articles 2016/11/21 | Source: SQLPerformance.com | Category: order by
Rating:  Rate this |   Briefcase | 3,004 reads

Wow. Just Wow

Today Steve Jones looks at the loss of a database backup on a public website.  Read more...
By Steve Jones 2016/11/21 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 137 reads

What is Normal?

Phil Factor on the virtues of "over normalizing"   Read more...
By Phil Factor 2016/11/21 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 84 reads

Share the Interesting Work

Today we have a guest editorial from Andy Warren that looks at how we might divvy up our workload in a company.  Read more...
By Andy Warren 2016/11/18 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 70 reads

Wildcard Searches

Using wildcard to find patterns in strings going from the basics to some more complicated conditions.  Read more...
By Luis Cazares 2016/11/18 (first published: 2015/09/29) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 10,698 reads

How to Start Big Data with Apache Spark

It is worth getting familiar with Apache Spark because it a fast and general engine for large-scale data processing and you can use you existing SQL skills to get going with analysis of the type and volume of semi-structured data that would be awkward for a relational database. With an IDE such as Databricks you can very quickly get hands-on experience with an interesting technology.  Read more...
By Additional Articles 2016/11/18 | Source: SimpleTalk | Category: big data
Rating:  Rate this |   Briefcase | 2,546 reads

Getting more done with OUTPUT

Use OUTPUT to perform an INSERT and a DELETE at the same time.  Read more...
By Kenneth Fisher 2016/11/17 | Source: SQLServerCentral.com | Category: output
Rating: |  Discuss |   Briefcase | 2,518 reads

How to resolve SSIS access denied error in SQL Server Management Studio

Receiving an access denied error message when trying to connect to a remote instance of SSIS from SSMS? Sadequl Hussain provides the solution.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,229 reads

A Joke Come True

SQL Server is finally coming to Linux, a joke from Steve for years.  Read more...
By Steve Jones 2016/11/17 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 123 reads

Held Hostage by the Database

Does your database development process prevent changes in your software? You shouldn't be held hostage by your database.  Read more...
By Steve Jones 2016/11/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 78 reads

Stairway to U-SQL Level 11: Stored Procedures

To finish off our look at the core database objects, we inspect how the venerable stored procedure works in U-SQL.  Read more...
By Mike McQuillan 2016/11/16 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 1,227 reads

SSC 2016 User Survey and Competition

What do you want to see more of on SQL Server Central? Anything you think we should get rid of? Let us know in this 17-question user survey, and at the end you can choose to be entered into a draw to win a $100 Amazon gift card. Thanks to everyone who's already answered, we greatly appreciate the feedback!  Read more...
By 2016/11/22 (first published: 2016/11/07) | Source: SQLServerCentral.com | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 6,320 reads

Free eBook: SQL Server Execution Plans, Second Edition

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan?  Read more...
By Press Release 2016/11/16 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 88,172 reads
<< Newer    Items 41 to 60 of 15273    Older >>