I like the idea of using fingerprints for low-level security such as accessing my Smartphone, but I'm less enthusiastic about using it for high-security measures. If I worked in...

DEK46656 (7/27/2016)

---

Regarding emails (at work), I create an annual PST file. As I get the periodic “do you want to archive” I move anything I received or sent for...

maylar (4/7/2016)

---

So far the online docs have been worthless. I don't need to learn about databases, I just need to understand how to navigate within this admin tool. I've worked...

maylar (4/5/2016)

---

MadAdmin (4/5/2016)

---

In SSMS, Click on

VIEW\Template Explorer OR Ctrl+Alt+T

and you will have a list of most stuff.

So you dont have to remember syntax of how to create table,...

MadAdmin (4/5/2016)

---

In SSMS, Click on

VIEW\Template Explorer OR Ctrl+Alt+T

and you will have a list of most stuff.

So you dont have to remember syntax of how to create table, index,...

GPO (4/4/2016)

---

Well... kinda. I don't think I explained myself very well. My apologies. Incrementing integers CAUSE uniqueness. They don't...

Hugo Kornelis (3/30/2016)

---

Frankly, I don't understand why anyone would be interested to compare performance between two queries that do not return the same results. At most one of them can...

I took one of those quickie 2 or 3 day classes in Powershell and thought it was a very interesting idea using the .net framework to expand the power of...

Brandie Tarvin (10/30/2015)

---

Eric M Russell (10/29/2015)

---

Maybe I'm missing something, but the table appears to lack a unique index on the natural key, which would allow duplicates. This would normally be...

David.Poole (3/16/2016)Basically, what you need is a well defined object model and API for your software if you are going to want it automated and that isn't a trivial thing...

Great article. Thanks for sharing.

I have used CTE's on a number of occasions to cure slow-running queries but in my case I believe they worked for entirely different reasons....

When faced with repeatedly doing pattern matching against the database (i.e. the LIKE and CONTAINS clauses), if you have any ability to restructure things or can at least make recommendations...

Great article. Thank you for your efforts.

- Les

Thanks so much for the article. I learned a lot.

- Les

jaakkojuntunen (9/21/2015)

---

Thanks a lot guys for your answers, it has been really busy times, so apologies for a late reply. Unfortunately I read the best practices in posting questions after...