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

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

What's New in SQL Server Reporting Services 2016

Koen Verbeeck provides an overview of the new features and capabilities found in SQL Server Reporting Services 2016.  Read more...
By Additional Articles 2016/11/25 | Source: MSSQLTips.com | Category: ssrs
Rating: (not yet rated)  Rate this |   Briefcase | 4,066 reads

Online T-SQL Scripts and Copyright

The issue of copyright for online scripts is a grey area. If a script is published without any form of copyright notice, most people assume that it is freely available for reuse. It's not necessarily the case.  Read more...
By Brad McGehee 2016/11/25 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 498 reads

Happy Thanksgiving 2016

Thanksgiving wishes from SQLServerCentral.  Read more...
By Steve Jones 2016/11/24 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 44 reads

Change the Collation Setting for Clustered SQL Server 2014 Instance

In this post I will show a procedure to change collation settings of SQL Server 2014 cluster instance.   Read more...
By Ganapathi varma Chekuri 2016/11/24 | Source: SQLServerCentral.com | Category: clustering
Rating: |  Discuss |   Briefcase | 423 reads

5 Advantages of Load Balancing For IT Companies

As an IT company, it is crucial that you maintain uptime and monitor the performance of various processes. By making database load balancing a key element, you can ensure that your processes and websites run smoothly. Tony Branson explains.  Read more...
By Additional Articles 2016/11/24 | Source: Database Journal | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 5,184 reads

Byte Me: Wrong turn

By Bob Lang 2016/11/23 | Source: SQLServerCentral.com | Category: byte me
Rating: (not yet rated) |  Discuss |   Briefcase | 53 reads

Stairway to Columnstore Indexes Level 10: Optimizing Queries For Batch Mode (Part 1)

In this level, Hugo Kornelis looks at how to rewrite your queries to best take advantage of batch mode.  Read more...
By Hugo Kornelis 2016/11/23 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 764 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's new In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.  Read more...
By Press Release 2016/11/23 (first published: 2015/05/13) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 29,439 reads

Which Edition of SQL Server is Best for Development Work?

You might think, as a developer, that nothing but the best is good enough as a development database. You might be mistaken. There is a lot to be said for LocalDB, but Ed Elliott argues that every edition has its pros and cons, and you need to consider Cloud-based resources, VMs and Containerised databases too. There is a whole range of alternatives and how you choose depends on the type of database you are developing, but for Ed, LocalDB gets the five-star accolade.  Read more...
By 2016/11/23 | Source: SimpleTalk | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 3,361 reads

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,710 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 | 35 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 | 231 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,682 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,340 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 | 731 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 | 138 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,018 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 | 86 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
<< Newer    Items 41 to 60 of 15282    Older >>