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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,874,073 DBAs, developers and SQL Server users

Previous headlines

Hadoop For SQL Folks: Architecture, MapReduce and Powering IoT

As the de-facto big data processing and analytics engine, the Hadoop ecosystem is also leading the way in powering Internet of Things (IOT)  Read more...
By Frank A. Banin 2016/12/02 (first published: 2015/08/06) | Source: SQLServerCentral.com | Category: hadoop
Rating: |  Discuss |   Briefcase | 9,106 reads

4 Keys to a Clean Angular Implementation

Can there be true separation of concerns with MVC? Not entirely, especially when Angular's templates allow you to so much flexibility; but there is a great deal to be gained from following guidelines to ensure that all business logic is performed in the code-behind as directed by the controller or its delegate, and that all operations on the model are done in the controller: Michael Sorens explains the four essential guidelines for an easily-maintained system.  Read more...
By Additional Articles 2016/12/02 | Source: SimpleTalk | Category: angular
Rating: (not yet rated)  Rate this |   Briefcase | 2,871 reads

Have you adopted database DevOps?

Redgate invites you to participate in a survey to uncover rates of adoption of DevOps practices among Microsoft SQL Server database users. The survey will take between 5 and 10 minutes to complete. All respondents who provide a valid email address will be sent a copy of the research report when available, as well as being entered into a prize draw to win a $250 Amazon gift card.  Read more...
By 2016/12/02 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,688 reads

How to download a file from internet using SSIS

In this example, we will show how to download a file from internet using SSIS.  Read more...
By Daniel Calbimonte 2016/12/01 | Source: SQLServerCentral.com | Category: ssis
Rating: |  Discuss |   Briefcase | 1,427 reads

A brief history of version control

The fledgling computer industry did not invent version control. It merely adopted practices that were already well established in other industries. In part one of three, Wibke Carstensen takes a look at where it all started.  Read more...
By 2016/12/01 | Source: Redgate | Category: version control
Rating: (not yet rated)  Rate this |   Briefcase | 1,739 reads

Script to find oldest open SQL Server transaction

In this post, Eli Leiba shares a script that can be used to find the oldest open transaction and the statement that was issued.  Read more...
By Additional Articles 2016/12/01 | Source: MSSQLTips.com | Category: script
Rating: (not yet rated)  Rate this |   Briefcase | 1,942 reads

SQL Server 2016: The New @OneResultSet Parameter in SP_SpaceUsed

EXEC SP_SPACEUSED can return only one result set if you want it to. This is possible using a new parameter in SQL Server 2016. If are familiar with the inbuilt stored procedure sp_spaceused, I am sure you will find this new parameter quite useful.  Read more...
By Kenneth Igiri 2016/11/30 | Source: SQLServerCentral.com | Category: space management
Rating: |  Discuss |   Briefcase | 910 reads

Free eBook: SQL Server Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.  Read more...
By Press Release 2016/11/30 (first published: 2013/08/14) | Source: Redgate | Category: transaction log
Rating:  Rate this |   Briefcase | 79,044 reads

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 | 6,227 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: SQLServerCentral.com | Category: ado.net
Rating: |  Discuss |   Briefcase | 616 reads
 
Redgate DevOps Survey



Question of the Day

Communicating with the SQL Browser

By Steve Jones 2016/12/02 | Category: sql browser
Rating: (not yet rated) |  Discuss |   Briefcase | 650 reads

What is the name of the protocol that the SQL Server browser uses to communicate?

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Eirikur Eiriksson
364 6545 SSCertifiable  
2.
Jeff Moden
246 42046 SSC-Forever  
3.
Ed Wagner
208 9934 SSCrazy Eights  
4.
Luis Cazares
157 8200 SSCrazy Eights  
5.
GilaMonster
155 45619 SSC-Forever  
Latest forum posts