The Case for Specifying Data Types and Query Performance
Performance penalties for omitting SQL data types when using ADO.Net or light weight ORMs.
The Stress of a Former DBA
Rodney Landrum impresses on his audience the importance of attention to the finer details, during data analysis and reporting.
The Test of Time
IBM recently turned 100 years old and Steve Jones wishes more companies would try to build their business to grow to 100.
Comparing Oracle and SQL Server Code - Part 1
In this tip, Daniel Calbimonte compares the SQL Server (T-SQL) and Oracle (PL-SQL) extensions of the SQL language. The tip will compare both T-SQL and PL-SQL languages with respect to retrieving data, creating databases, tables, variables, etc.
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.
Blogs
3 things you must do to start data quality management right
As a data & AI strategist who’s seen countless projects succeed and fail, I...
Set Theory vs. Batch Mode in SQL Server
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
Monday Monitor Tips: The Jobs Report
By Steve Jones
A customer wanted a report they could email to their boss about jobs, something...
Forums
Timeout when expanding the table
Experts, I am hoping to get some help and feedback. I have a server...
Single User SQL Server on Linux
Comments posted to this topic are about the item Single User SQL Server on...
All the Costs of Downtime
Comments posted to this topic are about the item All the Costs of Downtime
Question of the Day
Single User SQL Server on Linux
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers