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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,739,698 DBAs, developers and SQL Server users

Rss
Headlines today   August 1, 2014

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: SQLServerCentral.com | Category: professional development
Rating: |  Discuss |   Briefcase | 15,428 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: CodeProject.com | Category: ssrs
Rating:  Rate this |   Briefcase | 4,027 reads
Previous headlines

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: SQLServerCentral.com | Category: dac
Rating: |  Discuss |   Briefcase | 2,178 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 | 3,684 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: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 2,647 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 | 24,789 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: MSSQLTips.com | Category: alerting
Rating: (not yet rated)  Rate this |   Briefcase | 5,237 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: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 4,413 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 | 6,649 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: SQLServerCentral.com | Category: fiscal year
Rating: |  Discuss |   Briefcase | 4,846 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Lost Administrator SA password SQL server 2012

There are many blog posts talking about, how to recover “SysAdmin” password in case if it’s lost OR the server...  Read more...
By MUTHUKKUMARAN KALIYAMOORTHY 2014/08/01 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,917 reads

Why do we need UPDATE Locks in SQL Server?

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...  Read more...
By Klaus Aschenbrenner 2014/08/01 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,610 reads
Question of the Day

Synonym

By Hardik Doshi 2014/08/01 | Category: synonym
Rating: (not yet rated) |  Discuss |   Briefcase | 616 reads
I am using SQL 2012. I have created a synonym but there is an issue with it: it has the wrong object name. How I need to resolve the issue so...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
vpriya132
570 797 Right there with Babe  
2.
cruice
562 562 Mr or Mrs. 500  
3.
SQLRNNR
315 21346 SSC-Insane  
4.
BWFC
306 900 SSC Eights!  
5.
Carlos Trujillo Almeida
296 3609 Hall of Fame  
Latest forum posts