We have the requirement that our passwords have to change every 90 days. I wanted to automate this and it sounded pretty easy to do, but it wasn’t that easy. Why? Because there are a lot of rules for passwords. First, I have to store it in the web.config. So no XML special characters. quot […]
Generating Passwords Read More »
All of these failed except the last one. I was logged in as RMUser: Copy Text Copied Use a different Browser exec sp_password 'DC9E3622', 'A55BE7!#4', 'RMUser' Msg 15210, Level 16, State 1, Procedure sp_password, Line 20 Only members of the sysadmin role can use the loginame option. The password was not changed. Copy Text Copied
Changing the SQL Server Password Read More »
I have 10 clients that each have a process that posts a value to my web service every hour at three minutes after the hour. I needed to know when a post doesn’t happen for a client. The logic of the SQL is that I want to return the last row posted for each Client
Notify Me When Something Does Not Happen Read More »
I wanted to monitor one of my system from my desk top and from my phone. I found a simple solution whereby I can subscribe to the result set of a stored proc by using RSS. So I can have this feed MS Outlook, my phone or my web browser. First, Visual Studio 2010 makes
Having the Result Set of a Stored Proc Sent to You by RSS Feed. Read More »
On one of our projects, we have a requirement that we have to change our passwords every 90 days. So I created a page where I can just click a button and it will generate a password, change the password on the database for the user in the connection string, and then change the password
Change Connection String Password Programmatically Read More »
I wanted to document how we do our DAL. First, performance is important, so we use ADO.NET instead of the Entity Framework, NHibernate, etc. Second, in our main project, we have 1,743 stored procs and counting, so a stored proc-centered approach is necessary. So over the years, I have reduced it down so that the
Data Access Layer Architecture Read More »
I have a page in my ASP.Net application where I show all of my AppSettings, connection strings, etc. But I didn’t want to show the passwords. I wanted something like: server=MyServer;uid=MyUserId;pwd=*******;database=MyDatabase; So here is the code to strip out the password: Copy Text Copied Use a different Browser private string stripPassword(string connString) { if (string.IsNullOrEmpty(connString))
Stripping Out Passwords Read More »
I had a large number of XML files that each contained hourly prices for a lot of different locations. I needed to get all of the prices for a single location. I did this by loading all of the files into a table and then querying the table. First, I needed to change the rights
Uploading XML Files to SQL Server Read More »
I needed to display some parent data with its child data on the same row as shown in the image above. I happen to be combining a few tables together into a new table (called dtPlan) and then binding the GridView to that new table. So this was my approach while moving the data into
Grid within a GridView Cell Read More »
In the past we would use a Varchar to pass a comma delimited list of IDs to a stored proc. We would then build a big varchar string of the full SQL and run the dynamic SQL. Starting with SQL Server 2005 you can pass the stored proc XML and do your select without using
Passing IDs to Stored Procs Using XML Read More »
