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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,897,504 DBAs, developers and SQL Server users

Rss
Headlines today   February 20, 2018

Solve Sudoku with T-SQL - Part 1

A Sudoku solution can be resolved using a single select statement. The first article shows this method and next how this can be optimised to resolve complex puzzles in seconds.  Read more...
By bevan ward 2018/02/20 | Source: SQLServerCentral.com | Category: tsql
Rating: |  Discuss |   Briefcase | 1,320 reads

How to Move a TDE Encryption Key to Another SQL Server Instance

If you have a database backup of a Transparent Data Encryption (TDE) enabled database, the database backup will contain encrypted data. Because the database backup contains encrypted data you can’t just restore it to any instance. You can only restore the database backup to an instance that contains the same certificate used to originally encrypt the database.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,424 reads

Sign up for more free training from Redgate

Redgate has committed to hosting a free virtual event in every quarter of 2018, and will be kicking this off on February 28 with a livestream themed around data privacy and protection. The agenda has now been released, so you can see who will be presenting, what they will be presenting, and how you can tune in to watch.  Read more...
By 2018/02/20 | Source: Redgate | Category: event
Rating: (not yet rated)  Rate this |   Briefcase | 1,519 reads
Previous headlines

Implementing John Conway's Game of Life in Microsoft SQL Server

A fun exercise, using CTEs to implement John Conway's Game of Life cellular automata simulation  Read more...
By Paul Chang 2018/02/19 (first published: 2015/09/22) | Source: SQLServerCentral.com | Category: cte
Rating: |  Discuss |   Briefcase | 5,607 reads

Questions about Data Governance that You Were Too Shy to Ask

A company’s data is one of its most valuable and important resources. Managing and protecting that data are big responsibilities, and a data governance processes must be put into place to avoid misuse and to meet regulations. In this article, William Brewer answers questions you may have about data governance but were too shy to ask.  Read more...
By Additional Articles 2018/02/19 | Source: SimpleTalk | Category: data governance
Rating: (not yet rated)  Rate this |   Briefcase | 2,034 reads

How to reformat a database in one operation

Inherited a database from another team? Changed your team policy on the way that you format SQL? What’s to stop you formatting the code of an entire database nicely, when you’re developing it? It can be done, but the process can take longer than you expect. This article will demonstrate a simple 3-step approach to reformatting a whole database to your standard, in a single operation, using SQL Compare and SQL Prompt.  Read more...
By 2018/02/19 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,326 reads

Autogenerating SSIS file import packages using Biml

Tired of building tons of similar SSIS packages for importing files into your data warehouse? Learn how to autogenerate them using Biml.  Read more...
By Johan Åhlén 2018/02/16 (first published: 2015/09/10) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 5,823 reads

An Easier Way of Pivoting Data in SQL Server

There are several methods to pivot, or transpose, data in T-SQL, but most are difficult to understand and write. Phil Factor demonstrates how to take advantage of JSON support, introduced with SQL Server 2016, to create a function that makes pivoting data simple.  Read more...
By 2018/02/16 | Source: SimpleTalk | Category: pivoting
Rating:  Rate this |   Briefcase | 4,095 reads

Right-sizing for a cloud service

When it’s time to purchase new resources for one or more applications, the non-scientific approach of guesstimating the requirements can be expensive, whether for on-premises capital expenditures or cloud-based services.  Read more...
By 2018/02/16 | Source: Redgate | Category: cloud
Rating: (not yet rated)  Rate this |   Briefcase | 1,909 reads

Azure DWH part 26: Creating your ASDW in Cloud Shell using PowerShell

In this article, we will show how to create an ASDW in PowerShell using the Cloud Shell.  Read more...
By Daniel Calbimonte 2018/02/15 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 187 reads
 

From the SQLServerCentral Blogs

Power BI Custom Visuals Class (Module 89 – Filter by List)

In this module you will learn how to use the Filter by List Custom Visual. The Filter by List allows...  Read more...
By Devin Knight 2018/02/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,705 reads

gdpr - panic part 4

In the first part of this series, we looked at where to find out more information about GDPR in the...  Read more...
By Ed Elliott 2018/02/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,506 reads
Question of the Day

The Max SESSION_CONTEXT()

By Steve Jones 2018/02/20 | Category: session_context()
Rating: (not yet rated) |  Discuss |   Briefcase | 362 reads

I want to set some session key-value pairs using sp_set_session_context. Since this might be used in a number of places in my application, I'm concerned that developers might set too...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
35413 589144 SSC Guru  
2.
Jeff Moden
31425 542495 SSC Guru  
3.
Steve Jones - SSC Editor
19539 351070 SSC Guru  
4.
Grant Fritchey
14888 238363 SSC Guru  
5.
Lynn Pettis
13936 239502 SSC Guru  
Latest forum posts