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

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

How to Get the Output of a Stored Procedure into a Table

Putting the output of a stored procedure into a table provides you multiple options for parsing and using the output with other TSQL commands. Read on to learn more.  Read more...
By Additional Articles 2016/11/30 | Source: Database Journal | Category: stored procedure
Rating:  Rate this |   Briefcase | 7,183 reads

EzAdo Part 4

EzAdo is a very simple api built to exploit some new features of SQL 2016. It combines software, convention, and creativity to get more done in less time.  Read more...
By Alan Hyneman 2016/11/29 | Source: | Category:
Rating: |  Discuss |   Briefcase | 623 reads

Finally, Create or Alter

Today Steve Jones looks at the CREATE OR ALTER syntax, added in SQL Server 2016 SP1.  Read more...
By Steve Jones 2016/11/29 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 86 reads

Quick SQL Prompt Tip – using the CDB snippet

There are a number of built-in snippets for SQL Prompt, and many of them are very simple, but they can greatly speed up your T-SQL coding if you learn what they are. Data Platform MVP Steve Jones shows how to make best use of the popular CDB snippet, for CREATE DATABASE statements, to save you time, but also ensure databases are created with the standard settings your organization may have, every time.  Read more...
By 2016/11/29 | Source: Redgate | Category: sql prompt
Rating: (not yet rated)  Rate this |   Briefcase | 1,773 reads

Who the Devil Wrote This SQL Code?

The way that you format T-SQL code can affect the productivity of the people who have to subsequently maintain your work. It is never a good experience to see SQL Code, cry out “Who the devil wrote this code?”, and then realise that it was you. Grant gives some examples of bad formatting and explains why you should never check-in badly-formatted SQL code.  Read more...
By Additional Articles 2016/11/29 | Source: SimpleTalk | Category: formatting
Rating:  Rate this |   Briefcase | 4,459 reads

How to Change an Analysis Services Instance to Tabular Mode

In this post I will show a procedure to change Analysis Services instance to tabular mode in SQL Server 2016 if you accidentally setup SQL Server Analysis Services to multi-dimensional mode instead of Tabular mode   Read more...
Rating: |  Discuss |   Briefcase | 540 reads

Hire the Right People

Today Steve Jones discusses the need to hire the people to do the tasks we need done, not the position we filled.  Read more...
By Steve Jones 2016/11/28 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 98 reads

Migrating Databases to Azure SQL Database

Tim Radney of SQLskills discusses strategy and some available tools for helping migrate your databases to Azure SQL Database.  Read more...
By Additional Articles 2016/11/28 | Source: | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 1,951 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: | Category: sql server 2016
Rating:  Rate this |   Briefcase | 2,600 reads

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,529 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: | Category: powerpivot
Rating: |  Discuss |   Briefcase | 9,542 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: | Category: ssrs
Rating: (not yet rated)  Rate this |   Briefcase | 3,943 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: | Category: editorial
Rating: |  Discuss |   Briefcase | 496 reads

Happy Thanksgiving 2016

Thanksgiving wishes from SQLServerCentral. 
By Steve Jones 2016/11/24 | Source: | 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: | Category: clustering
Rating: |  Discuss |   Briefcase | 422 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,044 reads

Byte Me: Wrong turn

By Bob Lang 2016/11/23 | Source: | 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: | Category: stairway series
Rating: |  Discuss |   Briefcase | 748 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,399 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,322 reads
<< Newer    Items 21 to 40 of 15273    Older >>