702 reputation
314
bio website sqeq.com
location Wolverine Lake, MI
age 41
visits member for 3 years, 5 months
seen Aug 21 at 14:25

http://twitter.com/squillman

Christian, Musician, Geek

Primarily a .NET developer / SQL Server dba / Windows sysadmin in a specialized financial applications group. Prior to this position I was in IT for 8.5 years with the same company.

Major interests in computing include software architecture, enterprise systems architecture, UI design, programming languages, and security.

I love God, love my wife and kids, love computers, love my job, love playing and writing music.

squillman = Shawn Quillman


Jul
2
awarded  Curious
Apr
15
awarded  Popular Question
Mar
23
awarded  Yearling
Dec
17
comment SQL Server 2012 Express : How do you limit a database's size and retention policy?
@red888 Yes, it is absolutely acceptable for your program to just check the Db size. It's up to you how you want to manage it. Manual purges are even sometimes preferable to automated purges. You can use sp_spaceused and also sp_helpdb to get he Db size via T-SQL.
Dec
16
answered SQL Server 2012 Express : How do you limit a database's size and retention policy?
Sep
24
comment How can I get a list of tables contained in a database diagram?
OP wants only the tables included in a SQL Server diagram. Not the complete list of tables in the database.
Sep
17
comment SQL Server 2012 x64 - cannot safely allocate more than 50% RAM
@Mark This is Enterprise Edition, yes?
Sep
17
comment SQL Server 2012 x64 - cannot safely allocate more than 50% RAM
Second the vote to migrate to dba. OS is quite on topic for dba work, especially if it seems to be directly correlated to performance of the db platform.
Aug
29
comment Transaction log autogrowth duration
Upvoted that connect item, also.
Aug
29
accepted Transaction log autogrowth duration
Aug
29
comment Transaction log autogrowth duration
Great, that's what I was hoping it was. I could only find that reference where it said ms. I completely had the blinders on and didn't even think to validate against the start/end time fields. I still can't find a reference for XE to confirm, but this proof vs. the start/endtime fields works for me. Thanks, Aaron!
Aug
29
revised Transaction log autogrowth duration
added 78 characters in body
Aug
29
asked Transaction log autogrowth duration
Aug
1
awarded  Citizen Patrol
May
13
awarded  Caucus
Mar
23
awarded  Yearling
Mar
18
comment UNIQUE index key violation
@Robert Thanks! I figured as much... So I should really look at removing the NOLOCK hint is what I'm reading into this. I just was also reviewing the table hints section in MSDN which states that all hints propogate to all objects in the query plan.
Mar
18
asked UNIQUE index key violation
Dec
24
awarded  Quorum
Dec
13
suggested suggested edit on how to convert xml to database table