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 13592    Older >>
 

Data Mining Part 25: Microsoft Visio Add-Ins

In the chapter 18-22 we explained how to work with Microsoft Excel to Access to the Data Mining information. This time, we will explain how to work with Microsoft Visio.   Read more...
By Daniel Calbimonte 2015/03/05 | Source: SQLServerCentral.com | Category: data mining
Rating: |  Discuss |   Briefcase | 3,229 reads

Getting Starting with Database Engine Tuning Advisor in SQL Server – Part 1

There are different techniques to optimize the performance of SQL Server queries but wouldn’t it be great if we had some recommendations before we started planning or optimizing queries so that we didn’t have to start from the scratch every time? This is where you can use the Database Engine Tuning Advisor utility to get recommendations based on your workload.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 5,986 reads

Stairway to Database Source Control Level 3: Working With Others (Centralized Repository)

One of the main purposes of placing a database under source control, alongside the application code, is to allow team collaboration during development projects. The Version Control System (VCS) stores and manages all of the project files, maintaining an audit trail of what changed, and who made the change. Each team member can work on a file, or set of files, and submit their changes to the VCS to make them available to other team members. They can also inspect the VCS to discover recent changes made by other team members.  Read more...
By Dave Green 2015/03/04 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,642 reads

Byte Me: Waifs And Strays

Make it HR's problem.  Read more...
By Bob Lang 2015/03/04 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 359 reads

Free eBook: SQL Server Hardware

SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.  Read more...
By Press Release 2015/03/04 (first published: 2013/07/24) | Source: Red-Gate | Category: hardware
Rating:  Rate this |   Briefcase | 44,944 reads

Questions About SQL Server Transaction Log You Were Too Shy To Ask

Tony Davis answers 10 surprisingly tricky questions about SQL Server Transaction Log.  Read more...
By Additional Articles 2015/03/04 | Source: SimpleTalk | Category: transaction log
Rating:  Rate this |   Briefcase | 7,475 reads

Holidays as Benefits

When you take a job, do you ask about holidays? Do you consider them a benefit? Andy Warren asks what those holidays might mean to you.  Read more...
By Andy Warren 2015/03/03 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 134 reads

Data Warehouse to OData to Excel and R

How do you make data available to analysts who want to blend data with R or Power Query tools? Why with OData services.  Read more...
By Benjamin Seidle 2015/03/03 | Source: SQLServerCentral.com | Category: odata
Rating: |  Discuss |   Briefcase | 5,096 reads

Reviewing Logical Hard Drive details using T-SQL and OLE Automation Procedures

One of the most important SQL Server DBA tasks is checking logical hard drive details such as the total capacity, free disk space, and used space by the SQL Server data and log files. In this tip we look at a method to view this information in a faster and simpler way.  Read more...
By Additional Articles 2015/03/03 | Source: MSSQLTips.com | Category: ole automation
Rating: (not yet rated)  Rate this |   Briefcase | 6,252 reads

Silicon Valley - DLM Training Workshop – Database Continuous Integration

Learn how to do SQL Server continuous integration at the first in a new series of Database Lifecycle Management Training Workshops, in Silicon Valley on March 27. To celebrate the launch, places for this workshop are free.   Read more...
By Press Release 2015/03/03 | Source: Red-Gate | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 5,560 reads

Webinars

The SSC and Red Gate webinar archive.  Read more...
By Steve Jones 2015/03/02 | Source: SQLServerCentral.com | Category: webinar
Rating: (not yet rated) |  Discuss |   Briefcase | 79 reads

No State Based Deployments

Today Steve Jones talks about deploying your database changes, and how you can't ever really depend on a state based approach.  Read more...
By Steve Jones 2015/03/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 122 reads

Are My Problems Caused By Replication?

We frequently need to discover the source of issues with our databases. This article provides information on how to detect replication on a database as a possible source of issues.  Read more...
By Eric Notheisen 2015/03/02 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 3,297 reads

Pier to Pier Replication on Frozen Lake Erie

In a guest post, Rodney Landrum ponders the gaps in his DBA experience at the edge of Lake Erie.  Read more...
By Rodney Landrum 2015/03/02 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 89 reads

Checking the Plan Cache Warnings for a SQL Server Database

How often do you check your query plans to see if they contain any warnings? If you're missing them, it means that you're not getting all those hints about missing indexes, join predicates or statistics. Is the query optimiser trying to tell you about implicit conversions? Dennes shows how to view the warnings in plan cache for a particular database using SQL.  Read more...
By Additional Articles 2015/03/02 | Source: SimpleTalk | Category: plan cache
Rating:  Rate this |   Briefcase | 6,954 reads

Outer Join – What am I missing (SQL Spackle)

This article shows how to find missing rows in a table using a outer join.   Read more...
By Patrick Cahill 2015/02/27 (first published: 2013/11/12) | Source: SQLServerCentral.com | Category: outer joins
Rating: |  Discuss |   Briefcase | 20,406 reads

The Express Choice

This week Steve Jones wonders if you'd be willing to use Express edition in production situations.  Read more...
By Steve Jones 2015/02/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 120 reads

Cloud Storage Replication Is Not Backup

The options that you need to select when setting up an Azure Storage service account allow you to specify the durability and high-availability of your data, but they don't provide for data recovery to a point-in-time. In fact, it means that some of the bad things that can happen to data are more efficiently replicated to all copies. Backup is quite a separate issue.  Read more...
By Additional Articles 2015/02/27 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 8,035 reads

SQL Saturday #381 - Richmond, VA

SQL Saturday is coming to Richmond on March 21, 2015. Join us for a free day of SQL Server training and networking. There are also paid-for pre-con sessions available from Tim Mitchell and Kevin Kline. Register while space is available.  Read more...
By Press Release 2015/02/27 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 6,032 reads

The Potential of Joins

An article about how we underestimate the power of joins and degrade our query performance by not using proper joins  Read more...
By Ashutosh Pandey 2015/02/26 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,999 reads
<< Newer    Items 61 to 80 of 13592    Older >>