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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,903,172 DBAs, developers and SQL Server users

Headlines today   June 25, 2018

Enable FIPS 140-2 Compliance in SQL Server

What is FIPS? How do I use it? What is going to break if I do use it?  Read more...
By Jason Ash 2018/06/25 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 460 reads

Power BI Introduction: Working with Power BI Desktop — Part 2

Power BI Desktop is the free tool from Microsoft for developing in Power BI. In this article, Robert Sheldon walks you through importing and manipulating data with the Query Editor in Power BI Desktop.  Read more...
By Additional Articles 2018/06/25 | Source: SimpleTalk | Category: power bi
Rating: (not yet rated)  Rate this |   Briefcase | 1,266 reads

Receive SQL Server Alerts through Slack

In this tip we look at how we can use Python and SQL Server 2017 to send alerts from SQL Server to Slack messaging service.  Read more...
By Additional Articles 2018/06/25 | Source: MSSQLTips.com | Category: alerts
Rating: (not yet rated)  Rate this |   Briefcase | 1,092 reads

Database subsetting. What it is, what it’s for, and why we’d love to hear from you.

We’re looking into database subsetting, and if you need it or are investigating it, we want to hear from you. Please get in touch below.  Read more...
By 2018/06/25 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 272 reads
Previous headlines

SQL Server Restart or Cluster Failover Notification

How to create an automatic SQL restart or failover notification.  Read more...
By Lori Brown 2018/06/22 (first published: 2015/12/10) | Source: SQLServerCentral.com | Category: clustering
Rating: |  Discuss |   Briefcase | 3,897 reads

In-Memory OLTP – Common Workload Patterns and Migration Considerations

In-Memory OLTP is a high performance, memory-optimized engine integrated into SQL Server 2014 and designed for modern hardware trends. In-Memory OLTP allows users to move data into memory resident tables while keeping other data in traditional, disk-based table structures. For performance critical workloads, users can also migrate Transact-SQL code to natively compiled stored procedures. This can provide additional performance gains. This paper aims to help readers understand some of the common architectural patterns where In-Memory OLTP has provided significant benefits. The paper also discusses considerations for migrating applications to In-Memory OLTP.  Read more...
By Additional Articles 2018/06/22 | Source: Microsoft MSDN | Category: in-memory oltp
Rating: (not yet rated)  Rate this |   Briefcase | 1,713 reads

Demoing Latch Waits with Stupid Tricks

Stuffing table variables with hard-coded values to demonstrate concurrency.  Read more...
By Additional Articles 2018/06/22 | Source: Brent Ozar Unlimited Blog | Category: latching
Rating: (not yet rated)  Rate this |   Briefcase | 1,670 reads

Converting Trace to Extended Events

A walkthrough of a conversion of a SQL Trace setup to an Extended Event session.  Read more...
By Steve Jones 2018/06/21 | Source: SQLServerCentral.com | Category: extended events (xe)
Rating: |  Discuss |   Briefcase | 507 reads

In-Memory OLTP – SQL Server In-Memory OLTP Internals Overview

In-Memory OLTP (project “Hekaton”) is a new database engine component, fully integrated into SQL Server. It is optimized for OLTP workloads accessing memory resident data. In-Memory OLTP allows OLTP workloads to achieve significant improvements in performance, and reduction in processing time. Tables can be declared as ‘memory optimized’ to enable In-Memory OLTP’s capabilities. Memory-optimized tables are fully transactional and can be accessed using Transact-SQL. Transact-SQL stored procedures can be compiled to machine code for further performance improvements on memory-optimized tables. The engine is designed for high concurrency and blocking is minimal.  Read more...
By Additional Articles 2018/06/21 | Source: Microsoft MSDN | Category: in-memory oltp
Rating: (not yet rated)  Rate this |   Briefcase | 2,037 reads

SQL Prompt Hidden Gems: The SSMS Results Pane

Louis Davidson explores the hidden treasures within SQL Prompt right-click context menu when working in the SSMS grid format results pane.  Read more...
By 2018/06/21 | Source: Redgate | Category: sql prompt
Rating: (not yet rated)  Rate this |   Briefcase | 2,479 reads

From the SQLServerCentral Blogs

How to get started with Always Encrypted for Beginners Part 4: Change is Coming

A few weeks ago, I wrote Part 1, 2 and 3 of this series, which was a beginner’s guide to Always Encrypted. In part...  Read more...
By SQLEspresso 2018/06/25 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,433 reads

Information Measurement with SQL Server, Part 4.1: The Kullback-Leibler Divergence

By Steve Bolton …………This informal series of tutorials on how to implement a hodgepodge of information metrics in SQL Server is...  Read more...
By SQLServerSteve 2018/06/25 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,236 reads
Question of the Day

Restore options

By Steve Jones 2018/06/25 | Category: backup and recovery
Rating: (not yet rated) |  Discuss |   Briefcase | 354 reads

I have a job set that makes a backup of my SalesStatistics database every day. The filenames look like SalesStatistics_201806010100.bak and the backup job for this file would have looked...  Read more...
Latest forum posts