Introduction to SQL Server Check Constraints

Check Constraints play a very important role in SQL Server as it allows data validation rules to be imposed at the SQL Server instance level itself instead of writing rules for each application.

SQL Saturday #233 Oklahoma City

SQL Saturday comes to Oklahoma City on August 24th for a free day of SQL Server training and networking. This event also features a paid-for pre conference session on Friday with Bill Pearson on Practical Self-Service BI with PowerPivot for Excel.

SQLServerCentral.com Users Survey 2013

We want to make sure we're covering the things that are relevant to you, so we're asking for some feedback on what you use on SSC, where we need to improve, and what you'd like to see.

It should only take a few minutes, and three randomly-selected people will win a $100 Amazon gift card for their efforts.

The Standard Limitation

SQL Server Standard Edition only supports 64GB of RAM and it's our fault. Or is it, and is this a reasonable number? Steve Jones has a few thoughts today.

Biml Workshop presented by Varigence and Linchpin People

Business Intelligence Markup Language (Biml) automates your BI patterns and eliminates the manual repetition that consumes most of your time. On October 15th come see why BI professionals around the world think Biml is the future of data integration and BI.

Concatenation of Different SQL Server Data Types

TSQL provides 2 ways to concatenate data, the + sign and the new CONCAT() function. This tip will cover the differences in the two, so you can achieve the expected behavior in your code.

Changing SQLServerCentral - Newsletter Layout

Our series discussing the current and potential changes to SQLServerCentral.

Data Mining Introduction Part 6: Time series algorithm

This article is part of the Data Mining introduction series. This article is about time series.

Data Mining Introduction Part 6: Time series algorithm

This article is part of the Data Mining introduction series. This article is about time series.

Separation of Duty

We want to ensure that the data we gather accurately reflects the state of some system or event. The analysis should decide how we interpret the data gathered. Neither should influence the other.