SQL Server 2005 Integration Services - Security - Part 28
Part 28 of SQL Server 2005 Integration Services series covers the remaining security features intended to protect the confidentiality and integrity of your packages
Get RAAS WorkFlow Manager For Free
For a limited time Highwire Development is offering free site licenses for their RAAS Workflow Manager. This product can help you control your change processes and manage the workflow involved in deploying new scripts.
What is XML?
The use of XML is growing all the time and if you listen to the media, XML is a technology you cannot do without. New author Stephen Hirsch brings us a look at XML from more of a skeptic's point of view.
NET Application Architecture: the Data Access Layer
An in-depth, fully explained case study on how to design and create a data access layer for your .NET applications.
BlackBelt Administration: Linked Reports in SQL Server Management Stud
Create Linked Reports from within SQL Server Management Studio. BI Architect Bill Pearson examines another approach for using Linked Reports to provide multiple "versions" of a single-source report.
Performance Tuning Stored Procedures
Stored procedures are a great way to encapsulate code and reuse it in many places in your application. But when you have a performance issue, how do you know which part of the stored procedure is giving you problems? Steve Jones takes a look at a few techniques for diving into stored procedures and identifying problem areas.
SQL Server 2005 – Unattended installation – Part IV
In this section of this series, I am going to demonstrate how to install SQL Server 2005 Service Pack 1, to update the client components using command line options.
Using DDL Database Triggers
In this short demonstration, you'll learn how to use DDL database triggers to prevent changes to product and audit changes to comply with Sarbanes-Oxley and other change management requirements. Free registration required.
How many more Mondays until I retire?
Depending on your age, you may not want to know this number, but as you advance in your career, this might be a problem that you look to solve one day. Peter Larsson takes a few minutes to work out a function in T-SQL that can be used to solve this or any similar question.
SQL Prompt IntelliSense for SQL Server
Visual Studio developers have enjoyed the benefits of intellisense for some time, but us SQL Server users have had to work from memory. Wayne Fillis was so enthralled with a new offering from Red Gate he wrote a short review and sent it in. Check out his thoughts and how this product can help you.
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