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 12983    Older >>

How To Write An Interview Winning Resume

Writing a resume that rocks is not an art. Follow these simple guidelines to help secure your next interview.  Read more...
By John Sansom 2014/08/01 (first published: 2012/07/19) | Source: | Category: professional development
Rating: |  Discuss |   Briefcase | 18,690 reads

Using Views

Views can be a great way to abstract away details for clients, but they can also make development much more flexible.  Read more...
By Steve Jones 2014/08/01 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 223 reads

Create First SSRS Report with SQL Server Analysis Services OLAP Cube

Mubin M. Shaikh outlines how to create SSRS Report on SSAS OLAP Cube. If you don't have much prior knowledge of SSRS, just follow the steps and to have your first report ready on OLAP Cube.  Read more...
By Additional Articles 2014/08/01 | Source: | Category: ssrs
Rating:  Rate this |   Briefcase | 9,707 reads

Spackle: Making sure you can connect to the DAC

The DAC is an important tool and several things can go wrong when trying to connect to it.  Read more...
By Kenneth Fisher 2014/07/31 | Source: | Category: dac
Rating: |  Discuss |   Briefcase | 2,780 reads

A TDD Journey: 1-Trials and Tribulations

Test-Driven Development (TDD) has a misleading name, because the objective is to design and specify that the system you are developing behaves in the ways that the customer expects, and to prove that it does so for the lifetime of the system. Michael Sorens starts an introduction to TDD that is more of a journey in six parts.  Read more...
By Additional Articles 2014/07/31 | Source: SimpleTalk | Category: test driven development
Rating:  Rate this |   Briefcase | 7,590 reads

Monitoring for Non Existent Events

Many DBAs monitor for those events they expect to happen, either successfully or failed. However many DBAs wouldn't be aware of an event never occurring.  Read more...
By Steve Jones 2014/07/31 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 122 reads

Data Driven Security

Set a security standard across environments that developers can see and run, but not change.  Read more...
By Andre Quitta 2014/07/30 | Source: | Category: security
Rating: |  Discuss |   Briefcase | 3,285 reads

Elevation of Privileges

The elevation of privileges is a large security problem and Steve Jones discusses his fears. Would you know if someone successfully attacked your instance?  Read more...
By Steve Jones 2014/07/30 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 102 reads

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 2014/07/30 (first published: 2013/08/28) | Source: Red-Gate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 28,219 reads

SQL Server Alert for Tempdb Growing Out of Control

One option to get notified when TempDB grows is to create a SQL Alert to fire a SQL Agent Job that will automatically send an email alerting the DBA when the Tempdb reaches a specific file size. This tip explains how to set it up.  Read more...
By Additional Articles 2014/07/30 | Source: | Category: alerting
Rating: (not yet rated)  Rate this |   Briefcase | 8,744 reads

One a Week

SQL Saturday continues to set records, and Steve Jones is amazed at the latest data.  Read more...
By Steve Jones 2014/07/29 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 153 reads

New SQL Server 2014 Permissions: CONNECT ANY DATABASE

CONNECT ANY DATABASE is one of three new permissions in SQL Server 2014 that can be granted to server logins. What is this new permission good for and why would we ever want this?  Read more...
By Edward Pollack 2014/07/29 | Source: | Category: security
Rating: |  Discuss |   Briefcase | 4,986 reads

Avoiding Database Deployment Disasters – 7 Tips

Here are seven practical tips for any 'accidental DBA' or developer, faced with having to deploy an upgrade to a database live to production, in a development environment that is in the early stages of getting the database code “house in order".  Read more...
By Additional Articles 2014/07/29 | Source: SimpleTalk | Category: database deployment
Rating:  Rate this |   Briefcase | 9,989 reads

How to Handle Calculations Related to fiscal year and quarter

This article describes an easy way to handle calculation based on fiscal year and quarter  Read more...
By Raymond Xie 2014/07/28 | Source: | Category: fiscal year
Rating: |  Discuss |   Briefcase | 5,386 reads

Frustration with Bad Design

It can be frustrating to deal with poorly implemented systems, but Steve Jones notes that you can't take things into your own hands.  Read more...
By Steve Jones 2014/07/28 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 274 reads

Microsoft Azure Cloud Services Part 2: Anatomy of a Cloud Service

In this article, we’ll be focusing on the different ways you can build with a Cloud Service, and what exactly happens in terms of virtual machines when you deploy your application.  Read more...
By Additional Articles 2014/07/28 | Source: Just Azure | Category: azure
Rating:  Rate this |   Briefcase | 8,669 reads

Static Code Analysis: a necessary irritation.

There is little doubt that static code analysis can contribute to code quality and deliverability. As an aid to a developer, it seems increasingly essential, but can it ever deliver reliable metrics of code-quality? One shudders at the potential misuse of quality metrics in the wrong hands. My hope is that it remains just an aid to human judgement; and creativity.  Read more...
By Phil Factor 2014/07/28 | Source:
Rating: (not yet rated) |  Discuss |   Briefcase | 30 reads

Exploring Recursive CTEs by Example

Recursive CTEs can be confusing and scary, so examining some non-standard examples may cast light upon these shadowy demons.  Read more...
By Dwain Camps 2014/07/25 (first published: 2012/07/17) | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 19,799 reads

Summer, Summer, Summertime

This Friday Steve Jones has a poll about your summertime activities. What have you done away from work that was memorable?  Read more...
By Steve Jones 2014/07/25 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 85 reads

Why Put Your Database into Source Control?

Checking program code into source control is a daily ritual for most developers, but versioning database code is less well-understood. Grant Fritchey argues that getting your databases under source control is not only vital for the stability of development and deployment, but it will make your life easier when something does go wrong.  Read more...
By Additional Articles 2014/07/25 | Source: SimpleTalk | Category: source control
Rating:  Rate this |   Briefcase | 10,296 reads
<< Newer    Items 61 to 80 of 12983    Older >>