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

<< Newer    Items 41 to 60 of 15487    Older >>
 

Data masking survey and prize draw

The Foundry team at Redgate know that managing sensitive and regulated data can be both challenging and problematic. They want to solve these problems, but first need your help to better understand them in context. What do you find frustrating? What would save you time? Please fill out this short survey to let them know, and as a thanks for your time, at the end you'll be entered into a draw to win a $100 Amazon gift card.  Read more...
By 2017/02/16 (first published: 2017/02/10) | Source: Redgate | Category: survey
Rating:  Rate this |   Briefcase | 3,126 reads

Fix Commvault Backup Failures After an Upgrade

In this article, you will learn how to troubleshoot backup failures in SQL Server 2016 when you run using commvault backup tool  Read more...
By Ganapathi varma Chekuri 2017/02/09 | Source: SQLServerCentral.com | Category: commvault
Rating: |  Discuss |   Briefcase | 430 reads

How Incorrect SQL Server Table Statistic Estimates Can Cause Slow Query Execution

Ben Snaidero explains that if you are updating your SQL Server table statistics nightly, but still seeing occasional poor performance with some of the queries being executed against my database, statistics could be the issue.  Read more...
By Additional Articles 2017/02/09 | Source: MSSQLTips.com | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 3,558 reads

Why Devops? For Better Security

DevOps is supposed to help us build better software, faster. Steve Jones looks at one of the other benefits: security.  Read more...
By Steve Jones 2017/02/09 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 51 reads

Backups Aren't Backups Until a Restore Is Made

Steve Jones comments on the Gitlab outage.  Read more...
By Steve Jones 2017/02/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 81 reads

Building Angular2 Apps with SQL Server Data

This article demonstrates using Angular2 and the CData API Server to build dynamic Web pages using SQL Server data.  Read more...
By Jerod Johnson 2017/02/08 | Source: SQLServerCentral.com | Category: angularjs
Rating: |  Discuss |   Briefcase | 1,220 reads

Simple Row Level Security for SQL Server 2016

Have you ever had a need to place some simple row level security on a SQL Server table? Well now you can do that in SQL Server 2016 by using row level security.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 5,842 reads

Using SQL Server and R Services for analyzing DBA Tasks

Article shows how R Services can help database administrators with their daily work   Read more...
By Tomaž Kaštrun 2017/02/07 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 1,126 reads

Determining What Happens When You Force an Execution Plan via the Query Store

When you force a query plan via the Query Store, you will need to track what happens: Sometimes the request to force a plan will fail, and you will want to know when and why. There are several ways of getting feedback, ranging from the built-in reports to using extended events. Enrico explains the details.  Read more...
By Additional Articles 2017/02/07 | Source: SimpleTalk | Category: query store
Rating:  Rate this |   Briefcase | 2,750 reads

Would You Still Love Linux If Windows Was Free?

A guest editorial today looks at the OS debate: Windows v Linux.  Read more...
By Andy Warren 2017/02/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 108 reads

A View of the Cloud

Today Steve Jones looks at how we can better build software by considering the cloud.  Read more...
By Steve Jones 2017/02/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 63 reads

Create and Connect to an Azure SQL Database

Demonstration on how to create and connect to a Microsoft Azure SQL Database with Microsoft Management Studio (SSMS) and Powershell  Read more...
By Thomas Liddle 2017/02/06 | Source: SQLServerCentral.com | Category: azsure sql database
Rating: |  Discuss |   Briefcase | 713 reads

Estimated Number of Rows to be Read

Rob Farley uses this month's T-SQL Tuesday to show off the results of one of his Connect items : Estimated Number of Rows to be Read.  Read more...
By Additional Articles 2017/02/06 | Source: SQLPerformance.com | Category: rows
Rating: (not yet rated)  Rate this |   Briefcase | 3,513 reads

Close Encounters of the CEIP Kind

Microsoft's Customer Experience Improvement Program for SQL Server: once easy to avoid, now hard to ignore, but Rodney Landrum sees an upside.  Read more...
By Rodney Landrum 2017/02/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 35 reads

Performance of the SQL MERGE vs. INSERT/UPDATE

The SQL MERGE statement offers convenience, safety and elegance, but how does it perform compared to other methods?  Read more...
By Dwain Camps 2017/02/03 (first published: 2013/10/28) | Source: SQLServerCentral.com | Category: merge
Rating: |  Discuss |   Briefcase | 36,664 reads

Your Favorite Feature that Needs Work

This week Steve Jones asks what parts of SQL Server would you improve and why.  Read more...
By Steve Jones 2017/02/03 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 61 reads

PowerShell Invoke-SQLCmd outputs DataTables you can INSERT into SQL Server

Aaron Nelson explains how you can take an existing SQL query, run it against a SQL Server and then take the results and save them to a different SQL Server without using Linked Servers.  Read more...
By Additional Articles 2017/02/03 | Source: MSSQLTips.com | Category: powershell
Rating:  Rate this |   Briefcase | 3,660 reads

Is your SQL Server remote?

If the answer is yes, this survey is for you. Redgate is looking at building solutions to the issues associated with remote SQL Servers. They want to know your pain points, and whether there's anything they can do to assist. If you think you could help the team out, please fill in their survey.  Read more...
By 2017/02/03 | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 4,723 reads

The Great and Powerful Internet of Things

A look at the good, and bad, of the IoT world along with the potential future.  Read more...
By Steve Jones 2017/02/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 73 reads

Preferred Node Policy-Setting on Traditional SQL Cluster

Preferred node setting facilitates instances on traditional cluster to be on the correct nodes which will lead to load-balancing of the resources.  Read more...
By SQL ADMIN 79 2017/02/02 | Source: SQLServerCentral.com | Category: clustering
Rating: (not yet rated) |  Discuss |   Briefcase | 518 reads
<< Newer    Items 41 to 60 of 15487    Older >>