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

Rss
Headlines today   December 11, 2017

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 | 431 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 | 924 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,415 reads
Previous headlines

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,224 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,310 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 | 2,926 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,682 reads

SQL Server R Services: Working with Multiple Data Sets

Although it is easy to use SQL Server R Services to create R scripts that incorporate SQL Server data by passing in a T-SQL query as an argument when calling the sp_execute_external_script stored procedure, you are limited to that one query, unless you pass additional data directly between R and SQL Server via CSV files. It is simple to do, and opens up many additional opportunities for data analysis. Robert Sheldon explains how.  Read more...
By Additional Articles 2017/12/07 | Source: SimpleTalk | Category: sql server r services
Rating: (not yet rated)  Rate this |   Briefcase | 2,300 reads

Major new study reveals the true ROI of database DevOps

Redgate has launched a new research study that reveals the benefits different stakeholders can expect from DevOps, and provides a powerful methodology for calculating the ROI of database DevOps.  Read more...
By 2017/12/07 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 1,933 reads

Stairway to SQL PowerShell Level 4: Objects in SQL PowerShell

This far, we have learned about installation and setup of the PowerShell environment. You should now have a foundation of SQL Server PowerShell. We now are ready to learn about Objects in SQL PowerShell.  Read more...
By Ben Miller 2017/12/06 (first published: 2012/10/22) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 10,774 reads
 

From the SQLServerCentral Blogs

Database Fundamentals #15: Modifying Data With T-SQL

The preferred method for modifying your data within a database is T-SQL. While the last Fundamentals post showed how to...  Read more...
By Grant Fritchey 2017/12/11 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,180 reads

Automating T-SQL Code Analysis

With all the options available within T-SQL these days, it’s more and more imperative that our code be clear and...  Read more...
By Grant Fritchey 2017/12/11 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,392 reads
Question of the Day

STRING_SPLIT with no delimiter

By Steve Knox 2017/12/11 | Category: string_split
Rating: (not yet rated) |  Discuss |   Briefcase | 600 reads

I have the following variable:


DECLARE @A VARCHAR(6) = 'ABCDEF'
I want to produce the following output:


values
A
B
C
D
E
F
How can I do this using the STRING_SPLIT()...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
41744 494396 SSC Guru  
2.
Jeff Moden
39480 456086 SSC Guru  
3.
Steve Jones - SSC Editor
25613 297758 SSC Guru  
4.
Grant Fritchey
18740 198081 SSC Guru  
5.
Lynn Pettis
17491 200588 SSC Guru  
Latest forum posts