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

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

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 | 4,262 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/06 (first published: 2016/12/02) | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 4,834 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,675 reads

Learn to Earn

Learning more about your craft can translate into more earnings, but it won't be easy.  Read more...
By Steve Jones 2016/12/01 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 86 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 | 2,128 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 | 2,388 reads

The Pressure to Compromise Ethics

There are always people that ask workers to deceive, defraud, or mislead customers. This is true for software developers as well.  Read more...
By Steve Jones 2016/11/30 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 81 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 | 978 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,393 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 | 7,535 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 | 630 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: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 90 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,892 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,610 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 | 544 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: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 103 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: SQLPerformance.com | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 2,074 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,719 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,765 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,562 reads
<< Newer    Items 21 to 40 of 15282    Older >>