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

Headlines today   June 18, 2018

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,122 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,043 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 | 989 reads
Previous headlines

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,173 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 | 3,622 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,191 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 | 366 reads

Why you should automate your release pipeline

As the trend in development shifts toward more agile delivery, and customers clamor for continuous deployment, this model of monolithic code releases begins to strain. Automating your release pipeline can cut down on your release cycle time and alleviate many of the Release Day issues that arise from still trying to manually deploy code.  Read more...
By 2018/06/14 | Source: Redgate | Category: release management
Rating: (not yet rated)  Rate this |   Briefcase | 1,886 reads

Using Regular Expressions With T-SQL: From Beginner To Advanced

Its possible to use some comparable expressions to a full regular expression library for matching certain patterns with T-SQL using the like operator. This tutorial uses these expressions for filtering price phrases involving alphabetic, numeric, and special characters  Read more...
By Additional Articles 2018/06/14 | Source: MSSQLTips.com | Category: expressions
Rating:  Rate this |   Briefcase | 3,471 reads

Stairway to Azure SQL Database: Level 1 Getting Started

In this first level, learn how to get started with Azure and Azure SQL Database.  Read more...
By Arun Sirpal 2018/06/13 | Source: SQLServerCentral.com | Category: azure sql database
Rating: |  Discuss |   Briefcase | 620 reads

From the SQLServerCentral Blogs

Power BI Monthly Digest – June 2018

This month I continued my series with my friend Manuel Quintana [Blog | Twitter] as we guide you through some of...  Read more...
By Devin Knight 2018/06/18 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,603 reads

WSFC Lost Quorum votes due to network problem

Problem: Early in the morning I received emails requesting for support as the applications were failing to connect to one of...  Read more...
By araujo.christian 2018/06/18 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,809 reads
Question of the Day


By Raghavender Chavva 2018/06/18 | Category: authentication
Rating: (not yet rated) |  Discuss |   Briefcase | 445 reads

In SSMS v1.7, how many types of authentication for a SQL Server are allowed?

Latest forum posts