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

<< Newer    Items 61 to 80 of 14756    Older >>
 

Big Data Architecture

The next few years will be critical for the information technology staff, as they attempt to integrate and manage multiple, diverse hardware and software platforms. In this article, Lockwood Lyon addresses how to meet this need, as users demand greater ability to analyze ever-growing mountains of data, and IT attempts to keep costs down.  Read more...
By Additional Articles 2016/05/09 | Source: Database Journal | Category: big data
Rating: (not yet rated)  Rate this |   Briefcase | 4,962 reads

Unique Indexes Are Code; Non-Unique Indexes Are Data

Unique indexes are the database developer's responsibility. Non-unique indexes can be more easily maintained directly on the production database by an automated process.  Read more...
By Daniel White 2016/05/06 (first published: 2014/06/26) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 11,873 reads

Work to Live

It's important that you remember to live and enjoy your life as it passes by. Today Steve Jones reminds us that we want to work to live, but also plan to live and plan for the future.  Read more...
By Steve Jones 2016/05/06 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 406 reads

Announcing BIML Academy

Join Andy Leonard the week of May 9-13 for 5 free days of BIML training.   Read more...
By Press Release 2016/05/09 (first published: 2016/04/26) | Source: SQLServerCentral.com | Category: biml
Rating: (not yet rated)  Rate this |   Briefcase | 7,343 reads

SQL Server Reporting Services CountDistinct and Previous Functions

Scott Murray takes a look at what count function variations and related functions are available in SQL Server Reporting Services (SSRS).  Read more...
By Additional Articles 2016/05/06 | Source: MSSQLTips.com | Category: ssrs
Rating:  Rate this |   Briefcase | 2,710 reads

Understanding OPENJSON and FOR JSON in Azure and SQL 2016

An example of exporting and importing table data with JSON in Azure and SQL Server 2016.  Read more...
By Ryan Loftin 2016/05/05 | Source: SQLServerCentral.com | Category: openjson
Rating: |  Discuss |   Briefcase | 1,633 reads

ASP.NET Core: A More Realistic Starter Kit

ASP.NET Core is a fascinating platform with many good ideas, but in its present form (RC1)there is a culture shock for experienced ASP.NET developers to experience the effort involved in porting a realistic application. There is an obvious advantage on being able to host an application on any web server, but is this enough to compensate for losing the convenience of an integrated pipeline?  Read more...
By Additional Articles 2016/05/05 | Source: SimpleTalk | Category: asp.net
Rating: (not yet rated)  Rate this |   Briefcase | 3,193 reads

Promoting Engineers

It seems that often we promote the best technical people into managerial positions, but is that a good idea? Steve Jones notes that a few people think this is a bad idea and there ought to be a technical career path for IT workers.  Read more...
By Steve Jones 2016/05/05 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 274 reads

What’s in a name?

When a business does not have an agreed set of definitions for their every day terms slow burning chaos ensues.  Read more...
By David Poole 2016/05/04 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 74 reads

Data Mining Part 39: Azure Machine Learning vs Microsoft Data Mining

In earlier chapters, we talked about the Microsoft Data Mining enemies. We will talk now about Microsoft Azure Machine Learning.  Read more...
By Daniel Calbimonte 2016/05/04 | Source: SQLServerCentral.com | Category: data
Rating: |  Discuss |   Briefcase | 787 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/05/04 (first published: 2015/05/13) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 22,360 reads

STRING_SPLIT() in SQL Server 2016 : Follow-Up #1

Aaron Bertrand follows up on a recent post about the performance of STRING_SPLIT() with a few additional reader-motivated tests.  Read more...
By Additional Articles 2016/05/04 | Source: SQLPerformance.com | Category: string_split
Rating: (not yet rated)  Rate this |   Briefcase | 3,392 reads

What Does a DBA Do?

Today we have a guest editorial from Andy Warren as Steve is away. Andy tries to define what a DBA really does in a way that might make sense to others.  Read more...
By Andy Warren 2016/05/03 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 192 reads

GUI Enhancement on Instant File Initialization (IFI) in SQL Server 201

Ability to enable Instant File Initialization during the installation of SQL Server 2016.  Read more...
Rating: |  Discuss |   Briefcase | 1,081 reads

Execute Dynamic SQL commands in SQL Server

In some applications having hard coded SQL statements is not appealing, because of the dynamic nature of the queries being issued against the database server. Because of this sometimes there is a need to dynamically create a SQL statement on the fly and then run that command. This can be done quite simply from the application perspective where the statement is built on the fly whether you are using ASP.NET, ColdFusion or any other programming language. But how do you do this from within a SQL Server stored procedure?  Read more...
By Additional Articles 2016/05/03 | Source: MSSQLTips.com | Category: dynamic sql
Rating:  Rate this |   Briefcase | 5,102 reads

Buzzword Bingo

What uses of acronyms and phrases hinder instead of help?  Read more...
By Gary Varga 2016/05/02 | Source: SQLServerCentral.com | Category: communication
Rating: (not yet rated) |  Discuss |   Briefcase | 40 reads

Forcing SQL Agent Jobs to Fail When Remote Procedures Timeout

Your SQL Agent Jobs may be silently failing when using Linked Servers.  Read more...
By Chad Feghali 2016/05/02 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 1,271 reads

Install Cumulative Updates

This week Steve Jones recommends installing Cumulative Updates. If you can test them.  Read more...
By Steve Jones 2016/05/02 | Source: SQLServerCentral.com | Category: patching
Rating: (not yet rated) |  Discuss |   Briefcase | 45 reads

Announcing BIML Academy

Join Andy Leonard the week of May 9-13 for 5 free days of BIML training.   Read more...
By Press Release 2016/05/09 (first published: 2016/04/26) | Source: SQLServerCentral.com | Category: biml
Rating: (not yet rated)  Rate this |   Briefcase | 7,343 reads

Getting started with Azure SQL Data Warehouse

Azure SQL Data Warehouse is an obvious first-step towards migrating on-premise organisational data to the cloud. So how do you get started with it? Robert Sheldon provides a simple guide that should provide you with sufficient of the the basics you need to get a SQL Data Warehouse database up and running.  Read more...
By Additional Articles 2016/05/02 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 2,589 reads
<< Newer    Items 61 to 80 of 14756    Older >>