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/09/22 to 2013/09/29

An Interview with Allen Kinsel, PASS Board Candidate

Allen Kinsel is running for the board of directors of PASS. He took a little time to answer some questions from Steve Jones  Read more...
By Steve Jones 2013/09/27 | Source: SQLServerCentral.com | Category: interviews
Rating: (not yet rated) |  Discuss |   Briefcase | 421 reads

Generating Random Numbers in SQL Server Without Collisions

From time to time, I see a requirement to generate random identifiers for things like users or orders. People want to use random numbers so that the "next" identifier is not guessable, or to prevent insight into how many new users or orders are being generated in a given time frame, but they don't want to run into any duplicates. We can trade a bit of disk space and relatively predictable (but not optimal) performance for the guarantee of no collisions, no matter how many random numbers we've already used.   Read more...
By Additional Articles 2013/09/27 | Source: MSSQLTips.com | Category: generate numbers
Rating: (not yet rated)  Rate this |   Briefcase | 3,529 reads

Extended Properties Introduction

Part one of a four part series intent on demystifying and making more accessible SQL Server extended properties  Read more...
By Adam Aspin 2013/09/27 (first published: 2011/03/17) | Source: SQLServerCentral.com | Category: metadata
Rating: |  Discuss |   Briefcase | 14,694 reads

Calculating Elapsed Times (SQL Spackle)

Calculating elapsed time between time values can be an interesting problem that is easily solved even when data anomalies are present.  Read more...
By Dwain Camps 2013/09/26 | Source: SQLServerCentral.com | Category: sql elapsed times
Rating: |  Discuss |   Briefcase | 6,760 reads

Red Gate will be exhibiting at SQL Server Live! Orlando

SQL Server Live! is coming to Orlando November 18-22. SQL Server Live! provides comprehensive education and knowledge share on SQL Server database management, data warehouse/BI model design, performance tuning, troubleshooting and more.   Read more...
By Press Release 2013/09/26 | Source: Red-Gate | Category: events
Rating: (not yet rated) |  Discuss |   Briefcase | 367 reads

A Practical Guide to Microsoft Hyper-V Replica: Part II

A Hyper-V replica installation provides rapid disaster-recovery by asynchronously replicating a VM running at a primary site to a replica site. Know how to prepare for something to go wrong at the Primary Server/Site? In this article Nirmal Sharma presents the Replication options for a Replica Virtual Machine with a focus on Hyper-V Failover.  Read more...
By Additional Articles 2013/09/26 | Source: SimpleTalk | Category: virtualization
Rating:  Rate this |   Briefcase | 2,424 reads

Stairway to SQL PowerShell Level 2: SQL PowerShell Setup and Config

Now that you know how to get started with PowerShell, it is time to configure PowerShell for SQL Server use. This level covers the components you'll need and how to configure them.  Read more...
By Ben Miller 2013/09/25 (first published: 2012/08/15) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 13,262 reads

SSIS 2012 - Introduction to Windows Azure SQL Databases

When discussing SQL Server 2012 Integration Services, we have been dealing mainly with the traditional data management model, where the entire SQL Server environment resides on-premise. This once predominant paradigm is obviously changing, with hosted solutions (in the form of both private and public clouds) becoming increasingly common. In order to properly account for this trend, we turn our attention to the role that SSIS can serve in a mixed environment, where a part of the SQL Server estate is located in Windows Azure.  Read more...
By Additional Articles 2013/09/25 | Source: Database Journal | Category: sql azure
Rating: (not yet rated)  Rate this |   Briefcase | 2,323 reads

Five Rules For Successful Conversations With DBAs

As a developer working with SQL Server, you'll need to work with DBAs at one point or another. Here are some easy ways to make those conversations go smoothly.  Read more...
By Joshua Feierman 2013/09/24 | Source: SQLServerCentral.com | Category: dbas
Rating: |  Discuss |   Briefcase | 10,526 reads

Manage SQL Server Reporting Services in Management Studio

Most maintenance for SSRS is performed either in Report Manager online or within the Report Services Configuration Manager from the desktop. The SSRS Management Studio connection is certainly no replacement for either of these tools, however, several benefits can be obtained using SSMS. First, you are able to connect to the SSRS even if you are having browser issues; second, it is often quicker to just switch from using Management Studio for the Database Engine.  Read more...
By Additional Articles 2013/09/24 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating:  Rate this |   Briefcase | 4,120 reads

SQL Server Cloud Migration Part I

A SQL Server migration with minimal business impact while synchronizing schema and data.  Read more...
By Edward Polley 2013/09/23 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 3,173 reads

The PoSh DBA – Getting to know PowerShell

Although it was primarily designed for System Administrators, PowerShell is now extending its use to Database, SharePoint, Exchange and all Microsoft products. In this article Laerte Junior offers an introduction to PowerShell and describes how DBAs can use PowerShell to automate repetitive tasks. He also explains when to use PowerShell instead of, or in addition to, T-SQL and SSIS.  Read more...
By Additional Articles 2013/09/23 | Source: SimpleTalk
Rating:  Rate this |   Briefcase | 3,467 reads