Today Steve Jones gives you ideas on how to keep learning and growing your career.

How to Batch Updates A Few Thousand Rows at a Time

by Additional Articles

Brent Ozar Blog

T-SQL

In this post, Brent explains how to use a combination of two separate topics that he has blogged about recently.

Multiple Regression Model Enhanced with Bagging

by Additional Articles

SQLServerCentral

This article explains what bagging is relative to a basic decision tree model and demonstrates how to apply bagging for better multiple regression model fits to data from SQL Server.

Allowing Failure

by Ben Kubicek

SQLServerCentral.com

Editorial

Sometimes it is better to allow things to fail.

Mathematicians and SQL

by Joe Celko

SQLServerCentral

Database Design and Implementation

Georg Ferdinand Ludwig Philipp Cantor is considered the creator of set theory, and his theories are the basis for the naïve set theory you learned in school. But there are lots of other mathematicians you should know, such as Hilbert, Frege, Russell, Zermelo and Dedekind. They made a lot of contributions, too. Hilbert Hilbert is […]

DAX financial functions: Depreciation calculations

by Additional Articles

SimpleTalk

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson continues his series surrounding the DAX financial functions. In this article, he exposes four functions that are popular in the calculation of depreciation and amortization. Those accustomed to these functions within Excel will find the syntax, uses and operation of the functions familiar within the Power BI environment.

Ten Reasons your SQL Server Monitoring will Scale

by Additional Articles

Redgate

Vendors/3rd-party Products

This article explains ten ways that SQL Monitor tackles the problem of scaling out the coverage of a single, lightweight monitoring system, and so allows your teams to maintain the health and performance of larger collections of databases and higher numbers of monitored SQL servers.

Default Credentials

by Steve Jones

SQLServerCentral

Security

Using default credentials is a poor practice, but people still continue to forget to change them.

Using an RDL File Locally in .NET to Print Reports

by Ben Kubicek

SQLServerCentral

The need to print doesn't seem to go away. Using RDL format report file you can print local reports in .net to PDF without having to connect to a Reporting Service Server.