Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2013/08/26 to 2013/09/02

SQLServerCentral Webinar Series #26: Best Practices in Database Deployment Part 2

This Tuesday Grant Fritchey and David Simner will give you a step-by-step guide to how you can automate your database deployment Process using Red Gate Deployment Manager.  Read more...
By Additional Articles 2013/09/02 | Source: Red-Gate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 1,342 reads

Common table expressions and circular references

Finding circular references that are stopping your CTE from working.  Read more...
By Geoff Norman 2013/09/02 (first published: 2011/01/31) | Source: SQLServerCentral.com | Category: cte
Rating: |  Discuss |   Briefcase | 16,009 reads

Test Your SQL Server Backups with PowerShell

The best way of checking SQL Server backups is to restore them and run DBCC CHECKDB on the restored database. To do this regularly means that you need to automate the task. Allen White shows how, with PowerShell.  Read more...
By Additional Articles 2013/09/02 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,403 reads

SQL Saturday #251 Paris, France

SQL Saturday is coming to Paris on September 14th 2013. Join us for a free day of SQL Server training and networking. This SQL Saturday will include a track on Business Intelligence, SQL Server, and something for beginners.  Read more...
By Press Release 2013/09/02 | Source: SQLServerCentral.com | Category: sql saturday
Rating:  Rate this |   Briefcase | 1,365 reads

The Database Administrator's Back-to-School Checklist

To meet the upcoming demands on IT systems database administrators (DBAs) need to prepare the database and its supporting infrastructure for increased resource demands. Being proactive now can pay big dividends by maintaining service level agreements (SLAs), avoiding outages and resource shortages, and ensuring a positive overall customer experience.  Read more...
By Additional Articles 2013/08/30 | Source: Database Journal | Category: dba concepts
Rating: (not yet rated)  Rate this |   Briefcase | 3,271 reads

Drive Space Monitoring Gets An Update

Monitoring drive space is something every DBA ought to be doing. Shaun Stuarts brings us a method that can easily be used to keep track of your SQL Server instance  Read more...
By Shaun J. Stuart 2013/08/30 (first published: 2010/10/04) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 16,562 reads

SQL Server Stored Procedures and SET options

SET options on stored Procedures work a bit different when compared with ad-hoc queries. These differences in behavior are often overlooked when developing the procedures and generating deployment scripts. This mistake can lead to undesired behavior in the application.  Read more...
By Nakul Vachhrajani 2013/08/29 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 8,521 reads

Database Administration as a Service

A DBA should provide two things, a service and leadership. For Grant Fritchey, it was whilst serving a role in the Scouts of America that he had his epiphany. Creative chaos and energy, if tactfully harnessed and directed, led to effective ways to perform team-based tasks. Then he wondered why these skills couldn't be applied to the workplace. Are we DBAs doing it wrong in the way we interact with our co-workers?  Read more...
By Additional Articles 2013/08/29 | Source: SimpleTalk | Category: dba skills
Rating:  Rate this |   Briefcase | 3,423 reads

SQL in the City Charlotte 2013

Join Red Gate on the day before PASS Summit for a full-day of free training from SQL Server MVPs and top presenters. Get $200 off your PASS conference ticket when you register for SQL in the City Charlotte, which takes place on Monday October 14.   Read more...
By Press Release 2013/10/02 (first published: 2013/08/29) | Source: Red-Gate | Category: sql in the city
Rating: (not yet rated)  Rate this |   Briefcase | 3,659 reads

Stairway to PowerPivot and DAX - Level 1: Getting Started with PowerPivot and DAX

Learning DAX is easy once you install the PowerPivot for Excel 2010 add-in and get practical exposure to using functions, operators and values in DAX formulas. Bill Pearson, business intelligence architect and author, kicks off another Stairway series designed to get you using DAX and PowerPivot quickly to provide actionable business intelligence in your own environment.  Read more...
By Bill Pearson 2014/05/07 (first published: 2011/12/21) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 20,387 reads

How to hide SQL Server user databases in SQL Server Management Studio

I have a SQL Server instance that has hundreds of databases. Navigating the database tree in SSMS is a pain and I was wondering if there was a way to limit the list of databases that I see in SSMS?  Read more...
By Additional Articles 2013/08/28 | Source: MSSQLTips.com | Category: management studio (ssms)
Rating: (not yet rated)  Rate this |   Briefcase | 4,195 reads

SQL in the City Atlanta 2013

SQL in the City is coming to Atlanta on October 11. The second stop on the SQL in the City US Tour brings you SQL Server MVP experts including, Steve Jones and Grant Fritchey. Learn top tips and best practices for SQL Server database development and administration, discover the latest Red Gate tools, and network with fellow data professionals.   Read more...
By Press Release 2013/10/01 (first published: 2013/08/28) | Source: Red-Gate | Category: sql in the city
Rating: (not yet rated)  Rate this |   Briefcase | 3,366 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,570 reads

Bulk Move/Rename of SSRS Reports through Web Services

Renaming and/or moving a large number or SSRS reports through the Report Manager interface is not a trivial task. This article will demonstrate how to achieve this by writing a small console application that will make web services calls to the Reporting Services Web Service.  Read more...
Rating: |  Discuss |   Briefcase | 4,046 reads

SSIS 2012 - Using PowerShell to Remotely Execute File System Packages in Multi-Server Scenarios

In this article Marcin Policht discusses different methods of executing SQL Server 2012 Integration Services packages deployed by employing the traditional Package Deployment Model, focusing in particular on those stored in the .dtsx file system format.   Read more...
By Additional Articles 2013/08/27 | Source: Database Journal | Category: file system task
Rating: (not yet rated)  Rate this |   Briefcase | 1,877 reads

SQL in the City Pasadena 2013

SQL in the City is coming to Pasadena on October 9. Register for a full day of free SQL Server training the Red Gate way. Top tips and best practices for SQL Server database development and administration will be presented by SQL Server MVP experts, including Steve Jones and Grant Fritchey. You’ll also see Red Gate tools in action and have the chance to network with other data professionals.   Read more...
By Press Release 2013/09/30 (first published: 2013/08/27) | Source: Red-Gate | Category: sql in the city
Rating: (not yet rated)  Rate this |   Briefcase | 3,467 reads

Minimal Logging

This article discusses minimal Logging in SQL Server.   Read more...
By Harsha Majety 2013/08/26 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,861 reads

Eight Steps to Effective SQL Server Monitoring

If you need to start monitoring your SQL Server instances and database, and there are many good reasons to do so, Tony Davis gives you the eight essential steps to diagnosing problems quickly.  Read more...
By Additional Articles 2013/08/26 | Source: SimpleTalk | Category: monitoring
Rating:  Rate this |   Briefcase | 4,555 reads

SQL Server Central Webinar Series #25 - Best Practices in Database Deployment Part 1: Aug 27th @ 4PM BST

Join Grant Fritchey (SQL Server MVP) as he tackles the most common problems and pitfalls of database deployment. He will explain how you (and your team) can make your deployment process, faster, more efficient and most importantly less stressful!  Read more...
By Press Release 2013/08/26 (first published: 2013/08/19) | Source: SQLServerCentral.com | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 4,035 reads

10 Things I Hate About Interviewing With You Webinar

This is a PASS VC Webinar, taking place on August 28, 1PM EDT. Get interviewing tips from both sides of the desk. Based on Thomas LaRock's 10 Things blog posts, this presentation by both Thomas LaRock and Karen Lopez will give you valuable insight into the interviewing process and how to improve your chances of landing that next job.  Read more...
By Press Release 2013/08/26 | Source: SQLServerCentral.com | Category: pass virtual chapters
Rating: (not yet rated)  Rate this |   Briefcase | 2,415 reads