2015-06-23
7,632 reads
Articles
SQLXML Bulk Loader Basics
SQLXML isn't exactly new technology, but like the even more venerable BCP, it remains the quickest and most reliable way of heaving large quantities of data into SQL Server databases. SQLXML is very versatile, and once set up is wonderfully reliable ETL system, but isn't trivial to learn. Adam Aspin comes to the rescue with a simple guide.
2015-06-23
4,935 reads
The Case for Specifying Data Types and Query Performance
Performance penalties for omitting SQL data types when using ADO.Net or light weight ORMs.
2015-06-22
6,262 reads
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.
2015-06-22
4,457 reads
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.
2015-06-19 (first published: 2013-03-19)
28,005 reads
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.
2015-06-19
3,975 reads
A Syntax Mystery in a Previously Working Procedure
A previous working script show syntax errors on recreating (sp_helptext script line length limitation)
2015-06-18
5,744 reads
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.
2015-06-18
5,591 reads
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.
2015-06-17
2,129 reads
Converting Rows to Columns (PIVOT) and Columns to Rows (UNPIVOT) in SQL Server
Learn how to convert row values into column values (PIVOT) and column values into row values (UNPIVOT) in SQL Server.
2015-06-16
4,888 reads
Blogs
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Start with the FabricTools PowerShell module
By Kamil
Managing Microsoft Fabric at scale quickly becomes painful if you rely only on the...
Enterprise AI Operating Rhythm – Top 5 practices for 2026
2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...
Forums
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
SQL Art: I Made a Christmas Card In SSMS
Comments posted to this topic are about the item SQL Art: I Made a...
lookup error
I am using ssrs in visual studio 2022, I work on a report, there...
Question of the Day
Celebrating Tomorrow
Which of these is more appropriate for tomorrow?
See possible answers