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

<< Newer    Items 61 to 80 of 13244    Older >>
 

Stairway to AlwaysOn Level 3: Infrastructure 101

In this next level of the Stairway to AlwaysOn, we will look at the components required to implement a Windows Server Failover Cluster.  Read more...
By Perry Whittle 2014/10/29 | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 2,708 reads

Automating Red Gate SQL Compare with MSSQL Server Agent

How to compare two databases and email the results to every one who needs to know  Read more...
By Neil Burton 2014/10/29 | Source: SQLServerCentral.com | Category: red gate
Rating: |  Discuss |   Briefcase | 1,038 reads

Stuck in a Rut

What do people do when their job doesn't require a lot of technical skills? Steve Jones has a few thoughts.  Read more...
By Steve Jones 2014/10/29 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 145 reads

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...
By Press Release 2014/10/29 (first published: 2013/08/07) | Source: Red-Gate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 38,015 reads

Triple Digits

Salaries for data professionals have risen quite a bit, according to the latest salary survey. That's good for those of us working with SQL Server.  Read more...
By Steve Jones 2014/10/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 211 reads

Data Mining Part 19: Excel and Data Mining, Samples, Queries

This lesson explains how to Clean Data, Explore Data, get Samples of Data, Classify and query a Data Mining Model.  Read more...
By Daniel Calbimonte 2014/10/28 | Source: SQLServerCentral.com | Category: excel
Rating: |  Discuss |   Briefcase | 4,527 reads

Data Is Crazier than You Think

As a society, we have an unrealistic respect for data, especially if it has a decimal point somewhere and uses metric units. We who are in the business of data need to cultivate a renewed interest in the sceptical and rigorous science of statistics: it is too important to leave to 'Data Scientists'. If the data is wrong, or the way we analyse or report it is misleading, much of what we do is pointless.  Read more...
By Additional Articles 2014/10/28 | Source: SimpleTalk
Rating: (not yet rated)  Rate this |   Briefcase | 7,362 reads

SQL Monitor Custom Metric: Average I/O Stalls

This metric is a great general indicator of performance problems. High stall times indicate I/O problems, which can be attributed to busy physical disks or queries that return large data sets to the client.  Read more...
By Additional Articles 2014/10/28 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 6,330 reads

CI and CD Aren't Magic

The techniques for Continuous Integration (CI) and Continuous Delivery (CD) don't make software better by themselves. It takes some investment and work by your staff as well.  Read more...
By Steve Jones 2014/10/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 89 reads

Dynamically change background color in SSRS reports using custom code

This article demonstrates the use of custom code and cell expressions referencing that custom code to toggle the background color of groups of rows in an SSRS report based upon value-changes in one of the fields.  Read more...
By Stan Kulp 2014/10/27 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 3,980 reads

Managers: who needs them?

Managers, look away now. Patrick Index wants to get something off his chest...  Read more...
By Patrick Index 2014/10/27 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 163 reads

Preparing Your Enterprise for Big Data

Big data applications are now fairly commonplace in large organizations. It is, however, difficult to simply ‘drop’ these applications into an existing IT infrastructure and expect to run smoothly. In addition to energy and cooling requirements for new hardware to support the new big data application, other IT areas need to prepare.  Read more...
By Additional Articles 2014/10/27 | Source: Database Journal | Category: big data
Rating: (not yet rated)  Rate this |   Briefcase | 8,486 reads

SQL in the City Seattle - November 3

SQL in the City Seattle is a free day of SQL Server training the Red Gate way. Come and hear presenters like Grant Fritchey, Gail Shaw, Ike Ellis, and more. Register while space is available.  Read more...
By 2014/10/27 | Source: Red-Gate
Rating: (not yet rated)  Rate this |   Briefcase | 1,100 reads

What's a Toaster?

There are always generic items that we encounter in life, things where it doesn't seem to matter to each of us what brand/price/model we pick. This Friday Steve Jones asks what you might consider to be generic in your job.  Read more...
By Steve Jones 2014/10/24 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 260 reads

Memory Corruptions, or Why You Need DBCC CHECKDB

DBCC is a mechanism that can protect you against corruptions causing substantial data loss in your database. If you use it.  Read more...
By Paul Randal 2014/10/24 (first published: 2012/11/08) | Source: SQLServerCentral.com | Category: memory corruption
Rating: |  Discuss |   Briefcase | 15,424 reads

The MidnightDBAs release Minion Reindex

The MidnightDBAs have developed a free reindexing solution to help DBAs perform maintenance on their instances. Read about the solution and attend their webinar.  Read more...
By Press Release 2014/10/24 | Source: SQLServerCentral.com | Category: press release
Rating: |  Discuss |   Briefcase | 1,841 reads

The Role of the Technical Architect in Development

What do Technical Architects (TAs) actually do when in a development role? Are they just senior developers 'pushed upstairs' into a management role? Is there a clear distinction between a TA and a product, or project, manager? In an increasingly automated and joined up development environment, the role is important, varied and wide-ranging; as Grzegorz Strzelecki explains.  Read more...
By Additional Articles 2014/10/24 | Source: SimpleTalk | Category: role
Rating:  Rate this |   Briefcase | 9,958 reads

SQL in the City London - October 24

SQL in the City London is a Red Gate event, full of SQL Server MVP training and networking. These events get bigger and bigger each year, so it's not one to be missed!  Read more...
By Press Release 2014/10/23 | Source: Red-Gate | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 157 reads

Regaining access to SQL server after changing the domain

If you changed your domain and have lost control over the SQL server or have been blocked from logging in , this article talks about it  Read more...
By Yousef Ekhtiari 2014/10/23 | Source: SQLServerCentral.com | Category: change domain
Rating: |  Discuss |   Briefcase | 2,495 reads

When is 8000 too small?

Over the years the page size in SQL Server has changed, growing larger to fit larger data sets. However not all functions have been modified to work with larger page sizes. Or even exceed them. Steve Jones wonders if it's time to increase the page size.  Read more...
By Steve Jones 2014/10/23 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 348 reads
<< Newer    Items 61 to 80 of 13244    Older >>