SELECT

RANK() OVER(PARTITION BY [Name] ORDER BY [DateTime]) As [EntryOrder]

,[Name]

,[DateTime]

,[EntryPoint]

FROM

(

SELECT 'Billy' As [Name], '2/8/2002 6:00' As [DateTime], 'Back Door' As [EntryPoint]

UNION ALL

SELECT 'Bob' As [Name], '2/8/2002 6:00' As [DateTime], 'Back Door'...

Sounds great! Given that I find positive results working with BIDSHelper, I will likely be having some conversations around getting licenses for Mist in the near to mid-term for...

Agreed! I'm very excited to start using BIML. One of the complaints I've always had about BI (SSRS/SSIS, etc...) is that beyond the SQL code, it's seemed like...

Totally agree with Jeff. Work provided desktop and laptop with VPN/RDP access is the only way I roll (although I will say I have been doing more on my...

I think the recent litany of cloud security breaches rightly justifies concerns about moving enterprise data stores to the cloud environment. I completely understand the draw, especially for smaller...

SQL Kiwi (2/2/2012)

---

No worries. While we're chatting, you might find this interesting too:

DECLARE @Example AS TABLE (col1 integer PRIMARY KEY);

-- Seek

SELECT * FROM...

I finally got around to reading this one! WooHoo! I've been following this normal form series, but I had forgotten about it until the other day and came back...

Personally, I think there should be a certain level of stratification and career pathing within any department. This has become a much more common practice at my company recently,...

Tom.Thomson (7/15/2011)

---

That only works if logic is restricted to black and white (true and false, no other possibilities). Constructive mathematicians work in a world where there are infinitely many...

Tom,

Firstly, great article. I actually stumbled onto it after reading your 2NF article via the link back here, and wanted to start from the beginning. Glad I did...

Yin - Great example...

This is essentially the first step down the primrose path to n00b-Tube City (what I was eluding to in my last post).

We are seeing this happen at...

Barring a catastrophe of global proportions, I think it is theoretically possible to achive a 100% (or at least 99.99%) Always On environment, given that the company/service has the necessary...

While I don't think that all of those things SHOULD become true over the next 10 years, sad to say, most probably will become true... 10 years after that...

I am also weary of moving into "the cloud". I started researching this option as I began drafting the proposal for the future of our App Dev Environment. ...

I'm curious to know if anyone else has encountered an issue with toggling the visibility of the groups and sub groups within the new tablix object in VS/BIDS 2008.

In our...