Connecting to SSIS 2008 Without Local Admin
The default install of SSIS only allows users with local admin rights on the server to connect. This can be...
2013-04-16
48 reads
Gavin Draper
SQL Server Development Permissions
After setting up a new SQL Server instance for development I found the following permissions were needed extra permissions were...
2013-03-21
44 reads
Self Hosting WCF Services With Transport Security
When developing and debugging transport security WCF services it’s a real pain if each developer on the team needs to...
2013-03-15
125 reads
Configuring/Authenticating with Identity Server in C#
In my previous post I walked through configuring ADFS and writing a small C# console app to authenticate with it...
2013-02-06
448 reads
AD FS Token Based Authentication In Code
I’m writing this post more as documentation for myself as I know I will be repeating this process quite a...
2013-01-31
360 reads
MVVM Page Navigation Using MVVM Light On WP7
Page navigation can be a pain to achieve in a true MVVM way, I recently ran in to this problem...
2013-01-14
64 reads
SQL Availability Groups VM Sandbox Step By Step
In this post I am going to walk you through creating a virtual environment from the ground up to play...
2012-11-19
45 reads
Automated Disk Space Alerts For Windows Server
PowerShell Style
I recently needed to automate disk alerts for each of our servers, to keep it simple I wrote a...
2012-09-22
81 reads
C# Explicit Interface Implementation
In C# it is possible to write classes that implement an interface but only show the methods of the interface...
2012-06-07
38 reads
SQL Server Service Broker Explained
What is Service Broker?
Service Broker is a native SQL Server implementation of message queues.
What are message queues?
Message queues are a...
2012-06-03
157 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
New SQL Server 2022 Functions
Comments posted to this topic are about the item New SQL Server 2022 Functions
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers