Very nice, simple and straightforward.

I've never had the need for it, but there is talk about moving out SQL Servers to a different domain. It scares me. I'm...

WayneS (1/29/2016)

---

Ed Wagner (1/28/2016)

---

SQLRNNR (1/28/2016)

---

BrainDonor (1/28/2016)

---

I've just discovered Redgate's 'Tab History' button.

Where was that at my last place of work? That little gem could have saved me hours of agony.

Hunting...

I saw a great presentation on temp tables and table variables that explored, among other things, the different approaches to creating temp tables. it punched holes in many of...

Jeff Moden (1/29/2016)

---

xsevensinzx (1/29/2016)

---

Eric M Russell (1/28/2016)

---

On the flip side, as a job seeker you should also be suspicious of "opportunities" which seem to always be available. For example, there...

Let me start out by saying that I'm nowhere near being an Access expert.

First, I've heard of Access linked table "just breaking" for no apparent reason. Can you break...

Jeff Moden (1/29/2016)

---

Yes. I'd...

Once you get the syntax of the format file down, the BULK INSERT command is a rock-solid approach. You get to control the data type and maximum length of...

Luis Cazares (1/29/2016)

---

Bad practice. I didn't see it was a 2012...

yb751 (1/29/2016)

---

Nice Luis...my 'mad' skills are quite up to par with you yet. LOL I haven't played around with tally tables yet but it's on my list. I'm...

Luis Cazares (1/29/2016)

---

yb751 (1/29/2016)

---

LOL...yeah now that you mention it, that would be a...

I'm trying to implement better security in the applications at work, but like David pointed out, there are conflicts between good practices and what's realistically possible. I don't want...

Perry Whittle (1/29/2016)

---

APA0876 (1/27/2016)

---

Hi,

This is my current scenario:

Windows Server 2008 R2

SQL Server 2012 Enterprise Edition Active \ Passive Failover Cluster

Intended scenario:

Windows Server...

Luis Cazares (1/29/2016)

---

Koen Verbeeck (1/29/2016)

---

Grant Fritchey (1/29/2016)

---

BL0B_EATER (1/29/2016)

---

Have you guys during your careers ever thought about doing something else in life.. as opposed to IT / SQL Server / Coding...

Ragu Bolognese (Never made Stracotto, but I have a feeling I will...

A simple one to end the week. Thanks.