My dream job can not be posted here. Sorry, it is illeagal and I am not even sure it is possible untill the olympics are over. My 2nd and 3rd...

I worked in a stack & rank system as a manager and it is frustrating. My team of DBA's did manage to break the curve quite frequently. I would be...

Steve says: Lie down on zee couch. What seems to be the problem?

DBA: "I've got a small situation here."

Steve says: Small man complex?

DBA: "I've got a SPID that don't...

Gut Feel is a baby boomer approach. The old "establishment" managers and politicians just need to retire...:)

-- comparing rows

SELECT B.CASE_ID, B.[USER_ID] , E.END_DATE, B.BEGIN_DATE, datediff(MINUTE,E.END_DATE,B.BEGIN_DATE) as Diff

INTO #WORK

FROM (select ROW_NUMBER() OVER (ORDER BY [USER_ID]) AS 'RowNumber', *

from CASE_DATA) B

inner join (select (ROW_NUMBER() OVER (ORDER BY...

Rebranding distributed computing, calling it a "cloud" is a huge marketing success but it doesn't take an evil genius to realize this "cloud" stuff suffers from the same fundamental flaws...

.net stuff

http://www.homeandlearn.co.uk/net/vbnet.html

http://www.google.com/url?sa=t&rct=j&q=.net%20basics%20tutorial&source=web&cd=3&ved=0CFgQFjAC&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F8%2Fe%2F7%2F8e725d96-7ec3-498b-9fa7-86779aed101f%2Fdotnet%2520tutorial%2520for%2520beginners.pdf&ei=Hvf2T_uBHefo0QHg3ui9Bg&usg=AFQjCNGMBVWUAloXCkrDy6q7BCidxw_zQA PDF tutorial

http://asp.net-tutorials.com/basics/introduction/ ASP tutorial

powershell stuff

http://www.powershellpro.com/powershell-tutorial-introduction/tutorial-windows-powershell-console/ use sidebars to nav

http://powertoe.wordpress.com/2009/11/10/powershell-part-1/ navigate thru it

http://technet.microsoft.com/library/ee332526.aspx task based

I'd suggest picking to learn one or two language flavors...

Cloud computing is just another executive buzz word Ponzi scheme to con a bunch of money out of the everyday honest IT/DBA/Developer workman. Let's join the cloud AND fire a...

NARF

Eric M Russell (7/3/2012)

---

I'd suspect that the higher failure rate for white-box (versus brand name) PCs can be attributed to how the components are installed and paired up with other...

summing it up for you upper management type:

1. Buy your DBA's Laptops they fail less

2. You need to burn in desktops longer

3. If anything Failed it means replace...

I'd like to see the linux/Unix community do a similar study on their installed user base. Better not hold your breath the Unix guys will complain they can't do it...

Convert that big phat server to VM, run each seperate instance as a individual guest.

DECLARE @cmdVARCHAR(100),

@spidVARCHAR(4),

@sqlVARCHAR(100),

@timeDATETIME,

@loginnameVARCHAR(100)

if OBJECT_ID('TEMPDB..#TempConn2') is not null

DROP TABLE #TempConn2

create table #TempConn2

(EventType nvarchar(30), Parameters Int,EventInfo nvarchar(4000),SPID INT NULL,loginname VARCHAR(100)NULL)

--blocking

DECLARE my_cursor CURSOR FOR

SELECT [SPID],loginame

FROM sys.sysprocesses

where...

DECLARE @db_name sysname, @sql nvarchar(max)

--

IF OBJECT_ID('tempdb..#Results') IS NOT NULL

DROP TABLE #Results;

IF OBJECT_ID('tempdb..#Databases') IS NOT NULL

DROP TABLE #Databases;

--

CREATE TABLE #Results (DatabaseName sysname, TableName NVARCHAR(128), crdate datetime);

CREATE TABLE...