2017-02-28 22:08
In case you didn’t know the routes that configured using UI-Router are case-sensitive. Which is definitely not what I would expect. To get around this problem you can add a snipp… Read More
Blog Directory > Internet Blogs > Random Technical Thoughts | Things I want to remem internet Blog >
Random Technical Thoughts | Things I Want To Remem Blog
chrisbarba.wordpress.com
Tags:
command
support scripts
entity framework
processes
indexes
prompt
master database
schema
siname
basehref
Things I want to remember, sometimes my opinion
2017-02-14 13:48
Sometimes you need a command prompt to do stuff. That works fine if folder is need isn’t buried too deep in windows. For example, C:\Windows\Microsoft.NET\Framework64\v4.0… Read More
2017-02-13 14:21
I use a lot of service accounts when I develop an application (for DB access, web service access, external api access).
Sometimes (with multiple hands in a project) a service account can bec… Read More
2017-02-12 20:11
For some reason my when I create new tables in my development environment all the tables have my username as the schema owner (instead of dbo).
So I came up with a quick script to reset all… Read More
2017-02-11 19:57
Sometimes operations (like drop, etc) will fail on your DB if someone running a command and locking a resource.
So I came up (or found somewhere) a query to tell me what’s current… Read More
2017-02-10 17:03
I don’t pay too much attention to what’s in the web.config so I always learn something when someone asks me how/why something works in the web.config.
When you see maxRequestLeng… Read More
2016-01-13 21:33
Here is script to get the file sizes of your db files:
The results are ordered by the file size descending.
So you can see what’s taking up all your hard drive space.
select physical_n… Read More
2013-11-11 21:03
If you have a connection to a database through entity framework and you need to switch it to another database (with the exact same structure) you just need to set the Connection.ConnectionSt… Read More
2013-10-11 15:05
Thanks to Tulsa Tech Fest for letting me present.
Attached is my presentation about SQL Support Scripts.
In the notes are the links to the scripts.Tulsa TechFest 2013 Presentation
I hope you… Read More
2013-10-11 05:37
This script will list all indexes and their types (clustered/nonclustered).
SELECT so.name AS TableName
, si.name AS IndexName
, si.type_desc AS IndexType
FROM… Read More
2013-10-10 20:03
This script will provide a list of all stored procedures in a database along with the create script for each.
SELECT specific_name, routine_definition
FROM information_schema.routines… Read More
2013-10-10 19:20
Here is a script that will provide a summary of jobs that ran last night.
This is helpful if you want a summary of your jobs instead of an email from each job.
(You can setup one job to just… Read More
2006-06-07 11:16
Here is a script to check index fragmentation. This is helpful if you need to determine if you need to rebuild indexes. SELECT dbtables.[name] as ‘Table’, dbindexes.[name]… Read More
2006-06-07 11:16
If you need to interface with SQLite there are a couple of steps. 1) You need to get the .net provider for SQLite from sourceforge.net 2) Then add a reference to System.Data.SQLite to your p… Read More
2006-06-07 11:16
Here is some code to get a list of identity columns in database. select so.name as TableName, + o.list as IdentityColumnName from sysobjects so cross apply (SELECT column_name + case when ex… Read More
2006-06-07 11:16
Here is some code to use to check if a database exists. Just replace the string ‘DATABASE NAME’. SELECT * FROM [master].[sys].[databases] WHERE name='DATABASE NAME' Read More
Subscribe to Random Technical Thoughts | Things I Want To Remem
Get updates delivered right to your inbox!