Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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

Solving an SSIS Error – Cannot convert between Unicode and non-Unicode

When loading data with SSIS, sometimes there are various errors that may crop up. This article provides a solution when you get have a problem between Unicode and non-Unicode fields.  Read more...
Rating: |  Discuss |   Briefcase | 1,461 reads

Listing Duplicate Values by Group

Without question, one of the most common tasks performed by Database Administrators (DBAs) is identifying and weeding out duplicate values in tables. Despite the inordinate number of queries written by other DBAs to locate duplicate values in their database tables, the real challenge is in locating a useable SQL statement to go by. Rob Gravelle presents a few solutions that will save you some time down the road.  Read more...
By Additional Articles 2016/12/15 | Source: Database Journal | Category: duplicate data
Rating: (not yet rated)  Rate this |   Briefcase | 6,027 reads

Deploying schema changes to multiple databases using the SQL Compare command line

Feodor Georgiev explains how SQL Compare Pro makes it possible to automate the process of synchronizing a source and target database. By calling SQL Compare from a simple batch script, he shows how to make it work for a whole list of targets, one after another.  Read more...
By Additional Articles 2016/12/15 | Source: Redgate | Category: sql compare
Rating: (not yet rated)  Rate this |   Briefcase | 2,327 reads

SQL in the City 2016

SQL in the City 2016 kicks off today and Steve Jones has a few thoughts.  Read more...
By Steve Jones 2016/12/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 59 reads

The Hibernate ORM and SQL Server

Using an ORM with SQL Server introduces unique challenges. I have listed a few of my experiences, hoping it can help someone.  Read more...
By Yell McGuyer 2016/12/14 | Source: SQLServerCentral.com | Category: hibernate
Rating: |  Discuss |   Briefcase | 993 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 2016/12/14 (first published: 2013/07/17) | Source: Redgate | Category: concurrency
Rating:  Rate this |   Briefcase | 82,142 reads

Retrieving SQL Server Query Execution Plans

Execution plans explain all you need to know about query performance, and how to fine-tune. Sure, you can see them in SSMS, but what if you need to drill into to the important details? What about using DMVs, Extended Events or SET statements to get at the execution plans? To get the best use of execution plans you need to be able to get right information from the right plan at the right time. Robert Sheldon explains how.  Read more...
By Additional Articles 2016/12/14 | Source: SimpleTalk | Category: execution plans
Rating:  Rate this |   Briefcase | 3,171 reads

DBAs Need to Learn to Develop

SQL Server is growing as a platform and Steve Jones says that DBAs need to learn development skills.   Read more...
By Steve Jones 2016/12/13 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 562 reads

Generate Deadlock Summary Information

This article will show you how to extract a summary of tables affected by deadlocks.  Read more...
By Carolyn Richardson 2016/12/13 | Source: SQLServerCentral.com | Category: deadlocks
Rating: |  Discuss |   Briefcase | 2,042 reads

A Big Deal : SQL Server 2016 Service Pack 1

Microsoft has made a bold change with SQL Server 2016 Service Pack 1 : Many Enterprise features are now available in lower editions. Read on for details.  Read more...
By Additional Articles 2016/12/13 | Source: SQLPerformance.com | Category: sql server 2016
Rating:  Rate this |   Briefcase | 8,096 reads

Creating SSRS Tabular Reports with Sparklines and Charts

Learn how to add a sparkline and line chart to your SQL Server 2014 Reporting Services reports.  Read more...
By Gemma Bibby 2016/12/12 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 1,238 reads

The Five Year Plan

Is your IT department outdated? There's a prediction that they won't be around in five years. Steve Jones doesn't agree.  Read more...
By Steve Jones 2016/12/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 311 reads

Faster Versions and More Support

Even more support from Microsoft for SQL Server.  Read more...
By Steve Jones 2016/12/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 52 reads

Your Professional Development and the PASS Organization

There are so many ways of keeping your technical skills and knowledge up-to-date. There are books, articles, conferences, video courses and so on, but nothing beats discussion and debate with professional people in other organisations facing a similar range of technical challenges, some of which you share, and others you maybe haven't yet. PASS is unique in providing just this vital ingredient for database professionals using the Microsoft Data Stack.  Read more...
By Additional Articles 2016/12/12 | Source: SimpleTalk | Category: pass
Rating:  Rate this |   Briefcase | 4,980 reads

Free Webinar: Redgate DLM Demo

Learn how to use Redgate’s DLM solution to improve your database change management process in our free webinar on December 13th. Microsoft Data Platform MVP, Grant Fritchey, and Redgate’s Arneh Eskandari, will demonstrate how Redgate’s tools plug into TFS, TFS Build & Microsoft Release Management so that you can build, test and deploy your database alongside your application code.  Read more...
By 2016/12/12 (first published: 2016/12/08) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 5,007 reads

SQL Server Performance Dashboard Reports

Setting up SQL Server Management Studio (SSMS) based performance dashboard driven off servers that are registered through a Central Management Server (CMS).  Read more...
By Arun Sirpal 2016/12/09 (first published: 2015/08/20) | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 10,191 reads

The One Metric to Rule Them All

Measuring the performance of systems isn't always just CPU, RAM, and Disk IO. Today Steve Jones looks at business based metrics.  Read more...
By Steve Jones 2016/12/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 86 reads

Some Tips for Minimising the Pain of HTML Input Forms

HTML Input forms are, by their nature, tiresome for the user of any website. However, with some attention to detail and a dash of JavaScript, it is possible to reduce the drudgery of form-filling to the minimum and minimise mistakes. Dino explains four ways of making things better for the user of your website.  Read more...
By Additional Articles 2016/12/09 | Source: SimpleTalk | Category: html
Rating:  Rate this |   Briefcase | 2,849 reads

Troubleshooting a painful query using execution plans in SQL Monitor

When something's wrong with your database you need to be able to identify the primary pain points within SQL Server and get to the root cause of the problem fast. Grant Fritchey explains how you can use execution plans inside SQL Monitor to help quickly and simply identify the problem.  Read more...
By Additional Articles 2016/12/09 | Source: Redgate | Category: execution plans
Rating: (not yet rated)  Rate this |   Briefcase | 3,047 reads

Downloading multiple files from internet with SSIS and C#

This is a tutorial to download multiple files from internet using the SSIS Script Task.  Read more...
By Daniel Calbimonte 2016/12/08 | Source: SQLServerCentral.com | Category: ssis
Rating: |  Discuss |   Briefcase | 1,115 reads
<< Newer    Items 81 to 100 of 15381    Older >>