How to Grow In Your Career

• by Steve Jones

• SQLServerCentral.com

• Editorial

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

Stairway to Advanced T-SQL Level 9: Compare, Modify, Derive and Validate Date and Time Values

• by Gregory Larsen

• SQLServerCentral.com

When you build applications that store data in SQL Server you will most likely have to store dates and times, and you’ll call functions to do date manipulations. It is important to understand the different date and time data types, and when to use one data type over another. In this level I will be exploring the different date and time data types and discussing when each type is appropriate.

How to Batch Updates A Few Thousand Rows at a Time

• by Additional Articles

• Brent Ozar Unlimited 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

• Data Mining
• T-SQL

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

• BI

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

• Reporting Services (SSRS)
• winforms

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.