Building Your Brand at Work?
This Friday's poll asks how much you can help yourself while working at your job? Can you build your own brand at work?
Building Your Brand at Work?
This Friday's poll asks how much you can help yourself while working at your job? Can you build your own brand at work?
Creating a Member Selection Dashboard Filter in Performance Point Server 2007 (PPS)
We have heard that you can create filters in a Performance Point dashboard then apply them to one or more reports and scorecards. Can you provide some step-by-step instruction on how to do this?
Exploded Pie Chart for Analysis Services Data
MSAS Architect Bill Pearson leads the hands-on creation of an exploded pie chart based upon an Analysis Service data source.
William Durkin, Serial Red Gate Beta Tester
In this article sponsored by Red Gate, read about a beta tester's experience with new versions of SQL tools.
Downloading a file over HTTP the SSIS way
This post shows you how to download files from a web site whilst really making the most of the SSIS objects that are available. There is no task to do this, so we have to use the Script Task and some simple VB.NET or C# (if you have SQL Server 2008) code
Over-Engineering
Steve Jones thinks that we often over-engineer software, trying too hard to consider every possibility rather than getting it close.
Over-Engineering
Steve Jones thinks that we often over-engineer software, trying too hard to consider every possibility rather than getting it close.
Over-Engineering
Steve Jones thinks that we often over-engineer software, trying too hard to consider every possibility rather than getting it close.
Testing with Profiler Custom Events and Database Snapshots
We've all had them. One of those stored procedures that is huge and contains complex business logic which may or may not be executed. These procedures make it an absolute nightmare when it comes to debugging problems because they're so complex and have so many logic offshoots that it's very easy to get lost when you're trying to determine the path that the procedure code took when it ran. Fortunately Profiler lets you define custom events that you can raise in your code and capture in a trace so you get a better window into the sub events occurring in your code.
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