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 21, 2018

Stairway to Database Design Level 9: Normalization

In the final step of Database Design, Joe Celko gives a simple but effective explanation of the normalization process and why it is important.  Read more...
By Joe Celko 2018/02/21 (first published: 2011/11/11) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 12,038 reads

Free eBook: SQL Server Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.  Read more...
By Press Release 2018/02/21 (first published: 2013/08/14) | Source: Redgate | Category: transaction log
Rating:  Rate this |   Briefcase | 91,697 reads

SQL Server Reporting Services 2017 Tutorial

SQL Server Reporting Services has been the go to reporting solution for SQL Server for almost a decade now. In many organizations, the ease of development, web front end and security make SSRS the tool of choice.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,557 reads
Previous headlines

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,438 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,576 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,719 reads

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,630 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,138 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,441 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,835 reads
 

From the SQLServerCentral Blogs

4 Rules of Right When Running a Query

Last month in January, I participated in the Idera #sqlchat.  This is a monthly chat meeting that is organized by...  Read more...
By SQLRUs 2018/02/21 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,082 reads

Power BI with different Network Visualizations

(2018-Feb-10) A few days ago Microsoft provided another update for its desktop version of the Power BI data analytical tool...  Read more...
By Rayis Imayev 2018/02/21 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,653 reads
Question of the Day

How far behind

By Steve Jones 2018/02/21 | Category: r language
Rating: (not yet rated) |  Discuss |   Briefcase | 431 reads

I've got this data set:


rank player.name year2017 yards2017
1 1 Tom Brady 2017 4577
2 2 Philip Rivers 2017 4515
3 3 Matthew Stafford 2017 4446
4 4 Drew Brees 2017 4334
5 5...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
35185 589786 SSC Guru  
2.
Jeff Moden
31242 543059 SSC Guru  
3.
Steve Jones - SSC Editor
19409 351408 SSC Guru  
4.
Grant Fritchey
14864 238729 SSC Guru  
5.
Lynn Pettis
13821 239741 SSC Guru  
Latest forum posts