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/07/21 to 2013/07/28

PowerShell the SQL Server Way

Although Windows PowerShell has been available to IT professionals going on seven years, there are still many IT pros who are just now deciding to see what the fuss is all about. Depending on your job, you might find PowerShell an invaluable tool. Microsoft's plan is that PowerShell will be the management tool for all of its servers and platforms. For most IT pros, it's not a matter of if you'll be using PowerShell, only a matter of when.  Read more...
By Additional Articles 2013/07/26 | Source: SQL Server Magazine | Category: powershell
Rating:  Rate this |   Briefcase | 3,726 reads

Configuring Database Mirroring

This article contains a set of instructions for configuring SQL Server mirroring, including pre-requisites. It also includes notes on how to resolve a few issues that I have encountered.  Read more...
By william thier 2013/07/26 (first published: 2011/02/01) | Source: SQLServerCentral.com | Category: database mirroring
Rating: |  Discuss |   Briefcase | 15,299 reads

SQLServerCentral.com Users Survey 2013

We want to make sure we're covering the things that are relevant to you, so we're asking for some feedback on what you use on SSC, where we need to improve, and what you'd like to see. It should only take a few minutes, and three randomly-selected people will win a $100 Amazon gift card for their efforts.   Read more...
By Additional Articles 2013/08/08 (first published: 2013/07/25) | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: (not yet rated)  Rate this |   Briefcase | 4,282 reads

Finding lost or forgotten SQL Servers

This article will show a way to find all SQL Servers, particularly those that have been forgotten about or lost.  Read more...
By Clay Punnett 2013/07/25 (first published: 2011/04/19) | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 15,495 reads

Disaster Recovery Tip #6 - Monitor Your Systems

Today's complex systems are too large to be able to rely on any DBA's memory for knowledge of each component, and its configuration options and settings.   Read more...
By Press Release 2013/07/25 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: (not yet rated)  Rate this |   Briefcase | 3,662 reads

AlwaysOn in SQL Server 2014 CTP1

AlwaysOn encompasses the SQL Server solutions for mission-critical high availability and disaster recovery. Two solutions were included under the AlwaysOn umbrella in SQL Server 2012: Availability Groups and Failover Cluster Instances. Each solution has different characteristics, making them appropriate for different scenarios, and both can be combined in the same deployment.  Read more...
By Additional Articles 2013/07/25 | Source: MSDN Communities | Category: sql server 2014
Rating: (not yet rated)  Rate this |   Briefcase | 2,424 reads

Stairway to Server-side Tracing - Level 3: Creating a SQL Trace Using SQL Server Profiler

In this third article of our Stairway Series on tracing, Dan Guzman goes into the method of using Profiler to help you create a custom trace of the events that you need to monitor.  Read more...
By Dan Guzman 2013/07/24 (first published: 2011/02/17) | Source: SQLServerCentral.com | Category: sql trace
Rating: |  Discuss |   Briefcase | 11,532 reads

Free eBook: SQL Server Hardware

SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.  Read more...
By Press Release 2014/10/22 (first published: 2013/07/24) | Source: Red-Gate | Category: hardware
Rating:  Rate this |   Briefcase | 31,952 reads

Rendering images from a database on SSRS reports

Looking for a way to put images on SSRS reports and allow the business users to change the images every so often? This article explains how to implement this in such a way that you don't have to modify a report when the image is changed.   Read more...
By Additional Articles 2013/07/24 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 3,055 reads

SQL Saturday #236 St Louis, MO

SQL Saturday is returning to St Louis for a full day of free SQL Server training and networking. This year's event will be on August 3, 2013 at the Saint Louis University's Center for Workforce & Organizational Development. We hope to see you there.   Read more...
By Press Release 2013/07/30 (first published: 2013/07/24) | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 4,328 reads

What’s going on, on my server, right now?

Quick and easy way to monitor server activity and be notified from alerts.  Read more...
By Kimberly Killian 2013/07/23 | Source: SQLServerCentral.com | Category: sql monitoring
Rating: |  Discuss |   Briefcase | 10,937 reads

Survey: Understanding SQL Code

Understanding thousands of lines of code of an existing database is very time-consuming and tedious, prone to inadvertent oversight of key logic points. We are looking at advanced ways to provide greater insight into your code base while reducing the numerous demands placed on the developer. Please help us by completing this short survey to help us define the requirements.  Read more...
By Additional Articles 2013/07/23 | Source: SQLServerCentral.com | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 4,571 reads

SQL Server Central Webinar Series #24: Prepare for When Disaster Strikes

Our next webinar on July 23rd has Steve Jones presenting on some disaster stories with ideas on how you might prevent, or mitigate the effects, of those problem situations.  Read more...
By Press Release 2013/07/23 (first published: 2013/07/03) | Source: SQLServerCentral.com | Category: webinar
Rating:  Rate this |   Briefcase | 4,595 reads

Are my actual worker threads exceeding the sp_configure 'max worker threads' value?

Tom Stringer (@SQLife) was working on some HADR testing for a customer to simulate many availability groups and introduce significant load into the system to measure overhead and such. In his quest to do that he was seeing behavior that he couldn’t really explain and so worked with him to uncover what was happening under the covers.   Read more...
By Additional Articles 2013/07/23 | Source: MSDN Communities | Category: availability groups
Rating: (not yet rated)  Rate this |   Briefcase | 2,822 reads

SQL Monitor Custom Metric: Top Buffer Cache Object

This metric measures the amount of memory used in the buffer cache by the largest object (based on the number of pages). It checks the sys.dm_os_buffer_descriptors to identify the object, and returns the relative percentage used. You should use this metric if you want to monitor what is in the buffer area, or if you are having performance-related disk read problems.  Read more...
By Press Release 2013/07/22 | Source: Red-Gate | Category: top buffer cache object
Rating: (not yet rated)  Rate this |   Briefcase | 3,120 reads

Tables and Clustered Indexes Part 2

A table does not so much 'have' a clustered index as a table 'is' a clustered index.  Read more...
By Hakim Ali 2013/07/22 | Source: SQLServerCentral.com | Category: clustered index
Rating: |  Discuss |   Briefcase | 6,358 reads

SQL Server 2012 Analysis Services XMLA

Cube developers often flippantly use the term XMLA in their discussion of maintaining, scripting, backing up, and restoring cubes and other SSAS objects; what exactly is XMLA and how can it be used? Check out this tip to learn more.  Read more...
By Additional Articles 2013/07/22 | Source: MSSQLTips.com | Category: analysis services (ssas)
Rating: (not yet rated)  Rate this |   Briefcase | 2,241 reads