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 2012/09/20 to 2012/09/27

An Interview with Amazon Web Services

A short interview with Sundar Raghavan of Amazon Web Services about SQL Server and their support and offerings of cloud data services.  Read more...
By Press Release 2012/09/27 | Source: SQLServerCentral.com | Category: cloud computing
Rating: |  Discuss |   Briefcase | 1,485 reads

Repairing a Broken Log Shipping Plan From a Differential Backup

This article details how to reinitialise a Log Shipping scenario from a primary differential backup  Read more...
By Perry Whittle 2013/12/20 (first published: 2012/09/27) | Source: SQLServerCentral.com | Category: differential
Rating: |  Discuss |   Briefcase | 3,275 reads

SQL Database Management Survey

Win one of two $50 Amazon vouchers by entering our database management survey. We’re finding out more about how SQL database professionals are doing backup and recovery, using cloud services and more. Answer the short survey for a chance to win.  Read more...
By Press Release 2012/09/27 (first published: 2012/09/24) | Source: Red-Gate | Category: survey
Rating:  Rate this |   Briefcase | 2,544 reads

Ten Things I Wish I'd Known When I Started Using tSQLt and SQL Test

The tSQLt framework is a great way of writing unit tests in the same language as the one being tested, but there are some 'Gotchas' that can catch you out. Dave Green lists a few tips he wished he'd read beforehand.  Read more...
By Additional Articles 2012/09/27 | Source: SimpleTalk | Category: unit testing
Rating:  Rate this |   Briefcase | 2,590 reads

Temporary Tables in Oracle and SQL Server

Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will host a live discussion on Oracle and SQL Server, this time in relation to temporary tables.  Read more...
By Press Release 2012/10/08 (first published: 2012/09/27) | Source: SQLServerCentral.com | Category: webinar
Rating:  Rate this |   Briefcase | 4,897 reads

Find out which SQL Server instance is consuming most of the CPU

We have a number of SQL Server hosts with multiple SQL Server instances. From time to time we have CPU issues, but we are not sure which instance is causing the issue. How do you find which SQL Server instance is causing CPU pressure on machine with multiple SQL Server instances? Check out this tip for ideas on how to find the correct SQL Server instance which is causing CPU pressure.  Read more...
By Additional Articles 2012/09/26 | Source: MSSQLTips.com
Rating:  Rate this |   Briefcase | 2,405 reads

Database Security Survey

A database security survey for a CS student. If you can spare a few minutes, I know he'd appreciate it.   Read more...
By Press Release 2012/09/26 | Source: SQLServerCentral.com | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 1,855 reads

Stairway to XML: Level 2 - The XML Data Type

Robert Sheldon describes SQL Server's XML Data Type, and shows that it is as easy to configure a variable, column, or parameter with the XML data type as configuring one of these objects with any other datatype  Read more...
By Rob Sheldon 2014/07/18 (first published: 2012/09/26) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 13,223 reads

SQL in the City - Seattle 2012

Start the week in Seattle off with a free day of training on Nov 5, 2012 with SQL in the City. Grant Fritchey, Steve Jones and more will be talking SQL Server in the Pacific Northwest. Join us and debate and discuss SQL Server the Red Gate Way.  Read more...
By Press Release 2012/10/16 (first published: 2012/09/13) | Source: SQLServerCentral.com | Category: sql in the city
Rating:  Rate this |   Briefcase | 5,194 reads

DAX Query Basics

In this document I will attempt to talk you through writing your first very simple DAX queries. For the purpose of this document I will query the rather familiar Adventure Works Tabular Cube.   Read more...
By Gary Strange 2013/12/12 (first published: 2012/09/25) | Source: SQLServerCentral.com | Category: dax
Rating: |  Discuss |   Briefcase | 13,870 reads

Meredith Ryan: DBA of the Day

Meredith Ryan – DBA at the Bell Group –was elected by judges and the SQL Server community as the Exceptional DBA of 2012. So who is Meredith, and how did she become a DBA? What makes her exceptional at her work? Simple-Talk sent Richard Morris to investigate.  Read more...
By Additional Articles 2012/09/25 | Source: SimpleTalk | Category: exceptional dba
Rating:  Rate this |   Briefcase | 2,152 reads

SQLServerCentral Webinar Series #21 - Forgotten Rings & Other Monitoring Stories

Most common monitoring metrics are important and useful, especially over time, but they can fall short. How do you gather information to determine, for example, if you have buffer cache pressure? Register now for the free webinar. Wednesday, October 17 2012 4:00pm - 5:00pm BST  Read more...
By Press Release 2012/10/15 (first published: 2012/09/20) | Source: Red-Gate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 5,114 reads

Webinar: Temporary Tables in Oracle and SQL Server

Once again Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will host a live discussion on Oracle and SQL Server, this time in relation to temporary tables. Will they agree on some common ground? Or will it be an out and out argument? Either way, be prepared for a lively exchange that will not only entertain, but will teach you key concepts on Oracle and SQL Server.  Read more...
By Additional Articles 2012/10/10 (first published: 2012/09/13) | Source: Red-Gate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 6,988 reads

Why is that SQL Server Instance under stress?

There are several reliable indications, using SQL Queries, of what is causing SQL Server performance problems. Some of these are fairly obvious, but others aren't. Grant shows how you can get clues from any SQL Server as to the cause of stress.  Read more...
By Additional Articles 2012/09/24 | Source: SimpleTalk | Category: stress testing
Rating:  Rate this |   Briefcase | 3,448 reads

The Importance of Validating Backups

You may think that if your database has backed up without errors, that it's going to restore without errors. Think again, says Paul Randal.  Read more...
By Paul Randal 2013/12/27 (first published: 2012/09/24) | Source: SQLServerCentral.com | Category: backups
Rating: |  Discuss |   Briefcase | 10,873 reads

Grant’s video warning – backup verification

Grant takes a humorous (but completely serious) look at why you should be regularly verifying your backups. Get top tips for backup and recovery, and protect yourself when disaster strikes. Watch the video  Read more...
By Additional Articles 2012/09/21 | Source: Red-Gate | Category: backup / recovery
Rating:  Rate this |   Briefcase | 2,381 reads

Power View Infrastructure Configuration and Installation: Step-by-Step and Scripts

This document contains step-by-step instructions for installing and testing the Microsoft Business Intelligence infrastructure based on SQL Server 2012 and SharePoint 2010, focused on SQL Server 2012 Reporting Services with Power View. This document describes how to completely install the following scenarios: a standalone instance of SharePoint and Power View with all required components; a new SharePoint farm with the Power View infrastructure; a server with the Power View infrastructure joined to an existing SharePoint farm; installation on a separate computer of client tools; installation of a tabular instance of Analysis Services on a separate instance; and configuration of single sign-on access for double-hop scenarios with and without Kerberos. Scripts are provided for all/most scenarios.  Read more...
By Additional Articles 2012/09/21 | Source: Microsoft MSDN | Category: powerview
Rating:  Rate this |   Briefcase | 1,940 reads

How to receive Deadlock information automatically via email

Receive Deadlock info from the SQL Error Log every time a deadlock occurs.  Read more...
By Geoff Albin 2014/01/03 (first published: 2010/12/13) | Source: SQLServerCentral.com | Category: deadlock
Rating: |  Discuss |   Briefcase | 46,153 reads

SQL in the City - Boston 2012

A free day of training in Boston on Oct 8, 2012. Come join Grant Fritchey, Steve Jones and more to talk about SQL Server and how you can work more efficiently.  Read more...
By Press Release 2012/09/21 (first published: 2012/09/11) | Source: SQLServerCentral.com | Category: sql in the city
Rating: (not yet rated)  Rate this |   Briefcase | 3,404 reads

Report Builder 3.0: Formatting the Elements in your Report

here is a lot that can be done to make basic tabular reports more readable, using Microsoft's free Report Builder. Rob Sheldon continues his exploration of the power of this tool by showing how to format various elements within reports.  Read more...
By Additional Articles 2012/09/20 | Source: SimpleTalk | Category: report builder
Rating:  Rate this |   Briefcase | 2,375 reads

Stairway to XML: Level 1 - Introduction to XML

In this level, Rob Sheldon explains what XML is, and describes the components of an XML document, Elements and Attributes. He explains the basics of tags, entity references, enclosed text, comments and declarations  Read more...
By Rob Sheldon 2014/03/26 (first published: 2012/09/20) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 29,611 reads

SQL in the City - Chicago 2012

A free day of training in Chicago on Oct 5, 2012. Join Grant Fritchey, Steve Jones and more to discuss, debate, ask questions, and learn about how to better run your organizations SQL Servers.  Read more...
By Press Release 2012/09/20 (first published: 2012/08/30) | Source: SQLServerCentral.com | Category: sql in the city
Rating:  Rate this |   Briefcase | 3,424 reads