SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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

SQL Server Logical Reads – What do they really tell us?

In this article, we will examine this counter’s true meaning and provide examples that prove it can sometimes be quite misleading  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,956 reads

Treating SQL Server as an Object with PowerShell

It’s easy to use invoke-sqlcmd to send T-SQL statements to SQL Server from PowerShell. There is, however, a rich PowerShell library, sqlps, that can be used instead. In this article, Greg Moore shows how to use sqlps to treat a SQL Server instance as an object.  Read more...
By Additional Articles 2018/12/10 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 647 reads

When a Service Pack or Cumulative Update Install Fails by Evaporating

Learn a few possible solutions to a frustrating issue when you attempt to patch a SQL Server installation.  Read more...
By Mike Hinds 2018/12/07 (first published: 2016/01/11) | Source: SQLServerCentral.com | Category: service packs
Rating: |  Discuss |   Briefcase | 3,183 reads

Automation at Work

The future of work might be a problem if things go as Steve expects.  Read more...
By Steve Jones 2018/12/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 60 reads

Best practices for SQL Provision

In order to get the best out of SQL Provision, it’s a good idea to think about how it would best fit into your workflows and network architecture. We’ve put together a set of guidelines which can help you to optimize efficiency, performance, security, and reliability, and recommend that you consider these when planning a proof-of concept or rollout of SQL Provision in your organization. Read the How To Guide.   Read more...
By 2018/12/07 | Source: Redgate | Category: sql provision
Rating: (not yet rated)  Rate this |   Briefcase | 2,584 reads

How Much Memory is “Normal” for SQL Servers?

When I look at a SQL Server, one of the first things I check is, “How much memory does this thing have relative to the amount of data we’re hosting on here?” I’ve long used some seat-of-the-pants numbers, but armed with data from SQL ConstantCare® users who opted into public data sharing, let’s do a little deeper analysis.  Read more...
By Additional Articles 2018/12/07 | Source: Brent Ozar Unlimited Blog | Category: memory
Rating: (not yet rated)  Rate this |   Briefcase | 3,794 reads

Configuring SQL Server Always on Azure Servers(Iaas)

Configuration of SQL Server Always on in Azure Virtual machines differs in multiple ways comparing with the on-premise Implementations. This article will help you to have a handy note to configure always on in Azure servers from a DBA perspective.  Read more...
By Vishnu Gupthan 2018/12/06 | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 242 reads

Write more compact SQL Server code using new features

Learn about new functions in SQL Server 2016 and 2017 to have more readable and compact code including STRING_AGG, TRIM, TRANSLATE and DROP... IF EXISTS.  Read more...
By Additional Articles 2018/12/06 | Source: MSSQLTips.com | Category: string_ag
Rating: (not yet rated)  Rate this |   Briefcase | 3,241 reads

MoSQL

Google is promoting more RDBMS based systems.  Read more...
By Steve Jones 2018/12/06 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 70 reads

How to reset your development database in seconds using SQL Clone

Let’s say you’re making experimental changes to your development database and, to explore a hypothesis, you’ve just dropped a table. How long does it take you to restore the database to its previous state, so you’re ready to continue testing? If it’s long enough to go fetch a coffee, then it’s too long.  Read more...
By 2018/12/06 | Source: Redgate | Category: sql clone
Rating: (not yet rated)  Rate this |   Briefcase | 2,167 reads

Adding Disks - Level 3 of the Stairway to SQL Server on Linux

In this level we examine how to add disks to separate our data, log, and tempdb files.  Read more...
By Danilo Dominici 2018/12/05 | Source: SQLServerCentral.com | Category: sql server on linux
Rating: |  Discuss |   Briefcase | 227 reads

Lax Security is Harmful for Employment

Data breaches do more than harm an organization. There's a human cost.  Read more...
By Steve Jones 2018/12/05 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 53 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 2018/12/05 (first published: 2013/08/07) | Source: Redgate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 101,520 reads

Transferring Data with JSON in SQL Server

JSON is a viable option for transferring data between systems. It has the ability to include schema information along with the data which is an advantage over CSV files. In this article, Phil Factor demonstrates how he takes advantage of JSON when exporting or importing tables.  Read more...
By Additional Articles 2018/12/05 | Source: SimpleTalk | Category: json
Rating: (not yet rated)  Rate this |   Briefcase | 2,607 reads

Revving the Error

Changing error messages can be problematic at times.  Read more...
By Steve Jones 2018/12/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 44 reads

PackPrecScale CLR function

CLR can be used to pack Precision and Scale of a SqlDecimal  Read more...
By Claude Martel 2018/12/04 | Source: SQLServerCentral.com | Category: clr
Rating: (not yet rated) |  Discuss |   Briefcase | 394 reads

Create, protect and manage non-production databases with SQL Provision

SQL Provision allows teams to create a secure, scalable and repeatable process for managing data as it moves through your SQL Server estate, without causing administrative burdens. To find out more and how it can work alongside your existing database DevOps practices, check out this article.   Read more...
By 2018/12/04 | Source: Redgate | Category: sql provision
Rating: (not yet rated)  Rate this |   Briefcase | 2,040 reads

Overview of Azure SQL Database Information Protection

Information protection becomes one of the dominant factors that drive modern database design and implementation. This becomes particularly evident when operating in a cloud computing environment, with Azure SQL Database serving as one of the prime examples of this trend. Microsoft delivers relevant features by leveraging several different security-related Azure services. In this article, we will provide an overview of this functionality.  Read more...
By Additional Articles 2018/12/04 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 1,723 reads

GitHub Downtime

GitHub experienced downtime and a problem with two nodes of database servers.  Read more...
By Steve Jones 2018/12/03 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 42 reads

Cost estimation for SQL Server Azure VMs

This article provides pricing guidance for SQL Server virtual machines in Azure.  Read more...
By Deepak Prasad Sahu 2018/12/03 | Source: SQLServerCentral.com | Category: azure iaas vm
Rating: |  Discuss |   Briefcase | 534 reads
<< Newer    Items 21 to 40 of 17443    Older >>