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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,888,418 DBAs, developers and SQL Server users

Headlines today   July 26, 2017

SQL-On-Hadoop: Hive - Part I

Running Interactive and Batch SQL Queries on Hadoop and other distributed clusters using SQL.  Read more...
By Frank A. Banin 2017/07/26 | Source: SQLServerCentral.com | Category: hadoop
Rating: |  Discuss |   Briefcase | 432 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 2017/07/26 (first published: 2013/08/14) | Source: Redgate | Category: transaction log
Rating:  Rate this |   Briefcase | 83,619 reads

How to Read the Transaction Log File

Have you ever wanted to be able to see the actual transactions that are contained in the transaction log file? Greg Larsen shows you how to browse the transaction log using an undocumented function.  Read more...
By Additional Articles 2017/07/26 | Source: Database Journal | Category: transaction log
Rating: (not yet rated)  Rate this |   Briefcase | 1,613 reads
Previous headlines

Azure DWH part 12: Permissions, roles, logins and users

In this article we will show some common roles and queries related to Azure SQL Data Warehouse.  Read more...
By Daniel Calbimonte 2017/07/25 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 234 reads

Containers for enhanced Data Governance and Compliance

Complex data environments sometimes need new techniques to properly manage the information. See how Windocks can help with containers and SQL Server.  Read more...
By Paul Stanton 2017/07/25 | Source: SQLServerCentral.com | Category: windocks
Rating: |  Discuss |   Briefcase | 179 reads

The Basics of Good T-SQL Coding Style – Part 2: Defining Database Objects

Technical debt is a real problem in database development, where corners have been cut in the rush to keep to dates. The result may work but the problems are in the details: such things as inconsistent naming of objects, or of defining columns; sloppy use of data types, archaic syntax or obsolete system functions. With databases, technical debt is even harder to pay back. Robert Sheldon explains how and why you can get it right first time instead.  Read more...
By Additional Articles 2017/07/25 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 2,837 reads

The Case of the Space at the End

A gripping expose into the deep, dark world of ANSI_PADDING! What could be more exciting?  Read more...
By Adam St. Pierre 2017/07/24 | Source: SQLServerCentral.com | Category: ansi_padding
Rating: |  Discuss |   Briefcase | 1,402 reads

Extending DevOps practices to SQL Server databases – Branching & Merging with VSTS

Join Microsoft Data Platform MVP Steve Jones for the next Database DevOps demo webinar on July 25. He’ll be plugging Redgate tools into Visual Studio Team Services and showing how you can branch and merge your database changes. Sign up now.  Read more...
By 2017/07/24 (first published: 2017/07/20) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 5,572 reads

Testing DML Statements for In-Memory OLTP

Erin Stellato takes a thorough look at the way DML statements might benefit from In-Memory OLTP, especially with natively compiled stored procedures.  Read more...
By Additional Articles 2017/07/24 | Source: SQLPerformance.com | Category: dml
Rating: (not yet rated)  Rate this |   Briefcase | 2,224 reads

SQL Server Management Studio add-ins

Complete list of useful and must have add-ins for SQL Server Management Studio - 32 SSMS add-ins  Read more...
By Konstantin Taranov 2017/07/21 | Source: SQLServerCentral.com | Category: ssms
Rating: |  Discuss |   Briefcase | 2,272 reads

Ask SQL Server Central

From the SQLServerCentral Blogs

Creating SQL Server containers with docker compose

Up until now my posts about containers have been talking about working with one container only. In the real world...  Read more...
By Andrew Pruski 2017/07/26 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 649 reads

Azure Cloud “Fear” Busting #1 – Security

So here we go, the first installment of my cloud blog series. From my experience this concern is a common...  Read more...
By Arun Sirpal 2017/07/26 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 685 reads
Question of the Day

Labeling a graph

By Steve Jones 2017/07/26 | Category: r language
Rating: (not yet rated) |  Discuss |   Briefcase | 397 reads
For these questions, I am working with RStudio without any additional packages installed.

I want to plot the number of Home Runs for Hank Aaron. I create a vector with...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
75543 228533 SSC Guru  
Jeff Moden
66148 218440 SSC Guru  
Steve Jones - SSC Editor
41288 148551 SSC Guru  
Lynn Pettis
29831 96481 SSC Guru  
Grant Fritchey
26794 99619 SSC Guru  
Latest forum posts