dmbaker

Forum Replies Created

Viewing 15 posts - 91 through 105 (of 247 total)

RE: Should Production Databases Be in a VCS?

Gary Varga (2/16/2016)
The answer to the Editorial's question is no. Not in a different VCS repository. It should be in the same repository but in a separate branch. This allows...

February 16, 2016 at 7:03 am

#1858970
RE: Muting the Immutable

So, does the ability to include "post deployment" tasks in your SSDT project not help to alleviate this somewhat? This lets you "seed" your database with reference data, at least...

January 18, 2016 at 1:03 pm

#1852578
RE: A Simple Formula to Calculate the ISO Week Number

Thanks for the article...5 stars (especially since you didn't say "performant" anywhere) 😀

October 23, 2015 at 10:52 am

#1835255
RE: What's a Code Smell?

If I say "who wrote this crap"...it's a code smell.
Of course, I'm often the one who wrote it, but that's beside the point. 😀

October 6, 2015 at 7:15 am

#1831727
RE: Retrieving a Binary File from Your Database

Charles Kincaid (5/29/2015)
rasika.nanayakkara (5/29/2015)
I tried this example and found out that Excel and Word documents cannot open and it says they are corrupt.
Since I did not see any mention of...

May 29, 2015 at 6:47 am

#1801553
RE: Retrieving a Binary File from Your Database

But personally, I do like having the option of setting FileMode and FileAccess.
Sure, nothing wrong with wanting more control. It might be better to change this up entirely though, and...

May 28, 2015 at 3:57 pm

#1801420
RE: Retrieving a Binary File from Your Database

Solomon Rutzky (5/28/2015)
Hi Eric. As I mentioned in my comment on your previous article (regarding reading the file), I think this is a good topic and concept, but there are...

May 28, 2015 at 11:55 am

#1801339
RE: Storing a Binary File in a Database
Solomon Rutzky (5/28/2015)
Hi Eric. Good topic. I definitely like the concept, but need to mention a few notes regarding SQLCLR best practices:

!! Critical Issue !!: You open a FileStream but...

May 28, 2015 at 7:12 am

#1801243

RE: Naming Confusion

Eric M Russell (5/21/2015)

dmbaker (5/21/2015)

Eric M Russell (5/21/2015)
Why is including location in server name important for some?

Because when I'm querying a London server from Seattle, I like to know that...

May 21, 2015 at 7:33 am

#1799664

RE: Naming Confusion

Eric M Russell (5/21/2015)
Why is including location in server name important for some?

Because when I'm querying a London server from Seattle, I like to know that I can step out...

May 21, 2015 at 7:22 am

#1799659

RE: Legal / Illegal XML Characters list

Paul Bradshaw (3/18/2015)

I'm having this same issue as the OP of this thread... I cannot find the "problem character" at all. It's at "line 554, character 18", but no...

March 20, 2015 at 7:22 am

#1785335

RE: VB6 application connection timeout errors on Sql Server 2000

Eirikur Eiriksson (3/31/2014)

dmbaker (3/31/2014)

I'm not saying that you should debug the code, I'm saying that you should *insist* that the developers give you the queries being executed when a timeout...

March 31, 2014 at 2:36 pm

#1701801

RE: VB6 application connection timeout errors on Sql Server 2000

I'm not saying that you should debug the code, I'm saying that you should *insist* that the developers give you the queries being executed when a timeout occurs. Is there...

March 31, 2014 at 2:16 pm

#1701791

RE: VB6 application connection timeout errors on Sql Server 2000

tresiqus (3/31/2014)

Thanks, but the problem description I get doesn't have anything specific, typically just a "dropped connections - you need to check the indexes on the server" request. The...

March 31, 2014 at 1:12 pm

#1701760

RE: One size does not fill all

Eric M Russell (3/6/2014)

dmbaker (3/6/2014)

Eric M Russell (3/6/2014)

It's true that by coding batch processing logic within the application, your SQL code can be simplified and constructed in a more cross-platform...

March 6, 2014 at 12:45 pm

#1694852

Viewing 15 posts - 91 through 105 (of 247 total)