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

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

Documenting your SQL Server Database

One of the shocks that a developer can get when starting to program in T-SQL is that there is no simple way of generating documentation for routines, structures and interfaces, in the way that Javadocs or Doxygen provides. To embed the documentation in the source is so obvious and easy that it is a wrench to be without this facility. Phil Factor suggests a solution.   Read more...
By Additional Articles 2015/05/18 | Source: SimpleTalk | Category: documentation
Rating: (not yet rated)  Rate this |   Briefcase | 6,011 reads

Usage of CTE - Trick with Dates

This article exlores the usage of CTEs as a replacement to cursors in order to generate additional data by applying logic to existing data.  Read more...
By Suresh Maganti 2015/05/15 (first published: 2013/06/18) | Source: SQLServerCentral.com | Category: cursor vs recursive cte
Rating: |  Discuss |   Briefcase | 28,429 reads

Searching for Plans

Would you want a query optimizer that searches for the best plan for your code? Steve Jones thinks this might not be a bad idea.  Read more...
By Steve Jones 2015/05/15 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 217 reads

Automating Day-to-Day PowerShell Admin Tasks - Jobs and Workflow

If you are aiming to optimise the use of your time by doing as much as possible via scripting, you will soon want to run scripts in parallel to save time. PowerShell does not demand that you run jobs one after the other; It has the means to launch actions whenever you wish and to obtain the results when you want them.  Read more...
By Additional Articles 2015/05/15 | Source: ITKnowledge Exchange | Category: automation
Rating:  Rate this |   Briefcase | 5,198 reads

Automated Database Deployment Workshop: Belfast, Northern Ireland

Redgate's DLM Workshops are coming to Belfast, NI on June 26, 2015. Learn how to: deploy databases using Redgate's DLM tools, assess the different requirements of production and non-production deployments, and handle database administration tasks, such as backups and security, for automated deployment. Register while space is available.  Read more...
By Press Release 2015/05/15 | Source: Redgate | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 4,487 reads

Documenting with Tests

The idea of using more unit tests to improve code quality has been around for some time. However Steve Jones notes today that some people use tests for documentation.  Read more...
By Steve Jones 2015/05/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 98 reads

Column Store vs Row Store Indexes

How does a column store index compare to a (traditional)row store index with regards to performance  Read more...
By Brian Ellul 2015/05/14 | Source: SQLServerCentral.com | Category: columnstore index
Rating: |  Discuss |   Briefcase | 6,237 reads

T-SQL Programming Part 14 - Using the TOP Clause with UPDATE, INSERT and DELETE Statements

Learn how to use the TOP clause in conjunction with the UPDATE, INSERT and DELETE statements.  Read more...
By Additional Articles 2015/05/14 | Source: Database Journal | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 8,341 reads

SQL Saturday #379 - South Florida

Join us for a free day of SQL Server training and networking in Davie, Florida on June 13, 2015. Admittance to this event is free, so register while space is available.  Read more...
By Press Release 2015/05/14 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 3,359 reads

Byte Me: The Nectar of Life

Whatever gets you through the day.  Read more...
By Bob Lang 2015/05/13 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 596 reads

The Ideal SQL Server Virtual Machine Architecture - Level 2 of the Stairway to SQL Server Virtualization

In Level 2 of the Stairway to SQL Server Virtualization, we examine the ideal VM configuration from a standpoint of the various resources involved.  Read more...
By David Klee 2015/05/13 | Source: SQLServerCentral.com | Category: virtualization
Rating: |  Discuss |   Briefcase | 7,889 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 2015/05/13 | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 6,125 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,460 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,415 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 | 79 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,053 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 | 16,580 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 | 180 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,201 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
<< Newer    Items 21 to 40 of 13750    Older >>