Does It Count?
This Friday Steve Jones asks how you track uptime. Does your scheduled maintenance count against your metrics?
Trigger an Email of an SSRS Report from an SSIS Package
This article demonstrates how to trigger an SSRS subscription to email a report from an Execute SQL Task using SQL Server Agent and the ReportServer.dbo.AddEvent stored procedure.
Script All Server Level Objects to Recreate SQL Server
Carla Abanes provides a guide on how to create a console application that will generate create scripts for server level objects for multiple SQL Server instances. This is handy in the event of a disaster and you need to create a clone of the SQL Server that is no longer available.
A Syntax Mystery in a Previously Working Procedure
A previous working script show syntax errors on recreating (sp_helptext script line length limitation)
Sweat Files and Practice Projects
Today we have a guest editorial from Andy Warren that looks at side projects and how you might actually grow our careers.
Using R to Explore Data by Analysis - for SQL Professionals
What's the best way for a SQL programmer to learn about R? It's probably by trying out various experiments with an interesting set of data, and some helpful suggestions that point out the parallels with SQL. Feodor provides the data and the helpful suggestions. The rest is up to you.
Culture Clashes and Arrogance
A guest editorial from Andy Warren looks at the disagreements between teams in technology.
Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions
BI Architect Bill Pearson launches a set of articles surrounding a group of MDX functions specialized to meet the pervasive business need to analyze data within the context of time / date. In this article, we will overview the PeriodsToDate() function, and then we will introduce "shortcut" functions that are based upon it.
Automating A Heartbeat Check Against an Azure-SQL Database Using PowerShell
In this article, Tim Smith goes through a couple of options to automate heartbeat checks against Azure databases. This is useful if you're moved SQL Server databases to Azure and you want to have periodic checks to make sure the databases are responsive.
Data Mining Part 29: Programming with C# and AMO
In this article, we will show some debugging tips for working with C# and the AMO code for working with Analysis Services and the Data Mining Models.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
Alamat Kantor BCA KCU MATRAMAN Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Jl. Matraman Raya No.14-16, RT.2/RW.1, Kb. Manggis, Kec. Matraman, Kota Jakarta Timur,...
BCA KCP Buaran Raya Telp/WA.0851°8812°0691
BCA KCP Buaran Raya Telp/WA.0851°8812°0691 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101,...
BCA KCP Permata Ujung Menteng Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Jl. Raya Bekasi Km. 25 Blok A/17, RW.18, Ujung Menteng, Wil, Kota...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers