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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,895,977 DBAs, developers and SQL Server users

Rss
Headlines today   January 16, 2018

Disk Encryption and The Impact to DBAs

As security threats proliferate, the need for encryption will continue to rise. We who are the Guardians of the Data must be ready to make SQL Server respond and to manage the performance issues that are inherent in every data encryption solution.  Read more...
By John F. Tamburo 2018/01/16 | Source: SQLServerCentral.com | Category: encryption
Rating: |  Discuss |   Briefcase | 582 reads

Step by Step Guide to Migrate SQL Server Data to SQL Server 2017

This step by step approach explains how to assess your SQL Server migration using DMA. Learn how to understand the behavior of your existing version and what changes need to be made to migrate to a newer version of SQL Server.  Read more...
By 2018/01/16 | Source: SimpleTalk | Category: sql server 2017
Rating: (not yet rated)  Rate this |   Briefcase | 2,088 reads

NEW – Create, protect and manage non-production databases with SQL Provision

Redgate's newest offering helps address data privacy and protection concerns by creating copies of SQL Server databases that mask all sensitive data. SQL Provision serves as a gateway between production and non-production environments, to ensure the safe distribution of database copies from one central location, without blocking the team’s development and release processes.  Read more...
By 2018/01/16 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,010 reads
Previous headlines

Install Visual Studio 2015 in Server without Internet Connection

Install Visual Studio 2015 in Windows Server without Internet Connection  Read more...
By Vishnu Gupthan 2018/01/15 | Source: SQLServerCentral.com | Category: visual studio
Rating: |  Discuss |   Briefcase | 372 reads

SQL Server Machine Learning Services – Part 2: Python Data Frames

SQL Server Machine Learning Services provides the ability to run Python scripts directly against data in SQL Server. To do so, you must understand how to work with the data frame object. Robert Sheldon explains how to get started using the data frame object, how to pass data from SQL Server to it, and how to manipulate it with Python and pandas commands.  Read more...
By 2018/01/15 | Source: SimpleTalk | Category: machine learning services (mls)
Rating: (not yet rated)  Rate this |   Briefcase | 2,185 reads

How to automatically provision sanitized data using SQL Clone, Data Masker, and PowerShell

This article describes a strategy, using data masking, cloned databases, and PowerShell, which will allow you to sanitize data before it is copied or moved, for example from a production environment into testing or development environments.  Read more...
By 2018/01/15 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,505 reads

Binary Files Import and Export

Importing binary files is always a challenge in SQL Server. New Author Sergey Benner brings us a technique using bulk loading that has worked well for him.  Read more...
By Sergey Benner 2018/01/12 (first published: 2008/08/28) | Source: SQLServerCentral.com | Category: bcp
Rating: |  Discuss |   Briefcase | 9,635 reads

Finding code smells using SQL Prompt: procedures that lack schema-qualification

It is a very good idea to get into the habit of qualifying the names of procedures with their schema. It is not only makes your code more resilient and maintainable, but as Microsoft introduces new features that use schemas, such as auditing mechanisms, you code contains no ambiguities that could cause problems.  Read more...
By 2018/01/12 | Source: Redgate | Category: redgate
Rating:  Rate this |   Briefcase | 2,260 reads

SQL Server 2017 and Python Basics

This tutorial from Siddharth Mehta is intended to help experienced T-SQL Developers, DBAs, Data Analysts and Data Science enthusiasts to start using Python language with T-SQL.   Read more...
By 2018/01/12 | Source: MSSQLTips.com | Category: python
Rating: (not yet rated)  Rate this |   Briefcase | 2,995 reads

GDPR - A guide for the perplexed

If a picture paints a thousand words then can GDPR regulation be represented in diagram form? Could doing so make it easier to comply with the regulation by making it easier to understand?  Read more...
By David Poole 2018/01/11 | Source: SQLServerCentral.com | Category: gdpr
Rating: |  Discuss |   Briefcase | 1,224 reads
 

From the SQLServerCentral Blogs

Azure SQL Database – Optimizing For Ad-hoc Workloads

Today I found out that it is now possible to enable the setting optimize for ad-hoc workloads at the database...  Read more...
By Arun Sirpal 2018/01/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 871 reads

SQL Server on TLS 1.2: Checklist to disabling TLS 1.1 and 1.0

A common finding in security audits these days is the failure to conduct all communications via TLS 1.2. (Correspondingly, a...  Read more...
By willassaf@gmail.com 2018/01/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,243 reads
Question of the Day

Getting the Create Date

By Steve Jones 2018/01/16 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 451 reads

I've run this code to get information for a database into a variable.


$db = Get-SqlDatabase -ServerInstance SQL01\SQL2016 -Name Sales
Now I want to display the create date for this database as...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
43416 546356 SSC Guru  
2.
Jeff Moden
40682 504703 SSC Guru  
3.
Steve Jones - SSC Editor
24777 327645 SSC Guru  
4.
Lynn Pettis
18490 222678 SSC Guru  
5.
Grant Fritchey
18254 220536 SSC Guru  
Latest forum posts