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

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

Centrally collect replication conflicts and send an alert

Automatically capture replication conflicts and generate an automated email notification.  Read more...
By Kimberly Killian 2016/02/05 (first published: 2011/10/17) | Source: | Category: replication
Rating: |  Discuss |   Briefcase | 2,675 reads

Who's Got a Preteen SQL Server?

This week Steve Jones wonders about the age of your instances and whether you are planning on upgrades or aware of how many out of support instances you might have.  Read more...
By Steve Jones 2016/02/05 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 140 reads

Microsoft Survey on Backup and Security

Microsoft is looking for some people to talk to for ~20 minutes via phone/Skype and as a thank you for sharing, will provide a $10 Amazon gift card after the call.  Read more...
By Press Release 2016/02/05 | Source: | Category: backup and restore
Rating: (not yet rated) |  Discuss |   Briefcase | 343 reads

How to read data from multiple Excel worksheets with SQL Server Integration Services

Read this tip to learn how to import data from multiple Excel worksheets into SQL Server using SSIS.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,591 reads

SQL Azure Performance Benchmarking

An evaluation of the SQL Azure Database Performance Levels recommended by the DTU Calculator service, and a comparison with on premise SQL Server performance.  Read more...
By Paul Brewer 2016/02/04 | Source: | Category: sql azure
Rating: |  Discuss |   Briefcase | 1,020 reads

The New Operating System

We have an operating system for how our organizations are run. Steve Jones talks about a new one that might be important for the world rules by software.  Read more...
By Steve Jones 2016/02/04 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 113 reads

Monitoring In-Memory OLTP: What's Important?

In-Memory OLTP has evolved to be a great solution. However, a production system that uses it needs careful monitoring to avoid stress conditions becoming problems. As with many new features of SQL Server, it pays to plan a monitoring strategy to ensure that you are alerted as soon as possible when things go awry.  Read more...
By Additional Articles 2016/02/04 | Source: SimpleTalk
Rating:  Rate this |   Briefcase | 2,039 reads

Stairway to Database Source Control Level 4: Getting a Database into Source Control (Distributed Repository)

Now that we have our database under source control, we will want to share our work with other developers. If we are in a centralized source control system, our changes may be committed straight into the central repository. When we are working in a distributed system, it means pulling down any changes from other developers, addressing any areas of conflict, and pushing our changes up to allow others to benefit from our work. This allows our changes to be synchronized with the changes other developers have made. This level is principally about setting up a distributed source control system, namely Git, and how to commit database development changes to a local repository, before pushing them into a remote 'central' repository for sharing with other developers. The next level will delve a little deeper into Git's versioning mechanisms, and show some examples of how to share database changes during development, and how to deal with conflicting changes.  Read more...
By Dave Green 2016/02/03 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,689 reads

Simplify SQL Server ETL Processes with T-SQL Stored Procedures

Jeremy Kadlec introduces the Enhanced Data Integration Suite (EDIS), a SQL Server T-SQL stored procedure based solution to automate, manage, and audit ETL processes so you no longer have to manually build SSIS Packages.   Read more...
By Additional Articles 2016/02/03 | Source: | Category: etl
Rating:  Rate this |   Briefcase | 4,346 reads

Queues in Databases

The idea of using a queue in a database is one that some people try to avoid, preferring to use a messaging service. However, Steve Jones notes that this isn't always necessary.  Read more...
By Steve Jones 2016/02/03 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 127 reads

Maybe Security is Harder than Rocket Science

It's hard to build strong security over time, but it's worth the effort. Steve Jones notes that even smart people have problems implementing strong security.  Read more...
By Steve Jones 2016/02/02 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 95 reads

SQL Server System Audit Report

Ensuring that your SQL Server is secure is the job of every Database Administrator. In this article I will provide a script to help perform easier audits of your system.  Read more...
By Rudy Panigas 2016/02/02 | Source: | Category: audit
Rating: |  Discuss |   Briefcase | 2,876 reads

Data security, SQL Server 2016, and Your Business

From an IT infrastructure and compliance perspective, the importance of protecting data is clear. But it also has profound business implications and can even be a competitive differentiator by helping drive customer loyalty and retention. David Hobbs-Mallyon talks about Microsoft’s approach to data security.  Read more...
By Additional Articles 2016/02/02 | Source: TechNet Blogs | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 2,586 reads

What is the True Version of Code?

What version of your code is the true one? Steve Jones talks some version control today.  Read more...
By Steve Jones 2016/02/01 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 97 reads

Find and Remove Duplicate Records SQL Server

Learn a quick method to find and remove duplicate records in your SQL Server tables.  Read more...
By Ginger Keys 2016/02/01 | Source: | Category: data integrity
Rating: |  Discuss |   Briefcase | 5,839 reads

The PoSh DBA - Towards the Re-usable PowerShell Script

When starting out with PowerShell, it is hard to escape from the detail to work out the best strategy for creating scripts. Laerte Junior explains how, when and why it pays to think in terms of versatile functions to meet varying demands.  Read more...
By Additional Articles 2016/02/01 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,454 reads

Bogging Down in the Minutia of Minutes

Rodney Landrum gets lost in the fourth dimension, while coding the infinite possible combinations of SQL Server dates and times.  Read more...
By Rodney Landrum 2016/02/01 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 59 reads

Too much information can be counter-productive

If you want to be an effective communicator focus on what your audience need to hear rather than what you want to say  Read more...
By David Poole 2016/01/29 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 138 reads

Using the Statistical Program R for Running Statistics

This article talks about using the statistical program, R, for applying simple statistics against data in Microsoft SQL Server.  Read more...
By Tomaz Kastrun 2016/01/29 (first published: 2014/03/10) | Source: | Category: r language
Rating: |  Discuss |   Briefcase | 11,678 reads

The SQL Server 2016 Query Store: Built-in Reporting

One of the most important features of the SQL Server 2016's new Query Store is the reporting. With these features, it is now possible to get a wealth of information on how your query workload is performing, either aggregated for the entire query workload or for a single query. With this information, you can see the effects of 'forcing' an execution plan for specific queries and get feedback of the consequences.  Read more...
By Additional Articles 2016/01/29 | Source: SimpleTalk | Category: query store
Rating: (not yet rated)  Rate this |   Briefcase | 3,509 reads
<< Newer    Items 21 to 40 of 14463    Older >>