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

<< Newer    Items 81 to 100 of 13951    Older >>
 

I Feel Like a Magician

Something sufficiently complex, in our eyes, may appear to be magic. Steve Jones feels some of his knowledge about SQL Server looks the same way to others.  Read more...
By Steve Jones 2015/07/06 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 187 reads

Getting to know your customers better – cohort analysis and RFM segmentation in R

It often pays to use a tool like R, in conjunction with a relational database, to quickly perform a range of analyses, and graphs, in order to ensure that you're answering the right question, to explore alternative hypotheses, or to provide insight into a problem. Feodor demonstrates how to quickly, and interactively, explore the ways that customers purchase goods and services using cohort analysis.  Read more...
By Additional Articles 2015/07/06 | Source: SimpleTalk | Category: r language
Rating: (not yet rated)  Rate this |   Briefcase | 1,884 reads

Is the role of the DBA really changing radically?

The term 'DBA' has been the despair of the IT industry, particularly IT recruitment, because there has been so little consensus as to what, precisely, it means. Phil Factor tries to clarify.  Read more...
By Phil Factor 2015/07/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 164 reads

Half a Year

We're halfway through the 2015 year and Steve Jones has a few thoughts for you this holiday weekend.  Read more...
By Steve Jones 2015/07/03 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 67 reads

A Quick Tour of the Performance Dashboard Reports

SQL Server Performance Dashboard comprises a set of custom reports that give you nitty gritty details about the performance of your SQL Server instance.  Read more...
By Prett Sons 2015/07/03 (first published: 2013/06/11) | Source: SQLServerCentral.com | Category: performance dashboard reports
Rating: |  Discuss |   Briefcase | 16,878 reads

Press Release: Redgate brings expert SQL Server training to London and Seattle

Cambridge, UK, 2 July 2015 – Redgate, the SQL Server and .NET software company, returns to London and Seattle in October with its enormously popular training event, SQL in the City.   Read more...
By Press Release 2015/07/03 | Source: Redgate | Category: redgate software
Rating: (not yet rated) |  Discuss |   Briefcase | 461 reads

SSMS Maturity

Announcements recently for changes in SSMS mean that the tool many of us rely on is growing up.  Read more...
By Steve Jones 2015/07/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 193 reads

Data Load Optimisation using the SSIS Balanced Data Distributor

Optimize SSIS data loads using parallel processing and the Balanced Data Distributor  Read more...
By Adam Aspin 2015/07/02 | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 4,408 reads

How to Fix a Corrupt MSDB SQL Server Database

Keep reading and you will see that there is another way to rebuild the msdb database without compromising the master database.  Read more...
By Additional Articles 2015/07/02 | Source: MSSQLTips.com | Category: msdb
Rating:  Rate this |   Briefcase | 3,619 reads

Stairway to AlwaysOn Level 7: Combining FCIs with Availability Groups

In Level 7 of this stairway, we look at combining Availability Groups with FCIs for both HA and DR protection.  Read more...
By Perry Whittle 2015/07/01 | Source: SQLServerCentral.com | Category: high availability
Rating: |  Discuss |   Briefcase | 2,121 reads

Training Computer Scientists

What's the best way to enter this business? Steve Jones has a few thoughts on the traditional CS degree.  Read more...
By Steve Jones 2015/07/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 220 reads

Free eBook: Defensive Database Programming

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.  Read more...
By Press Release 2015/07/01 (first published: 2013/08/28) | Source: Redgate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 61,719 reads

Survey: Development and Test Databases

Unless development happens directly on the production database, every organization will manage one or more development and test instances. Redgate is doing research to learn how development and test databases are managed within organizations. If you’d like to know more about our plans, or are happy to help us understand the problem, please take part in this 3-page survey.  Read more...
By Additional Articles 2015/07/01 (first published: 2015/06/26) | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 4,031 reads

Trusting Source Control

One of the benefits of a version control system (VCS) is that you can look at the history of code changes. Ed Elliot shows us a situation where that helps a DBA track down a problem.  Read more...
By ed.elliott 2015/06/30 | Source: SQLServerCentral.com | Category: version control
Rating: |  Discuss |   Briefcase | 3,387 reads

Grant User Access to All SQL Server Databases

Consider a situation when you have a large number of databases on your SQL Server, and you are requested to grant user access to all SQL Server databases. How can you grant access to a user for all databases on a SQL Server instance?  Read more...
By Additional Articles 2015/06/30 | Source: MSSQLTips.com | Category: security
Rating: (not yet rated)  Rate this |   Briefcase | 5,228 reads

The Importance of Our Work

Work is important, and it's a large part of our lives, but Steve Jones notes we need to keep things in perspective.  Read more...
By Steve Jones 2015/06/30 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 119 reads

Learning about the Cardinality Estimator

A few links to help you understand the Cardinality Estimator.  Read more...
By Site Owners 2015/06/29 | Source: SQLServerCentral.com | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 76 reads

The New DBA

Steve Jones has a new take on what it means to be a DBA.  Read more...
By Steve Jones 2015/06/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 271 reads

Indexing Foreign Keys

Foreign Keys are one of the fundamental characteristics of relational databases and enforce the referential integrity. Is it a good idea to index a FK relationship? When can it help?  Read more...
By Alessandro Mortola 2015/06/29 | Source: SQLServerCentral.com | Category: foreign keys
Rating: |  Discuss |   Briefcase | 8,426 reads

Learning about Multiple Tempdb Files

References and links to help you learn how to create multiple tempdb files.  Read more...
By Site Owners 2015/06/29 | Source: SQLServerCentral.com | Category: tempdb
Rating: |  Discuss |   Briefcase | 2,437 reads
<< Newer    Items 81 to 100 of 13951    Older >>