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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,902,971 DBAs, developers and SQL Server users

Headlines today   June 19, 2018

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 | 644 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 | 864 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,025 reads
Previous headlines

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,345 reads

Idle Connection Resiliency

Describes the idle connection resiliency feature, which allows ODBC and SqlClient data access applications to maintain their connections to SQL Server 2014 or an Azure SQL Database.  Read more...
By Additional Articles 2018/06/18 | Source: Microsoft MSDN | Category: odbc
Rating: (not yet rated)  Rate this |   Briefcase | 1,509 reads

Hyper-V and PowerShell: Shielded Virtual Machines

In Windows Server 2016, Microsoft have implemented a strong security concept called Shielded Virtual Machines. Shielded VMs have been improved in the Windows Server 2019 release. In the second part of this series, Nicolas describes what Shielded Virtual Machines are and how to configure them using PowerShell.  Read more...
By Additional Articles 2018/06/18 | Source: SimpleTalk | Category: hyper-v
Rating: (not yet rated)  Rate this |   Briefcase | 1,498 reads

Splitting Strings in SQL Server 2016

Comparison of the new methods of splitting strings in SQL Server 2016 to the tried and true methods  Read more...
By Wayne Sheffield 2018/06/15 (first published: 2016/04/12) | Source: SQLServerCentral.com | Category: string_split
Rating: |  Discuss |   Briefcase | 5,272 reads

How to Tell If Your SQL Server Has Too Much Memory

Brent shows what Perfmon counter to watch after your SQL Server restarts.  Read more...
By Additional Articles 2018/06/15 | Source: Brent Ozar Unlimited Blog | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 4,066 reads

Finding code smells using SQL Prompt: Asterisk in SELECT list

In this article Phil Factor explains how to find code smells using SQLPrompt: Asterisk in SELECT list  Read more...
By 2018/06/15 | Source: Redgate | Category: sql prompt
Rating:  Rate this |   Briefcase | 2,466 reads

SQL Server From .Net: Reading SQL Server Metadata in ADO.Net

A basic introduction for developers (or anyone) about reading the metadata of a SQL Server database from a .Net application.  Read more...
By Tim Wellman 2018/06/14 | Source: SQLServerCentral.com | Category: ado.net
Rating: |  Discuss |   Briefcase | 393 reads

From the SQLServerCentral Blogs

Plan Metrics Without the Plan: Trace Flag 7412

I place a lot of emphasis on capturing actual execution plans because of the runtime metrics, but with Trace Flag...  Read more...
By Grant Fritchey 2018/06/19 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,188 reads

Changing the Collation of the Instance, the Databases, and All Columns in All User Databases: What Could Possibly Go Wrong?

Demystifying What “sqlservr -q” Actually Does (last updated on 2018-06-19) For various reasons, people sometimes find themselves in the unfortunate (and unenviable)...  Read more...
By Solomon Rutzky 2018/06/19 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,856 reads
Question of the Day

All the memory

By Steve Jones 2018/06/19 | Category: memory
Rating: (not yet rated) |  Discuss |   Briefcase | 502 reads

My SQL Server 2017 instance is a busy system with a high workload. I have 64GB of RAM on the host. What should I set SQL Server to use for...  Read more...
Latest forum posts