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

   Items 1 to 20 of 17638    Older >>
 

GDPR - A guide for the perplexed

If a picture paints a thousand words then can GDPR regulation be represented in diagram form? Could doing so make it easier to comply with the regulation by making it easier to understand?  Read more...
By David Poole 2019/02/18 (first published: 2018/01/11) | Source: SQLServerCentral.com | Category: gdpr
Rating: |  Discuss |   Briefcase | 2,186 reads

We Want Maturity, But Is It Fun?

By Andy Warren 2019/02/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 148 reads

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 | 558 reads

You Need Offline Backups

Steve talks about the need to be careful with backups in this age of malicious attackers.  Read more...
By Steve Jones 2019/02/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 6 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 | 364 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,219 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 | 26 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 | 1,934 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,461 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 | 38 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,093 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 | 151 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 | 1,700 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 | 1,976 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 | 40 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,128 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,359 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 | 1,942 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,375 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 | 37 reads
   Items 1 to 20 of 17638    Older >>