Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

<< Newer    Items 41 to 60 of 13068    Older >>

RegEx for DBAs

RegEx functions are incredibly powerful text handling functions which should be at the top of a data warehouse DBAs list when writing CLR functions  Read more...
By David Poole 2014/09/05 (first published: 2012/05/08) | Source: | Category: regex
Rating: |  Discuss |   Briefcase | 17,499 reads

The Community Cloud

The 'Community Cloud' sounds, on first impression, like marketing-speak for some untried novelty, but in fact it is already around, and working well for governments and healthcare in particular. Bob Sheldon investigates, and is encouraged to find groups of organisations who have cooperated to create secure and resilient cloud-based services.  Read more...
By Additional Articles 2014/09/05 | Source: SimpleTalk | Category: cloud computing
Rating: (not yet rated)  Rate this |   Briefcase | 7,026 reads

Titles Matter – Part 2

In a followup to his previous piece, Andy Warren looks at job titles again and they can affect the people he works with.  Read more...
By Andy Warren 2014/09/05 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 156 reads

SQL Saturday #333 - St. Louis, MO

Call for Speakers. SQL Saturday is coming to St. Louis on Oct 11, 2014. The deadline for speaker's submissions is today (September 5), so if you've been considering speaking, this is your last chance. If you're thinking of attending this event, please register while space is available. More information can be found on the SQL Saturday #333 event page.  Read more...
By Press Release 2014/09/05 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 5,629 reads

Pairing Data Vault and Biml for DW Agility

Agile data warehousing can be challenging. Pairing the right methodologies and tools can help. Here is how my team met the challenge by using Data Vault methodology and BIML scripting.  Read more...
By Benjamin Seidle 2014/09/04 | Source: | Category: data warehousing
Rating: |  Discuss |   Briefcase | 1,989 reads

A Call for Articles

We're always looking for articles, but here are a few ones that I'd like to see written up.  Read more...
By Site Owners 2014/09/04 | Source: | Category: sqlservercentral
Rating: (not yet rated) |  Discuss |   Briefcase | 875 reads

Introduction to Azure PowerShell Modules for the SQL Server DBA Part 1

Our organization is starting to deploy more virtual machines on Azure for both testing and DR environments. I would like to create and administer Azure virtual machines using Windows PowerShell. How do I get started?   Read more...
By Additional Articles 2014/09/04 | Source:
Rating: (not yet rated)  Rate this |   Briefcase | 5,711 reads

Why Can't We Go Backwards?

How many times have you wanted to restore a database to an earlier version? Today Steve Jones asks why can't we do this and includes a way for you to vote on this.  Read more...
By Steve Jones 2014/09/04 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 192 reads

A few reflections on security by a weary application developer

Data security? No worries! Tell me how much you are willing to pay.  Read more...
By George Copeland 2014/09/03 | Source: | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 100 reads

Stairway to XML: Level 4 - Querying XML Data

You can extract a subset of data from an XML instance by using the query() method, and you can use the value() method to retrieve individual element and attribute values from an XML instance.  Read more...
By Rob Sheldon 2014/09/03 (first published: 2012/10/08) | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 14,266 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2014/09/03 (first published: 2014/02/26) | Source: Red-Gate | Category: replication
Rating:  Rate this |   Briefcase | 16,124 reads

Not unit testing your databases? You should be

Releasing a product without testing it is generally accepted as an unforgivable sin in the software development world. And frankly, there really isn’t an excuse not to test when we have whole suites of testing tools available to us  Read more...
By Additional Articles 2014/09/03 | Source: PluralSight | Category: testing
Rating:  Rate this |   Briefcase | 7,215 reads

Advice for Steve Jones

Steve Jones has some advice for a younger him.  Read more...
By Steve Jones 2014/09/02 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 173 reads

Clustered Columnstore Index Gives "Unable to find index entry" Error

The Clustered columnstore index generates "unable to find index entry" error and a memory dump after few DMLs on the table  Read more...
Rating: |  Discuss |   Briefcase | 1,593 reads

Quick Survey: PostgreSQL in Your Organization

Do you use PostgreSQL in your organization? Are you thinking about using it? Take our short survey and tell us about what you think about it.  Read more...
By Press Release 2014/09/02 | Source: Red-Gate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 7,172 reads

SQL Monitor Custom Metric: Time Since Last Restore

If your log restores aren't happening when they’re meant to, you want to know about it. You’ll be relying on restoring from logs should anything happen to your databases, and if you can’t restore to a certain point in time, you risk losing valuable data.  Read more...
By Press Release 2014/09/02 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 5,849 reads

Implementing Azure Blob Storage (ABS) With SQL Server 2014

With any application organizations face consistent key challenges such as high efficiency and business value, complex configuration, and low total cost of ownership. Extending applications to the cloud in hybrid scenarios addresses many of these challenges, whether distributing SharePoint content across on-premises and Office 365 while leveraging search as a service (hybrid search) or externalizing data, extending it to the cloud with Remote Blob Storage or related technologies.   Read more...
By Additional Articles 2014/09/02 | Source: Microsoft MSDN | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 5,445 reads

Happy Labor Day 2014

It's a holiday in the US 
By Steve Jones 2014/09/01 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 68 reads

Using the Script Task in SSIS to Process Data Files When They Arrive

Learn how you can process data files with SSIS as soon as they arrive using the Script Task.  Read more...
By Orlando Colamatteo 2014/09/01 (first published: 2012/10/25) | Source: | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 24,989 reads

New toys in SQL Server 2012

In this article we are going to look two new enhancements: the Insert snippet menu option and the surround with option.  Read more...
By Daniel Calbimonte 2014/09/01 (first published: 2012/05/15) | Source: | Category: insert
Rating: |  Discuss |   Briefcase | 17,991 reads
<< Newer    Items 41 to 60 of 13068    Older >>