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

Rss
Headlines today   June 20, 2018

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,065 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 | 882 reads
Previous headlines

SQL Server Database Corruption Detection

How to detect DB corruption ASAP...  Read more...
By Pauline Xiong 2018/06/19 | Source: SQLServerCentral.com | Category: corruption
Rating: |  Discuss |   Briefcase | 712 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 | 985 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,171 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,375 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,595 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,581 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,300 reads
 

From the SQLServerCentral Blogs

What is an Event-Less Extended Event Session?

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...  Read more...
By 2018/06/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,092 reads

Understanding Cosmos DB

Cosmos DB is an awesome product that is mainly used for large-scale OLTP solutions.  Any web, mobile, gaming, and IoT application that...  Read more...
By James Serra 2018/06/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,742 reads
Question of the Day

Python Collections

By Steve Jones 2018/06/20 | Category: python
Rating: (not yet rated) |  Discuss |   Briefcase | 428 reads

Which of these are true about lists, tuples, and dictionaries? (choose 3)

  Read more...
Latest forum posts