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,498 DBAs, developers and SQL Server users

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,172 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,772 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,347 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,072 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 | 148 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,621 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,917 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,122 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,329 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,882 reads
 

Question of the Day

Changing the BPE size

By Steve Jones 2019/02/15 | Category: buffer pool extensions (bpe)
Rating: (not yet rated) |  Discuss |   Briefcase | 301 reads

I have the Buffer Pool Extension enabled and set on my instance. Currently I have a 58GB setting for max server memory and a 100GB file set for BPE. I...  Read more...
Latest forum posts