Viewing 15 posts - 2,236 through 2,250 (of 2,355 total)
Microsoft's move in this area does not surprise me.
Simply put, they were not making money on this program. They probably are making lots of money on the...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
September 5, 2013 at 3:31 pm
I can tackle this. I have a good one in place in all of my databases. The script has been passed around the block many times.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
September 4, 2013 at 11:54 am
Gee, this sure sound like using BCP in character based mode would do the trick.
BCP DatabaseName.schema.table OUT FileName.csv /m 100 /b 100 /e TableName.err /c /t\, /r /S ServerName /T...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 15, 2013 at 10:35 am
This appears to be a significant design flaw.
The first question is would address be considered an entity, or is address really an attribute of Other entities? :Salesman has address"...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 15, 2013 at 9:45 am
Good job on the article, BUT.
If you think that this is a solution, and are planning on relying on this as some sort of protection from stupid, it's not. There...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 9, 2013 at 3:57 am
Why is shorter better?????
This is the fight I have had with developers for years. They provide the argument that "ThisIsTheProductionDatabase" is too much typing, so they name it...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 1, 2013 at 9:56 am
I have used SQL Recon with great success.
http://www.specialopssecurity.com/labs/sqlrecon/
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
July 16, 2013 at 1:08 pm
This may be a bit of a DUHHHHH, but who owns these jobs???
I seem to remember, a long time ago, in a galaxy far away, the same issue when the...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
June 20, 2013 at 1:45 pm
webbies (5/17/2013)
I have a database that contains 2 tables (sql server 2008):
LenderCommission
ID int
Commission decimal
CommissionTier
ID int
MinCommission decimal
MaxCommission decimal
I want to create a relationship between the 2 tables. The obvious way would...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 17, 2013 at 7:07 am
Not sure what you mean here. All of the numbers are decimals.
Are you looking for the values that are a whole number?
1.0, but not 1.1???
This may work
SELECT *...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 17, 2013 at 6:58 am
That's your answer. Account_id is the primary key. It is already unique. The use of distinct will produce the same number of rows as the query without...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
April 26, 2013 at 3:21 am
tushaar.kudalkar (7/27/2009)
HiU need to stop the server services or else u will not be able to move ur .mdf and .ldf files
This is not true. The only time you...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
April 22, 2013 at 11:37 am
Lynn Pettis (4/9/2013)
This help?
SELECT
DATEPART(WEEK, DATEADD(MONTH, +3, getdate())),
dateadd(week,datediff(week,0,getdate()),5),
DATEADD(MONTH, +3, dateadd(week,datediff(week,0,getdate()),5));
The calander table is about as elegant as it gets....
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
April 9, 2013 at 2:28 pm
You could do some ugly manipulation to create the date.
Or, you could create a calendar table and simply query it.
This is one article on nthis site; there are others....
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
April 9, 2013 at 1:38 pm
I have an idea.
This debate can go on for another 20000 pages of posts, and it will still be confusing, misleading, and certainly not productive.
Remember the pointof this...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 26, 2013 at 11:41 am
Viewing 15 posts - 2,236 through 2,250 (of 2,355 total)