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

<< Newer    Items 21 to 40 of 13704    Older >>
 

Is It Time to Upgrade?

Today Steve Jones looks at the reasons for upgrading, or not, from SQL Server 2005.  Read more...
By Steve Jones 2015/04/30 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 104 reads

Microservices in Promise and Practice

Are microservices the cure for the ague of monolithic applications, or do they bring their own problems with them that monolithic architectures have circumvented? Are they capable of delivering applications that are easier to maintain and develop? How can they avoid the failings of service-oriented architectures? Once more, Robert Sheldon gets to the heart of the technical issues.  Read more...
By Additional Articles 2015/04/30 | Source: SimpleTalk | Category: microservices
Rating: (not yet rated)  Rate this |   Briefcase | 5,688 reads

Byte Me: Slave Drive

Technical lead.  Read more...
By Bob Lang 2015/04/29 | Source: SQLServerCentral.com | Category: byte me
Rating: |  Discuss |   Briefcase | 303 reads

Stairway To Columnstore Indexes Level 2: Columnstore Storage

To fully appreciate just how different columnstore indexes are, and why work so well in reporting and online analytical processing (OLAP) workloads, but not for online transaction processing (OLTP), we must first look at the traditional “rowstore” indexes.  Read more...
By Hugo Kornelis 2015/04/29 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,688 reads

Automated database deployment workshop: London, UK

Join Redgate on May 20th for a 1-day public workshop in London. This event is for anyone who’s interested in automated deployments for SQL Server databases. You'll learn how to: Deploy databases using Redgate's DLM tools; Assess the different requirements of production and non-production deployments, and; Handle database administration tasks, such as backups and security, for automated deployment. Register while space is available.  Read more...
By Press Release 2015/04/29 | Source: Redgate | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 3,637 reads

Free eBook: Understanding SQL Server Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.  Read more...
By Press Release 2015/04/29 (first published: 2013/07/17) | Source: Redgate | Category: concurrency
Rating:  Rate this |   Briefcase | 60,672 reads

Disaster Recovery and Big Data

Big data applications are not usually considered mission-critical: while they support sales and marketing decisions, they do not significantly affect core operations such as customer accounts, orders, inventory, and shipping. Why, then, are major IT organizations moving quickly to incorporating big data in their disaster recovery plans?  Read more...
By Additional Articles 2015/04/29 | Source: Database Journal | Category: disaster recovery (dr)
Rating:  Rate this |   Briefcase | 6,134 reads

Dig Out the Root Cause

Finding the basis for a problem is always the best solution.  Read more...
By Steve Jones 2015/04/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 131 reads

Comprehensive Baseline Collector Solution (Updated)

There are no more excuses for not having baseline data. This article introduces a comprehensive Free Baseline Collector Solution  Read more...
By Robert Virag 2015/04/28 (first published: 2014/10/21) | Source: SQLServerCentral.com | Category: baseline
Rating: |  Discuss |   Briefcase | 7,548 reads

Mobile BI with SQL Server Reporting Services

For users to get the information they need from mobile reports, we frequently have to tailor the way we design those reports to the characteristics of the target device. Adam Aspin demonstrates some of the ways that we can deliver easy-to-use Business Intelligence to tablets and smartphones using Reporting Services.  Read more...
By Additional Articles 2015/04/28 | Source: SimpleTalk | Category: ssrs
Rating:  Rate this |   Briefcase | 4,940 reads

Survey on SQL Server Monitoring

If looking after the health of SQL Server is part of your responsibility, Redgate would love to hear your views on monitoring server health through this 10 minute survey. Complete the survey by May 15th to be in with the chance to win one of three $50 Amazon vouchers.  Read more...
By Press Release 2015/04/28 | Source: Redgate | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 4,680 reads

Microsoft Exercise

We have got a deal for you, Microsoft is concerned about the health of your company and is doing something about it.  Read more...
By Steve Jones 2015/04/27 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 131 reads

Data Mining Part 27: Microsoft Data Mining with Cubes

In the chapter 26 we created a cube. Now, we are going to create the Data Mining Model from it.  Read more...
By Daniel Calbimonte 2015/04/27 | Source: SQLServerCentral.com | Category: ssas
Rating: |  Discuss |   Briefcase | 2,632 reads

Email In The Bathroom: Not A Universal Good

Here are some fine, affordable products to completely destroy your work-life balance.  Read more...
By Dave Convery 2015/04/27 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 110 reads

Time Testing SQL Azure Point In Time Database Restores

If you need to do a time test for restoring an Azure SQL database from a point in time, and wonder about automating this through PowerShell, here are the guidelines that Tim Smith would you recommend?  Read more...
By Additional Articles 2015/04/27 | Source: MSSQLTips.com | Category: sql azure
Rating: (not yet rated)  Rate this |   Briefcase | 3,154 reads

Learn Continuous Integration for Databases in Bellevue, WA

Redgate Software has teamed up with Northwest Cadence to present a workshop on May 15, 2015. Come learn how to implement continuous integration in your database development software pipeline.  Read more...
By Press Release 2015/04/27 | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 3,228 reads

Code Reviews

This week Steve Jones asks about a concept that he used early in his career: code reviews. It's a good practice, but it seems as though it's fallen out of favor with many developers.  Read more...
By Steve Jones 2015/04/24 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 151 reads

How to Recover a SQL Server Login Password

I will describe a simple method anyone can use to obtain lost password information for a SQL Server login.  Read more...
By Geoff Albin 2015/04/24 (first published: 2013/03/04) | Source: SQLServerCentral.com | Category: password cracking
Rating: |  Discuss |   Briefcase | 29,241 reads

Understanding Cross-Database Transactions in SQL Server

Microsoft 'Always On' technology does not support distributed or cross-database transactions. Why not? Grahaeme Ross shows how to investigate cross-database transactions to understand the problem in more detail, and concludes that a Cross-Database transaction can cause loss of data integrity in the commit phase of the two-phase commit.  Read more...
By Additional Articles 2015/04/24 | Source: SimpleTalk | Category: distributed transactions
Rating: (not yet rated)  Rate this |   Briefcase | 5,457 reads

Your Role Is Changing

The DBA role is changing with the growth of DevOps as a way to better build software in an organization.  Read more...
By Sjors Takes 2015/04/23 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 171 reads
<< Newer    Items 21 to 40 of 13704    Older >>