Time Series Data Mining Example with T-SQL when Adding New Data
Learn about working with time series data using T-SQL code and how to add additional data to the data set for more in-depth data mining.
You Are An Inspiration
Hero, Champion, Inspiration. These are words that are bantered around about people regularly. Joe was a hero when he saved that puppy. Betty was the champion runner and won the race. Pat was an inspiration; they work so hard. Hero and champion are universally understood as positive things. Inspiration is typically used as a positive, […]
Comparing Two Execution Plans
This is a short look at a technique that I discovered recently in Management Studio (SSMS). The technique is to compare two graphical execution plans in the tool to understand what they are doing and how two different queries might affect a particular system, both with the image and with the properties' data behind the […]
Black Friday returns to SQLServerFast
November approaches again. For Europeans, that is a month like any other, for Americans, November means: Black Friday, with huge discounts!
Unpivoting Multiple Sets of Columns in SQL Server using CROSS APPLY
Learn how to unpivot data or sets of data with SQL Server queries using CROSS APPLY.
Advanced SQL Server installation using Powershell DSC
Introduction In the previous article, we learned how to install a SQL Server instance with basic parameters like InstanceName, Features, SourcePath, SQLSysAdminAccounts, etc using Powershell DSC. In this article, we'll discover how to enhance our SQL Server installation with additional configurations. We'll cover things like setting up service account credentials, custom installation directories, configuring TempDB […]
Having Data Modeling Standards
Today Steve talks about data modeling and how standards can transfer knowledge between developers.
Azure DocumentDB: Working with Microsoft's NoSQL Database in the Cloud
Coding for the new NoSQL JSON database service that supports SQL queries.
Blogs
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers