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

Rss
Headlines today   May 25, 2015

The Cascading (CROSS) APPLY

An old trick nowadays but one which is still underused here on SSC is the cascading CROSS APPLY – where output from one CROSS APPLY is used as input for another.  Read more...
By Chris Morris 2015/05/25 (first published: 2013/04/16) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 16,200 reads

Optimizing Batch Process in SQL Server

SQL Server batch processes are usually run from SQL Agent in the background. Often, the responsibility for creating these tasks belongs entirely to the developer. Dennes Torres demonstrates that DBAs can advise and assist with this type of batch job to help reduce their impact on the working system.  Read more...
By Additional Articles 2015/05/25 | Source: SimpleTalk | Category: batch processing
Rating: (not yet rated)  Rate this |   Briefcase | 2,201 reads
Previous headlines

Big Data for SQL folks: The Technologies (Part I)

Will RDBMs be obsolete? Should Data Professionals care about Big Data technologies? What is NoSQL? What is Hadoop? Big Data-the whole story.  Read more...
By Frank A. Banin 2015/05/22 (first published: 2013/06/26) | Source: SQLServerCentral.com | Category: big data
Rating: |  Discuss |   Briefcase | 19,611 reads

Developer-Tester Relationships

In a development team, there are times when the relationships between developers and testers can become strained. How can you turn this potential conflict into something more positive? Is it part of the skill of team-working to find ways of avoiding friction, or should one blame a system that relies on good social skills to work well?  Read more...
By Additional Articles 2015/05/22 | Source: SimpleTalk | Category: soft skills
Rating: (not yet rated)  Rate this |   Briefcase | 4,839 reads

Database Continuous Integration Workshop - London, UK

Join this workshop on July 8, 2015 to learn how to: link your source control repository to a build system, trigger database builds automatically when you make a change, use DLM tools to test your database changes, and lay the foundations for package-based deployment of your database. Register while space is available.  Read more...
By Press Release 2015/05/22 | Source: Redgate | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 2,856 reads

Interactive Parameter Selection with Reporting Services

Revamp the classic Reporting Services interface with a more modern look and feel adapted to mobile BI  Read more...
By Adam Aspin 2015/05/21 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 4,814 reads

Webinar: How to safely manage application and database changes with continuous delivery

Join Brian A. Randell, Grant Fritchey and Steve Jones in this panel discussion to hear tips, ideas and share your questions on managing application and database deployments with continuous delivery. This Free webinar will be on May 27th at 4PM BST, register while space is available.  Read more...
By Press Release 2015/05/21 | Source: Redgate | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 4,326 reads

PCI Best Practices Guide for SQL Server DBAs

Tibor Nagy has put together some best practices to help SQL Server DBAs navigate the many different requirements around PCI compliance.  Read more...
By Additional Articles 2015/05/21 | Source: MSSQLTips.com | Category: best practices
Rating: (not yet rated)  Rate this |   Briefcase | 4,154 reads

Building the Ideal VMware-based SQL Server Virtual Machine - Level 3 of the Stairway to SQL Server Virtualization

In this level of the Stairway to SQL Server Virtualization David looks at the ideal virtual machine setup for a SQL Server instance on VMware.  Read more...
By David Klee 2015/05/20 | Source: SQLServerCentral.com | Category: virtualization
Rating: |  Discuss |   Briefcase | 5,064 reads

Free Guide: Eight Steps to Effective SQL Server Monitoring

This free guide includes worked examples, practical advice, and covers the hows and why of SQL Server monitoring. Download the guide and get a 26 monitoring tips as well.  Read more...
By Press Release 2015/05/20 | Source: Redgate | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 6,573 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

SQL F.A.D. – Average Transactions Per Day - WaterOx Consulting

Reading Time: 2 minutesSometimes you just want to get an idea of what’s going on... The post SQL F.A.D. – Average Transactions...  Read more...
By WaterOx 2015/05/25 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,685 reads

Counting the number of rows in a table

Don’t be fooled by the title of this post: while counting the number of rows in a table is a...  Read more...
By Gianluca Sartori 2015/05/25 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,377 reads
Question of the Day

Today's Math

By Steve Jones 2015/05/25
Rating: (not yet rated) |  Discuss |   Briefcase | 473 reads

Which one of these queries returns today's day number?

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Jacob Wilkins
505 799 Right there with Babe  
2.
SimonH
458 1449 Ten Centuries  
3.
Junior Galvão - MVP
451 735 Right there with Babe  
4.
Jeff Moden
337 37414 SSC-Dedicated  
5.
Eirikur Eiriksson
330 3813 Hall of Fame  
Latest forum posts