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

Rss
Headlines today   February 19, 2018

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,269 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 | 1,082 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 | 1,291 reads
Previous headlines

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,750 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 | 3,561 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,599 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 | 178 reads

How to Test SQL Server Functions and Procedures using SQL Prompt

When writing functions or procedures, a common chore is to devise and implement the tests that ensure that the routine always works as expected.  Read more...
By 2018/02/15 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,554 reads

When Does Index Size Change Index Choice?

Erik purposely fragments indexes trying to slow down queries.  Read more...
By Additional Articles 2018/02/15 | Source: Brent Ozar Unlimited Blog | Category: indexes
Rating: (not yet rated)  Rate this |   Briefcase | 2,312 reads

Calculating DTU's for Azure SQL Database

This calculator will help you determine the number of DTUs for your existing SQL Server database(s) as well as a recommendation of the minimum performance level and service tier that you need before you migrate to Azure SQL Database.  Read more...
Rating: |  Discuss |   Briefcase | 498 reads
 

From the SQLServerCentral Blogs

Connecting to a SQL Server instance – Back to Basics

Back to the SQL Server Basics with Wayne Connecting to a SQL Server instance is one of the first things that...  Read more...
By Wayne Sheffield 2018/02/19 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,456 reads

Moving Lookup Data with ReadyRoll

I’ve been using ReadyRoll for a small project and wanted to move some lookup data. There are some tables where...  Read more...
By Steve Jones 2018/02/19 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,108 reads
Question of the Day

@@OPTIONS

By Steve Jones 2018/02/19 | Category: set options
Rating: (not yet rated) |  Discuss |   Briefcase | 373 reads

If I run this code, what is returned?

SELECT @@OPTIONS
  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
37290 587269 SSC Guru  
2.
Jeff Moden
33054 540771 SSC Guru  
3.
Steve Jones - SSC Editor
20508 350074 SSC Guru  
4.
Grant Fritchey
15257 237246 SSC Guru  
5.
Lynn Pettis
14713 238809 SSC Guru  
Latest forum posts