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

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

SQL Source Control v7 Enhancements

With the v7 release, SQL Source Control now enforces Git hooks, and provides full support for working with Git repositories hosted on Azure DevOps. It also comes with pre- and post-deployment scripts to make it easier to automate the build and deploy new database versions to your pre-production or production servers. Finally, the latest release continues SQL Source Control’s long-standing commitment to keep pace with SSMS improvements, with support for the public preview of SSMS 18.  Read more...
By 2019/02/18 | Source: Redgate | Category: sql source control
Rating: (not yet rated)  Rate this |   Briefcase | 2,209 reads

Using the DAX Calculate and Values Functions

In the first two articles in this series on creating DAX formulae, Andy Brown of Wise Owl Training showed how to create calculated columns and measures. In this third article, he turns his attention to two of the most important DAX functions (CALCULATE and VALUES), showing how and when to use them. If DAX knowledge can be compared to a heavily fortified castle, the CALCULATE function is the drawbridge giving access to it.  Read more...
By Additional Articles 2019/02/18 | Source: SimpleTalk | Category: dax
Rating: (not yet rated)  Rate this |   Briefcase | 1,915 reads

Using Power BI and SSRS for visualizing SQL Server and R data (Part 4)

Using R with Power BI, SSRS or RTVS for easier data visualization  Read more...
By Tomaž Kaštrun 2019/02/15 (first published: 2017/01/24) | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 2,360 reads

A Supercomputer in My Pocket

Modern smartphones are incredible for Steve from a data perspective.  Read more...
By Steve Jones 2019/02/15 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 42 reads

Script to Run DBCC CheckDB on Alternate SQL Server to Reduce Load on Primary Server

In this tip we look at some scripts you can use to automate running your DBCC CheckDBs on an alternate SQL Server instance.  Read more...
By 2019/02/15 | Source: MSSQLTips.com | Category: dbcc checkdb
Rating:  Rate this |   Briefcase | 2,520 reads

SQL Provision and Azure SQL Database

More and more businesses already use, or plan to use, cloud-based infrastructure (PaaS) as their primary database solution. However, they still need to support on-premise or Infrastructure as a Service (IaaS) VM-based workflows for Development and Test Databases, and this is a perfect task for SQL Provision and Azure SQLDB.  Read more...
By 2019/02/15 | Source: Redgate | Category: sql provision
Rating: (not yet rated)  Rate this |   Briefcase | 1,773 reads

Someone Lost My Data

A problem in Azure resulted in a few databases being deleted.  Read more...
By Steve Jones 2019/02/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 47 reads

SQL Server Trace Flags - Complete list

This article is a complete list of all SQL Server trace flags - 593 trace flags.  Read more...
By Konstantin Taranov 2019/02/14 (first published: 2017/02/23) | Source: SQLServerCentral.com | Category: trace-flag
Rating: |  Discuss |   Briefcase | 5,196 reads

Why Redgate is Running a Database Development Disasters Contest?

Kendra Little explains why Redgate would like to hear your stories of how the database has been left behind.   Read more...
By Kendra.Little 2019/02/14 | Source: SQLServerCentral.com | Category: redgate
Rating: (not yet rated) |  Discuss |   Briefcase | 167 reads

Using the DAX Calculate and Values Functions

In the first two articles in this series on creating DAX formulae, Andy Brown of Wise Owl Training showed how to create calculated columns and measures. In this third article, he turns his attention to two of the most important DAX functions (CALCULATE and VALUES), showing how and when to use them. If DAX knowledge can be compared to a heavily fortified castle, the CALCULATE function is the drawbridge giving access to it.  Read more...
By 2019/02/14 | Source: SimpleTalk | Category: dax
Rating: (not yet rated)  Rate this |   Briefcase | 2,073 reads

How to Apply Non-Standard SQL Formatting Using SQL Prompt

Like any good tool, SQL Prompt not only will format your code for you, but will also help you to format the code in an alternative manner, or to apply exceptions to certain parts of a SQL script, where the formatting applies by the current style isn't what's required.  Read more...
By 2019/02/14 | Source: Redgate | Category: sql prompt
Rating: (not yet rated)  Rate this |   Briefcase | 2,287 reads

Google's Expensive Confusing Rules

Google was recently fined for GDPR violations. Steve wonders if their confusing documentation and tools are the problem.  Read more...
By Steve Jones 2019/02/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 44 reads

Stairway to Server Management Objects (SMO) Level 1: Concepts and Basics

Learn how to get started working with SMO and PowerShell.  Read more...
By Laerte Junior 2019/02/13 (first published: 2016/05/11) | Source: SQLServerCentral.com | Category: smo
Rating: |  Discuss |   Briefcase | 4,167 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 2019/02/13 (first published: 2013/08/07) | Source: Redgate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 103,526 reads

SQL Server Perfmon counters that are still interesting in 2019

Years ago, my first go-to tool for performance tuning was Performance Monitor: it was available everywhere, worked in all versions, and gave me a lot of useful information without paying for a monitoring tool. Since then, I’ve moved on – wait stats are a much better starting point – but there are still 3 good Perfmon counters that I rely on.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,286 reads

Provisioning Multiple Masked Databases

Addressing common challenges, Redgate’s Chris Unwin explains how to create multiple masked copies of a database, delivered as a group with SQL Provision.   Read more...
By 2019/02/13 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 1,680 reads

Hard Drive Reliability

Backblaze releases their new hard drive stats and there are some interesting items in the report.  Read more...
By Steve Jones 2019/02/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 38 reads

Using Computed Columns

Although computed columns are from the beginning of SQL Server, not everyone knows how to use them. This article will help you better understand how it works.  Read more...
By Luis Martin 2019/02/12 | Source: SQLServerCentral.com | Category: computed columns
Rating: |  Discuss |   Briefcase | 991 reads

The Whys and Wherefores of Untrusted or Disabled Constraints

Phil Factor explains what causes this issue, the problems it will cause and how to avoid the problem  Read more...
By 2019/02/12 | Source: Redgate | Category: sql prompt
Rating: (not yet rated)  Rate this |   Briefcase | 1,976 reads

Infrastructure Planning for a SQL Server Data Warehouse

In this tip we look at some things you should think about when planning for a SQL Server data warehouse.  Read more...
By Additional Articles 2019/02/12 | Source: MSSQLTips.com | Category: data warehouse
Rating: (not yet rated)  Rate this |   Briefcase | 2,732 reads
<< Newer    Items 21 to 40 of 17655    Older >>