SSIS expert Andy Leonard covers the basics of the Execute Package Task, how to configure it and how one SSIS package can call another.
SQL SERVER – Script to Find Leap Year
A simple T-SQL script to check whether a year is a leap year, using DATEADD and EOMONTH to find the last day of February for that year.
SQL SERVER – Error: Fix for Error Msg 3906 – Failed to update database because the database is read-only
Getting Msg 3906, Failed to update database because the database is read-only? The message says it all. Here is how to make the database writable again.
SQL SERVER – Viewing User Configurable Info in SQL Server
A reader asked about sp_user_counter1 to 10 for debugging. I show how sp_trace_generateevent raises events you can watch as User Configurable info.
SQL SERVER – What are the Different Ways to Script Procedure with T-SQL
What are the different ways to script procedure code with T-SQL? There are four, including sp_helptext and INFORMATION_SCHEMA.ROUTINES. Here is each one.
SQL SERVER – One Trick of Handling Dynamic SQL to Avoid SQL Injection Attack?
SQL Injection is not a SQL Server problem, it comes from coding habits. Here is one trick of handling dynamic SQL to avoid SQL injection attack on a search page.
SQL SERVER – Invoking a Stored Procedure from Azure Mobile Services – Notes from the Field #066
Can you call a SQL stored procedure from Azure Mobile Services? In Notes from the Field #066, Kevin Hazzard shows how, with a bit of humor along the way.