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

Headlines today   June 21, 2018

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 | 178 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 | 690 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 | 852 reads
Previous headlines

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2018/06/20 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 75,440 reads

Welcome to the new world of curating data, not owning it

Faced with the new challenges of data protection – and increased levels of oversight – many of us working with SQL Server have come to the same conclusion. Quite simply, the column names and free text descriptions available to us to describe the data in our care (or data-containing artefacts like columns, tables and databases) are no longer sufficient.  Read more...
By 2018/06/20 | Source: Redgate | Category: data privacy and protection
Rating: (not yet rated)  Rate this |   Briefcase | 1,329 reads

SQL Server Database Corruption Detection

How to detect DB corruption ASAP... 
By Pauline Xiong 2018/06/19 | Source: SQLServerCentral.com | Category: corruption
Rating: |  Discuss |   Briefcase | 759 reads

Reducing risk with Smart Recommendations in SQL Census

Redgate are reducing risk with Smart Recommendations in SQL Census  Read more...
By 2018/06/19 | Source: Redgate | Category: data security
Rating: (not yet rated)  Rate this |   Briefcase | 1,112 reads

Databases with MAXSIZE Set

Every DBA needs to appropriately manage database growth. No DBA wants an application to fail because the database is out of space. A database can run out of space a number of different ways. One of those ways is to set the MAXSIZE of a database. When the database grows to the MAXSIZE the database will not grow anymore and if someone tries to add more rows they will get an error saying the database is full.  Read more...
By Additional Articles 2018/06/19 | Source: Database Journal | Category: ms sql
Rating: (not yet rated)  Rate this |   Briefcase | 1,311 reads

Jobs You Wouldn't Expect To Be Threatened By Tech But Are

Will there be a fair balance between the coming generations of technology and the human workforce? Here is a list of industries that may not think yes.   Read more...
By Donna Morgese 2018/06/18 | Source: SQLServerCentral.com | Category: ai
Rating: |  Discuss |   Briefcase | 1,407 reads

From the SQLServerCentral Blogs

Two Types of Performance Counters

I had an issue where an instance of SQL Server was only showing the XTP (In Memory) performance counters. None...  Read more...
By Steve Jones 2018/06/21 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,435 reads

Prioritizing Index Performance Pains – What I Learned From Brent Ozar’s Master Index Tuning Class

I love continuing my education in SQL Server.  Recently I was fortunate enough to take Brent Ozar’s 3-day live online...  Read more...
By Bert Wagner 2018/06/21 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,283 reads
Question of the Day

Azure Data Factory

By Henrico Bekker 2018/06/21 | Category: ssis
Rating: (not yet rated) |  Discuss |   Briefcase | 202 reads

When executing a SSIS package in Azure Data Factory, the package requires conversion or execution in 64bit.

Latest forum posts