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

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

Free eBook: Defensive Database Programming

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.  Read more...
By Press Release 2015/02/11 (first published: 2013/08/28) | Source: Red-Gate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 51,498 reads

Using SQL Server's GROUP BY clause to Summarize your Data

SQL Server’s GROUP BY clause provides you a way to aggregate your SQL Server data and to group data on a single column, multiple columns, or even expressions. Greg Larsen discusses how to use the GROUP by clause to summarize your data.  Read more...
By Additional Articles 2015/02/11 | Source: Database Journal | Category: group by
Rating:  Rate this |   Briefcase | 9,628 reads

The Quickest Guide to Getting Started with PowerPivot

If you are still on the edge about PowerPivot and have not given it a shot, this article will get you started with ample of screen shots and a step-by-step guide.   Read more...
By Amir Charania 2015/02/10 | Source: | Category: powerpivot
Rating: |  Discuss |   Briefcase | 4,935 reads

Questions About T-SQL Control-of-Flow Language You Were Too Shy to Ask

Surely, we all know how T-SQL Control-of-flow language works? In fact it is surprisingly easy to get caught out. What, for example, do the BREAK, RETURN and CONTINUE keywords do in their various contexts? Robert Sheldon has the answers to this and other questions.  Read more...
By Additional Articles 2015/02/10 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 9,559 reads

SQL Bits and Community Superheroes

Chris Testa-O'Neil on the origins of SQL Bits and the joys of community events.  Read more...
By Chris Testa-O'Neil 2015/02/10 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 114 reads

SQL Saturday #370 - Phoenix, AZ

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Feb 28 2015 in Phoenix, AZ. Admittance to this event is free, and there are also 4 paid-for pre-con sessions on February 27. Register while space is available.   Read more...
By 2015/02/10 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 5,832 reads


Doing the same thing for too long, and not enjoying it, isn't good for anyone. You might be burned out, or as Steve Jones notes, you might need to change our perspective.  Read more...
By Steve Jones 2015/02/09 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 195 reads

Data Mining Part 24: SQL Profiler and Data Mining

In this chapter we will detect the Data Mining activity using SQL Server Profiler.  Read more...
By Daniel Calbimonte 2015/02/09 | Source: | Category: data
Rating: |  Discuss |   Briefcase | 2,295 reads

Advice for Learning T-SQL SELECT Statement Step By Step

In this tip, Dallas Snider shares his experience with how someone can start learning T-SQL from the beginning with no prior knowledge.  Read more...
By Additional Articles 2015/02/09 | Source: | Category: learning
Rating: (not yet rated)  Rate this |   Briefcase | 8,244 reads

Programming Rules and 'Best Practices' Can't Replace Professional Judgement

In which Phil Factor casts doubts on 'programming policies'. For certain, any IT team development requires plenty of methods of working that maximise productivity, but coding standards and ‘best practices’ have to be treated with caution. Programming rules can’t replace professional judgement  Read more...
By Phil Factor 2015/02/09 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 156 reads

Performance of the SQL MERGE vs. INSERT/UPDATE

The SQL MERGE statement offers convenience, safety and elegance, but how does it perform compared to other methods?  Read more...
By Dwain Camps 2015/02/06 (first published: 2013/10/28) | Source: | Category: merge
Rating: |  Discuss |   Briefcase | 29,358 reads


Inspired by the movie with the same name, Steve Jones has a Friday poll about inspiration and ideas.  Read more...
By Steve Jones 2015/02/06 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 192 reads

Release Testing Is Risk Management Theatre

The adoption of Continuous Delivery often leads to the discovery of suboptimal practices within an organisation, and the Release Testing antipattern is a common example. Steve Smith explores the questions: what is Release Testing, and why is it an example of Risk Management Theatre?  Read more...
By Additional Articles 2015/02/06 | Source: SimpleTalk | Category: release testing
Rating:  Rate this |   Briefcase | 6,387 reads

SQL Saturday #374 - Vienna, Austria

SQL Saturday is a full-day technical conference and training event with international speakers. With over 20 sessions on SQL Server and a separate pre-con, the event is aimed at all those interested in SQL Server - from pros to beginners. This event will be on February 28, 2015, so register while space is available.  Read more...
By Additional Articles 2015/02/06 | Source: SQL Saturday | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 5,710 reads

Interrupt Me, I'm Stagnating

Today we have a guest editorial from Andy Warren with a few hints on how you can continue to be proactive as a DBA.  Read more...
By Andy Warren 2015/02/05 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 174 reads

How does a View work on a Table with a Clustered Columnstore Index ?

This article is about how a view works when it is created on a table with clustered columnstore index on it.  Read more...
By Ramya Makam 2015/02/05 | Source: | Category: clustered columnstore
Rating: |  Discuss |   Briefcase | 4,051 reads

How do you develop and deploy your database?

Could you spare 3 minutes to do us a quick favor? Redgate’s running this short survey on how our readers develop and deploy databases. It’s just 12 multiple choice questions, so if you’ve got a couple of minutes to spare, we’d love to hear from you.  Read more...
By Press Release 2015/02/26 (first published: 2015/02/05) | Source: Red-Gate | Category: deployment process
Rating: (not yet rated)  Rate this |   Briefcase | 13,757 reads

Microsoft Azure Storage Queues Part 3: Security and Performance Tips

After discussion the main concepts and basic API calls for Azure Storage Queues in parts 1 and 2 of this series, Roman Schacherl turns his focus to two topics that no one likes to implement but everybody needs: security and performance.  Read more...
By Additional Articles 2015/02/05 | Source: Just Azure | Category: queues
Rating: (not yet rated)  Rate this |   Briefcase | 6,208 reads

Stairway to SQL Server Security Level 6: Execution Context and Code Signing

A fundamental way that SQL Server determines whether a principal has the permissions necessary to execute code is with its execution context rules. It’s all complicated by the possibility that a principal has permission to execute code but doesn’t have permission on the underlying objects accessed by the code, such as the data in a table. This stairway level will explore SQL Server’s execution context, ownership chains, and impersonation, as well as show you how you can control access to data via T-SQL code.  Read more...
By Don Kiely 2015/02/04 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,024 reads

Byte Me: Reality TV

That's entertainment. 
By Bob Lang 2015/02/04 | Source: | Category: byte me
Rating: (not yet rated) |  Discuss |   Briefcase | 330 reads
<< Newer    Items 61 to 80 of 13526    Older >>