4,784 reputation
11340
bio website billfellows.blogspot.com
location Kansas City, MO
age 39
visits member for 3 years, 3 months
seen 27 mins ago

Developer, devourer of pie, disciple of databases, dictator of datum, drinker of tea, delirious with alliterative devices

@billinkc


51m
comment Backup without using SQL Server Management Studio
Just being obnoxious. ;) I'd have gone sqlcmd route myself but was just pointing out the capability and infatuation with PS many DBAs have
56m
comment Backup without using SQL Server Management Studio
Needs moar PowerShell
1h
revised Backup without using SQL Server Management Studio
deleted 16 characters in body
23h
comment Can't see some stored procedures in sys.procedures
Have you thought about not building html in SQL? Query the metadata tables as you are and use a proper language for string building/html emission?
2d
answered sql server date issue
2d
comment sql server date issue
Is that really the query or have you altered it? I see a RIGHT OUTER JOIN with no join criteria specified
2d
comment sql server date issue
I think in your haste to simplify your long code, you've obliterated our ability to understand the problem. It appears you have an issue with the displayed format of a column. Is this merely a presentation issue or is the data itself getting converted? Also, in your opening paragraph, you indicate it's a mm-dd-yyyy format but later on you indicate it's mm/dd/yyyy not dd/mm/yyyy format as expected.
2d
revised sql server date issue
formatting
Sep
15
awarded  Notable Question
Sep
8
revised SQL import data when both source and destination has data and identity column
I felt this needed more hand drawn diagrams. <3
Sep
4
awarded  Investor
Aug
29
reviewed No Action Needed Login failed for user 'x'. Reason: Could not find a login matching the name provided
Aug
29
reviewed Approve suggested edit on Users Characteristics
Aug
29
comment Modeling global and private parameters
You have a typo in PackageParameters - ParameteScope Why do you abbreviate Params for global but spell it out on the Client/Package tables? I assume it's intentional that you singular Job/Client/Package and pluralize the Params/Parameters tables? Could you provide some examples of your various parameter data? The examples I'm thinking of don't smell right
Aug
27
comment SQL Server Data access does not connect unless we provide the port number
windowsupdate.microsoft.com
Aug
26
comment Best approach for populating date dimension table
I however approve of using yyyymmdd as your surrogate key for the date dimension. That column isn't exposed to users so no worries about them querying for years of 91256712.
Aug
26
comment Best approach for populating date dimension table
DateId is an identity? As a general rule, I'm opposed to smart keys but date dimension is the one place where I not only find it forgivable, I prefer it. What value is there in creating a column called DateTime? It's never going to have more than one time per day. What about Holiday name. Is this supposed to just be Federal holidays? What if there's overlapping holidays? Finally, why do you care about a "best approach" for populating a date dimension. It could take 5 minutes to populate and then it's done for the rest of the data warehouse's life. It basically the one thing that never changes.
Aug
22
comment How to enforce the structural constraints of rectangularly arrayed data?
Is this purely to validate plates are of a particular configuration? Would you process a 2x3 well differently than a 4x6? Based on your sample well data points, could one think of a well as some multiples of 2x3?
Aug
22
answered Replicating a View to a Table. Issues with schema binding, view indexing
Aug
22
comment Replicating a View to a Table. Issues with schema binding, view indexing
Are you pushing the data from Dev to Prod on a periodic basis or are you periodically copying the data from the tables that comprise the Customers view into the physical table Customers?