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,233 DBAs, developers and SQL Server users

Rss
Headlines today   July 30, 2014

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 | 1,850 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 | 23,038 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 | 3,528 reads
Previous headlines

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,015 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 | 5,643 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,542 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 | 4,913 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: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 18,482 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 | 7,204 reads

SQL Monitor Custom Metric: WriteLog Wait Time

During a transaction, data is written to the log cache so that it’s ready to be written to the log file on commit, or can be rolled back if necessary. When the log cache is being flushed to disk, the SQL Server session will wait on the WriteLog wait type. If this happens all the time, it may suggest disk bottlenecks where the transaction log is stored.  Read more...
By Press Release 2014/07/25 | Source: Red-Gate | Category: sql monitor
Rating:  Rate this |   Briefcase | 6,141 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Quick Tips–SQL Prompt Custom Aliases

I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love...  Read more...
By Steve Jones 2014/07/30 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,705 reads

Make an SSIS package Delay or Wait for Data

Packages can be scheduled to run at a time when you expect data to be in a database. Instead of...  Read more...
By MikeDavis 2014/07/30 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,265 reads
Question of the Day

table variable declaration inside a loop

By Sreepathi 2014/07/30 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 892 reads

DECLARE @i INT = 1
WHILE @i < 5
BEGIN
DECLARE @j AS TABLE
(
i INT
)
SET @i = @i + 1
INSERT INTO @j
SELECT @i
END

SELECT * FROM @j
If I run the above query,...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
vpriya132
562 737 Right there with Babe  
2.
cruice
501 501 Mr or Mrs. 500  
3.
BWFC
305 897 SSC Eights!  
4.
Carlos Trujillo Almeida
296 3609 Hall of Fame  
5.
Jeff Moden
272 36779 SSC-Dedicated  
Latest forum posts