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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,894,740 DBAs, developers and SQL Server users

Headlines today   December 12, 2017

Azure DWH part 20: Create External and Internal tables As Select

CTAS and CETAS are very important T-SQL features in ASDW. These features allow to create a table and fill with data based on a query.  Read more...
By Daniel Calbimonte 2017/12/12 | Source: SQLServerCentral.com | Category: ctas
Rating: |  Discuss |   Briefcase | 219 reads

The four pillars of DevOps

DevOps isn’t just about tools. DevOps isn’t just about process. DevOps isn’t just about the people. DevOps isn’t just about culture. If you try and focus on one thing only, you’ll probably do it wrong and fail. You need to embrace all of the pillars. You wouldn’t build a house with only two walls and expect to have a wonderful experience the next time it rained.  Read more...
By 2017/12/12 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 1,797 reads

Checking SQL Server with Policy-Based Management

Policy-Based Management, a feature of SQL Server, is a flexible tool that can help DBAs manage one or more SQL Server instances. It's used for monitoring and enforcing a standard set of policies for SQL Server throughout an organization. While there are many built-in conditions from which to choose, Dennes demonstrates how to set up a custom policy as well as a standard one. Viewing the policy status over many servers can be tedious, so he also explains how DBAs can evaluate the states of multiple servers with just one glance.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,142 reads
Previous headlines

SQL-On-Hadoop: Hive - Part II

Running Interactive and Batch SQL Queries on Hadoop and other distributed clusters using SQL.  Read more...
By Frank A. Banin 2017/12/11 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 495 reads

Azure SQL Database Virtual Network Service Endpoints and Rules

One of the most commonly requested Azure SQL Database features has been support for more granular control of server-level firewall settings. A recently announced public preview of Azure SQL Database and Data Warehouse VNET service endpoints and rules promises to address this limitation.  Read more...
By Additional Articles 2017/12/11 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 1,157 reads

Generating test data in JSON files using SQL Data Generator

SQL Data Generator is adept at filling SQL Server databases with ‘spoof’ data, for use during development and testing activities. However, what if instead of a SQL Server database full of fake data, you need a JSON file?  Read more...
By 2017/12/11 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,702 reads

Bones of SQL – Grouping By User-Defined Calendar Periods

Although it is common to group by periods such as Week, Month, or Quarter, sometimes alternative periods are needed. This simple technique lets you split a year into periods with any number of days.  Read more...
By Bob Hovious 2017/12/08 (first published: 2016/09/26) | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 2,264 reads

How Much Data Has Changed Since Your Last Full Backup

Have you ever wanted to know how many pages in your database have changed since the last full backup? If so, then you will be glad to hear that the SQL Server 2017 version of the DMV, sys.dm_db_file_spavce_usage, has a new column named modified_extent_page_count, which shows the number of pages that have changed since the last full backup.  Read more...
By Additional Articles 2017/12/08 | Source: Database Journal | Category: sql server 2017
Rating: (not yet rated)  Rate this |   Briefcase | 2,457 reads

Free virtual event: SQL in the City Streamed

Technical sessions will dive into the latest Microsoft SQL Server releases, and cover topical issues such as data compliance, protection & privacy.  Read more...
By 2017/12/08 (first published: 2017/11/30) | Source: Redgate | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 3,029 reads

How to store Excel files In SQL Table

This article will show how to store images, document and all other files in SQL Table.  Read more...
By Nisarg Upadhyay 2017/12/07 | Source: SQLServerCentral.com | Category: openrowset
Rating: |  Discuss |   Briefcase | 1,729 reads

From the SQLServerCentral Blogs

The One Piece of Career Advice I Wish I’d Gotten

Over the years, I’ve been approached numerous times with requests for advice from folks who are looking to get started...  Read more...
By Tim Mitchell 2017/12/12 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,768 reads

Power BI Custom Visuals Class (Module 80 – TreeViz)

In this module you will learn how to use the TreeViz Custom Visual. The TreeViz is a breakdown tree that...  Read more...
By Devin Knight 2017/12/12 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 976 reads
Question of the Day


By Steve Jones 2017/12/12 | Category: group by
Rating: (not yet rated) |  Discuss |   Briefcase | 484 reads

I'm working with sales and I want to sum my totals by year and month, but I'd also like a total for the year in my result set. I have...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
41982 496245 SSC Guru  
Jeff Moden
39786 457891 SSC Guru  
Steve Jones - SSC Editor
25907 298900 SSC Guru  
Grant Fritchey
19070 199084 SSC Guru  
Lynn Pettis
17630 201354 SSC Guru  
Latest forum posts