Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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

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 2015/05/13 | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 6,590 reads

How to Get SQL Server Security Horribly Wrong

It is no good doing some or most of the aspects of SQL Server security right. You have to get them all right, because any effective penetration of your security is likely to spell disaster. If you fail in any of the ways that Robert Sheldon lists and describes, then you can't assume that your data is secure, and things are likely to go horribly wrong.  Read more...
By Additional Articles 2015/05/13 | Source: SimpleTalk | Category: security
Rating:  Rate this |   Briefcase | 5,898 reads

The Case for Scalar-valued, User-defined Functions in T-SQL

Did you know that scalar-valued, user-defined functions can be used in DEFAULT/CHECK CONSTRAINTs and computed columns? Learn about it...  Read more...
By Dwain Camps 2015/05/12 | Source: SQLServerCentral.com | Category: scalar udf
Rating: |  Discuss |   Briefcase | 5,478 reads

Opening Up Data

Tim O'Reilly, head of O'Reilly publishing, has been an advocate of better date movement in the world. Steve Jones has a few comments on an interview he gave earlier this year.  Read more...
By Steve Jones 2015/05/12 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 80 reads

How To Calculate Behavioral Streaks in SQL Server Data

In this tip, Tim Smith demonstrates how to measure a behavioral streak with SQL Server, an important skill for determining ROI and extrapolating trends.  Read more...
By Additional Articles 2015/05/12 | Source: MSSQLTips.com | Category: functional programming
Rating: (not yet rated)  Rate this |   Briefcase | 5,338 reads

How do you work with databases?

How do you use SQL Server, and how do you expect this to change next year? Fill in Redgate's survey by May 15 and enter a prize draw to win one of 4 $50 Amazon vouchers.  Read more...
By Press Release 2015/05/12 (first published: 2015/05/05) | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 17,373 reads

The Service Pack Fiasco

The recent SQL Server 2014 Service Pack fiasco wasn't the first, but hopefully it won't be the last.  Read more...
By Steve Jones 2015/05/11 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 182 reads

How to run SSIS Project as a SQL Job

In this piece by Pilip Horan, learn how to create an SSIS catalog and run a project as a SQL Agent Job.  Read more...
Rating: |  Discuss |   Briefcase | 6,288 reads

Not Only a Meeting of Minds, but of Open Minds.

In which Phil Factor claims that professional application development requires a broad knowledge base.  Read more...
By Phil Factor 2015/05/11 | Category: editorial
Rating: |  Discuss |   Briefcase | 78 reads

Making Data Analytics Simpler: SQL Server and R

R an SQL Server are a match made in heaven. You don't need anything special to get started beyond the basic instructions. Once you have jumped the hurdle of reliably and quickly transferring data between R and SQL Server you are ready to discover the power of a relational database when when combined with statistical computing and graphics.  Read more...
By Additional Articles 2015/05/11 | Source: SimpleTalk | Category: data analtyics
Rating: (not yet rated)  Rate this |   Briefcase | 7,489 reads

Database Source Control Workshop: Philadelphia, PA

Redgate and Ike Ellis are hosting a database source control workshop in Philadelphia PA, on June 4, 2015. Learn all you need to put your development databases in source control, using the version control system of your choice. Register while space is available.  Read more...
By Press Release 2015/05/11 | Source: Redgate | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 4,408 reads

Temporary Stored Procedures

Temporary Stored Procedures - little known sql server feature  Read more...
By Harsha Majety 2015/05/08 (first published: 2013/06/25) | Source: SQLServerCentral.com | Category: temporary stored procedures.
Rating: |  Discuss |   Briefcase | 28,419 reads

How Virtualized?

This week's poll asks about virtualization in your environment. Let us know if you are moving your SQL Server to virtual machines.  Read more...
By Steve Jones 2015/05/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 121 reads

RESTful SignalR Service

This article explains how to expose SignalR feature through an ASP.NET Web API, which helps applications that can use REST service and to broadcast a real time message to their clients.  Read more...
By Additional Articles 2015/05/08 | Source: CodeProject.com | Category: rest api
Rating: (not yet rated)  Rate this |   Briefcase | 7,313 reads

How do you work with databases?

How do you use SQL Server, and how do you expect this to change next year? Fill in Redgate's survey by May 15 and enter a prize draw to win one of 4 $50 Amazon vouchers.  Read more...
By Press Release 2015/05/12 (first published: 2015/05/05) | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 17,373 reads

Tips to Optimize Your SQL Statements - Part 2

Read more tips to optimize SQL statements, specifically on a Data warehouse.  Read more...
By Brian Ellul 2015/05/07 | Source: SQLServerCentral.com | Category: sql server 2014
Rating: |  Discuss |   Briefcase | 10,471 reads

vNext 2016

Steve Jones looks at the next version of SQL Server, SQL Server 2016. Until this week, it was known as vNext.  Read more...
By Steve Jones 2015/05/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 157 reads

Alan Cooper: Geek of the Week

Alan Cooper helped to debug the most widely-used PC language of the late seventies and early eighties, BASIC-E, and, with Keith Parsons, developed C-BASIC. He then went on to create Tripod, which morphed eventually into Visual Basic in 1991. Alan remains enthusiastic and interested in development with strong views on Agile and Pair Programming.  Read more...
By Additional Articles 2015/05/07 | Source: SimpleTalk | Category: interview
Rating:  Rate this |   Briefcase | 6,491 reads

Stairway to Advanced T-SQL Level 4: Record Level Processing Using Transact-SQL Cursors

Using a CURSOR is not normally the best way to process through a set of records. Yet when a seasoned programmer moves to writing TSQL for the first time they frequently look for ways to process a sets of records one row at a time. They do this because they are not used to thinking about processing records as a set. In order to process through a TSQL record set a row at a time you can use a cursor. A cursor is a record set that is defined with the DECLARE CURSOR statement. Cursors can be defined as either read-only or updatable. In this article I will introduce you to using cursors to do record level processing one row at a time.   Read more...
By Gregory Larsen 2015/05/06 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,094 reads

Idempotent

There are all sorts of coding practices that produce better code. Steve Jones talks about one today.  Read more...
By Steve Jones 2015/05/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 124 reads
<< Newer    Items 41 to 60 of 13759    Older >>