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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,911,531 DBAs, developers and SQL Server users

Headlines today   January 22, 2019

Creating and using inline table-valued functions

Inline Table Valued Functions (iTVFs) are one type of user defined function that is available to implement in SQL Server since SQL Server 2000. iTVFs remain a very useful tool in our SQL armoury, so let's quickly revisit them and the different ways we can use them in our code.   Read more...
By Kimani Mbugua 2019/01/22 | Source: SQLServerCentral.com | Category: tsql
Rating: |  Discuss |   Briefcase | 146 reads

The 2019 State of Database DevOps

All the latest insights on DevOps adoption rates among SQL Server Professionals, with a foreword from Donovan Brown Principal DevOps Manager at Microsoft. Read the report to understand the challenges – and the opportunities – of adopting database DevOps alongside broader DevOps initiatives  Read more...
By 2019/01/22 (first published: 2019/01/14) | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 1,283 reads

Customizing the Default Azure Data Studio Dashboards

Explore the Azure Data Studio dashboards and see how to customize one of these dashboards to include a new widget.  Read more...
By Additional Articles 2019/01/22 | Source: Database Journal | Category: azure data studio
Rating: (not yet rated)  Rate this |   Briefcase | 469 reads
Previous headlines

The SQL Server LAG Function

The LAG function can really improve performance over the old double JOIN.  Read more...
By Mike Byrd 2019/01/21 (first published: 2019/01/14) | Source: SQLServerCentral.com | Category: lag function
Rating: |  Discuss |   Briefcase | 1,181 reads

Creating Measures Using DAX

In the first article in this series, Andy Brown demonstrated how to create calculated columns in Power BI using the DAX language. This second article in the series explains what measures are, and how you can use DAX to create measures within Power BI. The formulae in the article apply equally well to PowerPivot and Analysis Services Tabular Model.  Read more...
By Additional Articles 2019/01/21 | Source: SimpleTalk | Category: dax
Rating: (not yet rated)  Rate this |   Briefcase | 1,346 reads

The 4 capabilities you need to introduce true database DevOps

The latest Accelerate State of DevOps Report from DORA concludes that successful software delivery unlocks competitive advantages, including “increased profitability, productivity, market share, customer satisfaction and the ability to achieve organizational and mission goals”. The result of over five years of research with over 30,000 data points, it shows a direct correlation between DevOps and better business performance.  Read more...
By 2019/01/21 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 1,329 reads

Manipulating Filetable Files Programatically

Learn how you can work with FileTable files from T-SQL as an alternative to the drag and drop methods of using Windows Explorer  Read more...
By Steve Jones 2019/01/18 (first published: 2016/01/28) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,875 reads

Do Functions Stop You From Using Indexes?

If you have a function in the WHERE clause, you might have heard you can't use indexes. That's not entirely correct.  Read more...
By Additional Articles 2019/01/18 | Source: Brent Ozar Unlimited Blog | Category: where clause
Rating: (not yet rated)  Rate this |   Briefcase | 2,646 reads

Logging SQL and Change-Tracking Events in EF Core

Julie Lerman introduces you to the new logging APIs in .NET Core, concentrating on SQL and change-tracking events, with a focus on providers that output to the console and the debugger.  Read more...
By Additional Articles 2019/01/18 | Source: Microsoft MSDN | Category: entity framework
Rating: (not yet rated)  Rate this |   Briefcase | 1,586 reads

Getting started with SQL 2019 big data cluster in Azure

Installing and connecting to SQL 2019 big data cluster  Read more...
By Blesson John 2019/01/17 | Source: SQLServerCentral.com | Category: big data cluster
Rating: (not yet rated) |  Discuss |   Briefcase | 329 reads

From the SQLServerCentral Blogs

SQL Server Monitoring: What to start measuring

So you’ve got a SQL Server that you want to monitor. What should you monitor? In my opinion, at bare...  Read more...
By jbookster 2019/01/22 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,047 reads

Availability Groups: When Your Synchronous Secondary isn’t Synchronous

During a recent DR scenario I came across a slight misinterpretation in how availability groups with replicas in synchronous commit...  Read more...
By david.fowler 42596 2019/01/22 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 956 reads
Question of the Day


By Steve Jones 2019/01/22 | Category: buffer pool extensions (bpe)
Rating: (not yet rated) |  Discuss |   Briefcase | 94 reads

I have a SQL Server 2016 instance on Windows and want to enable the buffer pool extension option on my instance. How do I do this?

Latest forum posts