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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,912,534 DBAs, developers and SQL Server users

Rss
Headlines today   February 18, 2019

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,578 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 | 1,337 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 | 962 reads
Previous headlines

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,246 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,036 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,503 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,113 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 | 157 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,745 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,029 reads
 

From the SQLServerCentral Blogs

Data Warehousing Tip #6 – Use a consistent unknown member key

In this article I’ll be discussing the benefits of using a consistent unknown member key across your data warehouse.  And...  Read more...
By ChrisJenkins 2019/02/18 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,315 reads

Disabling Indexes

Indexes are probably the number one tool we have to improve performance. That said, there are times when we want...  Read more...
By Kenneth Fisher 2019/02/18 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,783 reads
Question of the Day

Stored Procedure Parameters

By Steve Jones 2019/02/18 | Category: stored procedures
Rating: (not yet rated) |  Discuss |   Briefcase | 356 reads

In SQL Server 2017, what is the most number of parameters we can use in a stored procedure?

  Read more...
Latest forum posts