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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,892,502 DBAs, developers and SQL Server users

Rss
Headlines today   October 16, 2017

Loading Data using R and PowerBI

I'm not a fan of R visuals in PowerBI. I recently learned I can use R to load data and native PowerBI visuals to display the data. Here's how.  Read more...
By Nick Burns 2017/10/16 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 476 reads

Webinar: how to cut time & disk space for database provisioning by 99%

If you’ve ever worked in a team that uses a single, shared database for development, you know how time-consuming and frustrating it is to provision copies of production databases for development work. In this webinar on October 17, you’ll see how SQL Clone cuts out the pain of provisioning development databases.  Read more...
By 2017/10/16 (first published: 2017/10/11) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 3,746 reads

The Power of Python and SQL Server 2017

Python is new to SQL Server 2017. It is intended primarily to allow the use of Python-based machine-learning within SQL Server, but it can be used for far more than this, with any Python libraries or Frameworks. To provide an example of what is possible, Hitendra shows how to use the feature securely to provide intelligent application caching, where SQL Server can automatically indicate when data changes to trigger a cache refresh.  Read more...
By Additional Articles 2017/10/16 | Source: SimpleTalk | Category: python
Rating: (not yet rated)  Rate this |   Briefcase | 2,145 reads
Previous headlines

A Lightweight, Self-adjusting, Baseline-less Data Monitor

Can data alert us that something is going on, without baselines and thresholds?  Read more...
By Alex Chamchourine 2017/10/13 (first published: 2016/02/23) | Source: SQLServerCentral.com | Category: data monitoring
Rating: |  Discuss |   Briefcase | 3,398 reads

How to import an existing database to ReadyRoll

The SQL Toolbelt includes ReadyRoll, which allows you to adopt a migrations-first approach to database source control and deployment. There are a number of different ways teams can get started with ReadRoll, and customers often ask how to get up and running when there is already an existing development database.  Read more...
By 2017/10/13 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,949 reads

A Freecon Halloween at the PASS Summit

If you're attending the PASS Summit in 2017, there's a Freecon day on Tuesday you can attend.  Read more...
By Press Release 2017/10/13 | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated) |  Discuss |   Briefcase | 131 reads

Group Managed Service Accounts (gMSAs) in SQL2016

Implementing Group Managed Service Accounts (gMSAs) in existing SQL Server instances with AlwaysON  Read more...
Rating: |  Discuss |   Briefcase | 568 reads

The importance of bringing Python to SQL Server

When SQL Server 2017 launched, Microsoft proudly announced that it was the first relational database engine to ship with built-in artificial intelligence (AI) capabilities. But why Python and SQL Server? What is Python? And how does this compare to the R integration in SQL Server 2016?  Read more...
By 2017/10/12 | Source: Redgate | Category: python
Rating: (not yet rated)  Rate this |   Briefcase | 3,911 reads

Statistics in SQL: Student’s t-test

Many undergraduates have misunderstood the name 'Students' in the t-test to imply that it was designed as a simple test suitable for students. In fact it was William Sealy Gosset, an Englishman publishing under the pseudonym Student, who developed the t-test and t distribution in 1908, as a way of making confident predictions from small sample sizes of normally-distributed variables. As Gosset's employer was Guinness, the brewer, Phil Factor takes a sober view of calculating it in SQL.  Read more...
By Additional Articles 2017/10/12 | Source: SimpleTalk | Category: statistics
Rating: (not yet rated)  Rate this |   Briefcase | 2,479 reads

Stairway to SQL Server Agent - Level 2: Job Steps and Subsystems

SQL Server Agent jobs are made up of a series of one or more Job Steps. A job step is assigned to a specific job subsystem, which identifies the kind of work the job step is going to perform. Each job step runs in a separate security context, although each job also has an owner that determines who can modify the job.  Read more...
By Richard Waymire 2017/10/11 (first published: 2011/02/17) | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 7,871 reads
 

From the SQLServerCentral Blogs

SQLpassion Online Training about Availability Groups

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...  Read more...
By Klaus Aschenbrenner 2017/10/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 604 reads

Understanding ANOVA

ANOVA – or analysis of variance, is a term given to a set of statistical models that are used to analyze...  Read more...
By Mala Mahadevan 2017/10/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,022 reads
Question of the Day

DateTimeOffset

By Steve Jones 2017/10/16 | Category: datetimeoffset
Rating: (not yet rated) |  Discuss |   Briefcase | 581 reads

What is a datetimeoffset?

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
53847 410963 SSC Guru  
2.
Jeff Moden
48771 376684 SSC Guru  
3.
Steve Jones - SSC Editor
30365 247193 SSC Guru  
4.
Lynn Pettis
21105 166378 SSC Guru  
5.
Grant Fritchey
19798 160967 SSC Guru  
Latest forum posts