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

Rss
Headlines today   November 23, 2017

Databases in Azure… Where to begin? Create a Database and log in!

Ready to create your first Database in Azure. Here are the step by step instructions with plenty of definitions and terms.  Read more...
By Michael Morin 2017/11/23 (first published: 2016/06/16) | Source: SQLServerCentral.com | Category: azure sql database
Rating: |  Discuss |   Briefcase | 2,239 reads

Extending DevOps practices to SQL Server databases with ReadyRoll and VSTS

In this demo heavy session you’ll see how Redgate’s SQL Toolbelt allows you to take a local development database, source control it, set up automated builds and automate deployments to an Azure SQL database in less than an hour using VSTS.  Read more...
By 2017/11/23 | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 1,299 reads

SQL Server R Services: Generating Sparklines and Other Types of Spark Graphs

By being able to run R from SQL Server, you have available to you not just a convenient way of performing analysis on data but also a wide range of more specialized graphical facilities. Rob Sheldon illustrates the point by demonstrating how you can create sparklines that can then be embedded in reports.  Read more...
By 2017/11/23 | Source: SimpleTalk | Category: sql server r services
Rating: (not yet rated)  Rate this |   Briefcase | 1,118 reads
Previous headlines

Stairway to MDX - Level 3: The Order() Function

The Order() function provides the 'hierarchized' sorts you need for reports and applications using MDX. In this Step, Business Intelligence Architect Bill Pearson explores using the versatile Order() function for providing dataset sorts that respect dimensional hierarchies.  Read more...
By Bill Pearson 2017/11/22 (first published: 2011/05/25) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 10,890 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2017/11/22 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 69,479 reads

SQL Source Control v6 now supports SQL Server 2017, SQL Graph, and TFS 2018

SQL Server 2017 went on general release a couple of weeks ago and the latest version of SQL Source Control offers full support, as well as support for Team Foundation Server (TFS) 2018. This brings a whole host of benefits and opens up cross-platform workflows, encompassing both on-premises and cloud, through connections to SQL Server instances on Linux and Azure Active Directory authentication.  Read more...
By 2017/11/22 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,281 reads

Dynamic Data Masking on Azure SQL Database

Azure SQL Database’s Dynamic Data Masking (DDM) feature limits the exposure of sensitive information to non-privileged users. DDM can mask either the full value or partial value in a column. This method can also mask Social Security and Credit Card Numbers without making any changes to the application.  Read more...
By Additional Articles 2017/11/22 | Source: Database Journal | Category: dynamic data masking
Rating: (not yet rated)  Rate this |   Briefcase | 835 reads

DBAs and the ITIL Framework, Part II: Asset Management

See how the ITIL Framework's Asset Management standards make the DBA's job easier. Use the CMDB and DML to keep your data assets under tight control.  Read more...
By John F. Tamburo 2017/11/21 | Source: SQLServerCentral.com | Category: itil
Rating: |  Discuss |   Briefcase | 467 reads

Preparing your data platform for peak period sales

In the last few years, Black Friday and Cyber Monday have become synonymous with both getting a good bargain and causing retail pandemonium. So how can you prepare your data platform for the increase in traffic?  Read more...
By 2017/11/21 | Source: Redgate | Category: data platform
Rating: (not yet rated)  Rate this |   Briefcase | 1,378 reads

More SQL Server Features that Time Forgot

SQL Server produces some great features, but it would be impossible to get them spot-on target every time. We are now quietly advised to use caution about using some of them, such as AutoShrink or the Index Advisor. Others, like the database diagramming tool, almost seem to have been quietly abandoned. Robert Sheldon investigates.  Read more...
By Additional Articles 2017/11/21 | Source: SimpleTalk | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 2,922 reads
 

From the SQLServerCentral Blogs

The Future of the SQLSaturday Tools

Every year when many of the SQLSaturday event leaders meet at the Summit the topic of improvements to the tools...  Read more...
By Andy Warren 2017/11/23 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 893 reads

Dealing with disquiet

Last week I listened to a podcast from one of my best friends in the sql community – Kendra Little. In...  Read more...
By Mala Mahadevan 2017/11/23 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,037 reads
Question of the Day

Game Day Planning

By Steve Jones 2017/11/23 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 302 reads

The Chargers-Cowboys game that takes place today will start at 3:30 in Dallas, TX.  I've got the time stored in a variable


DECLARE @d DATETIME2 = '20171123 3:30pm'
If I am in...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
51490 471312 SSC Guru  
2.
Jeff Moden
48827 434472 SSC Guru  
3.
Steve Jones - SSC Editor
31049 283695 SSC Guru  
4.
Grant Fritchey
21794 187552 SSC Guru  
5.
Lynn Pettis
20814 190816 SSC Guru  
Latest forum posts