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

<< Newer    Items 21 to 40 of 15264    Older >>
 

SQL in the City Streamed

Register now for Redgate's free virtual event offering a wealth of SQL Server sessions for you to live-stream on December 14 and 15.  Read more...
By 2016/11/28 | Source: Redgate | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 5,034 reads

Top 5 things you MUST know about PowerPivot for Excel

Although quite a lot has been written about PowerPivot and its features, there are certain aspects about PowerPivot that may not be obvious, especially to someone who is new to the tool. This articles discusses five such items.  Read more...
By Amir Charania 2016/11/25 (first published: 2015/01/12) | Source: SQLServerCentral.com | Category: powerpivot
Rating: |  Discuss |   Briefcase | 9,515 reads

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 | 3,723 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 | 495 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 | 416 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

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 | 4,709 reads

Byte Me: Wrong turn

By Bob Lang 2016/11/23 | Source: SQLServerCentral.com | Category: byte me
Rating: (not yet rated) |  Discuss |   Briefcase | 52 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 | 718 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,271 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,090 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,391 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 | 19 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 | 216 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,507 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,139 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 | 713 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 | 2,877 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
<< Newer    Items 21 to 40 of 15264    Older >>