SSIS R2 Configuration File Issue Fixed
Using configurations files in SSIS is a great way to change how your package will run from outside the development...
2010-05-14
866 reads
Blog Posts
Thoughts on Leadership
A friend is moving into a leadership role for the first time and we talked some about making that transition....
2010-05-14
952 reads
Tips from ...Rock Star DBA
Thomas LaRock (SQL Server MVP) (Blog | Twitter | LinkedIN), recently has published the new book DBA Survivor: Become a Rock Start...
2010-05-14
818 reads
Career Advice for the Novice SQL Server DBA
In April, I ran a Question of the Month that asked, “What advice would you offer a novice DBA in...
2010-05-13
973 reads
Daily SQL Server 2008 New Feature – Day 6
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-05-13
558 reads
Formatting Code in LiveWriter
I was getting tired of pre-formatting code in LiveWriter. I love that software, but a couple of the technical things...
2010-05-13
926 reads
Let’s Play, “Why did it do that?”
On my current project I decided to be flexible and allow the use of Linq to SQL to try to...
2010-05-13
272 reads
Live Writer - Paste from Visual Studio
This is a test of the plug in “Paste From Visual Studio”. I had this code sitting in SSMS and...
2010-05-13
804 reads
SQL Server Azure features limitation
SQL Server Azure, fully relational cloud database solution, is new possibility of the database administration and maintenance. I'm not going...
2010-05-13
1,062 reads
Upcoming SQL Lunch Webcasts
First, I would like to thank all that have attended and supported the SQL Lunch during our first year. We...
2010-05-13
686 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
SQL Server 2019 - Agent job PowerShell step issue
I have a couple of SQL Agent job steps which run PowerShell commands of...
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers