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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,900,131 DBAs, developers and SQL Server users

Headlines today   April 25, 2018

Stairway to SQL PowerShell Level 10: Getting data in and out of SQL Server using SQL Server PowerShell

In this level we will look at ways of getting data into and out of SQL Server. We will specifically look at the Database object and a cmdlet Invoke-Sqlcmd or Invoke-SqlCmd2. To get data in, we are going to leverage a PowerShell script that uses SMO to put data into a predefined table in SQL Server.  Read more...
By Ben Miller 2018/04/25 (first published: 2015/12/02) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,454 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's 2016 In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.  Read more...
By Press Release 2018/04/25 (first published: 2015/05/13) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 46,464 reads

SQL Server Graph Databases – Part 3: Modifying Data in a Graph Database

Modifying data in Graph Database tables is similar to working with traditional tables, but there are several things to consider. Robert Sheldon explains how to insert, update, and delete rows of Graph Database tables and explains how to use several new helper functions.  Read more...
By Additional Articles 2018/04/25 | Source: SimpleTalk | Category: sql server graph database
Rating: (not yet rated)  Rate this |   Briefcase | 1,191 reads

Shift LEFT magazine: Issue 3

The latest issue of Redgate’s Database DevOps magazine explores the benefits of DevOps for CEOs, CIOs, and IT Managers, and takes a comprehensive look at the new General Data Protection Regulation, providing a valuable insight into how organizations can meet its demands.  Read more...
By 2018/04/25 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 1,167 reads
Previous headlines

Packaged-Application Database Nightmares - A Horror Story

The business decides on a packaged application and buys it. After installation, you look at the schema and realize that is is a nightmare. How do you manage this nightmare?  Read more...
By John F. Tamburo 2018/04/24 (first published: 2015/12/22) | Source: SQLServerCentral.com | Category: packaged applications
Rating: |  Discuss |   Briefcase | 5,087 reads

Approaches to masking email addresses

There are several ways to to anonymize / pseudonymize email addresses. This post discusses a few frequently used approaches, as well as how you can use Redgate Data Masker for SQL Server to achieve realistic masking of email columns.  Read more...
By 2018/04/24 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 1,847 reads

Alerts and Notfications for SQL Server Login, Database User and Role Membership Changes

Check out these scripts to create SQL Server jobs and Alerts when a login is created or dropped, a database user is added or dropped and when logins are added or removed from server roles or users are added or removed from database roles.  Read more...
By Additional Articles 2018/04/24 | Source: MSSQLTips.com | Category: alerts
Rating: (not yet rated)  Rate this |   Briefcase | 1,935 reads


A fun experiment using DBCC SHRINKFILE to rebalance data.  Read more...
By Steve Jones 2018/04/23 | Source: SQLServerCentral.com | Category: dbcc shrinkfile
Rating: |  Discuss |   Briefcase | 709 reads

How to Programmatically Identify When Your SQL Server Was Last Started

Greg Larsen shows you a quick trick to programmatically script a way to identify when SQL Server was last started.  Read more...
By Additional Articles 2018/04/23 | Source: Database Journal | Category: administration
Rating:  Rate this |   Briefcase | 2,660 reads

Spring into the Latest Features at the Luxemborg User Group

The next meeting of the Luxemborg SQL Server User Group has some great sessions planned.  Read more...
By Additional Articles 2018/04/23 | Source: SQLServerCentral.com | Category: user groups
Rating: |  Discuss |   Briefcase | 65 reads

From the SQLServerCentral Blogs

Exploring the Caves of Code Analysis in #SQLPrompt

I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes...  Read more...
By Steve Jones 2018/04/25 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,385 reads

In-Memory OLTP: A Case Study

Watch this week’s episode on YouTube. When In-Memory OLTP was first released in SQL Server 2014, I was excited to start...  Read more...
By Bert Wagner 2018/04/25 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,862 reads
Question of the Day

Mutable Objects

By Steve Jones 2018/04/25 | Category: python
Rating: (not yet rated) |  Discuss |   Briefcase | 414 reads

I have this code in Python:

>>> i = [1,2,3]
>>> j = i

If I now do this, what is returned?

>>> i[1] = 4
>>> print(j)
Latest forum posts