kingdonshel (1/15/2013)

---

I was wondering has anyone ever written a regular expression thatreurns a boolean for wether a phone number is a valid phone number in the US...

Leveraging the validation built into the System.Net.Mail.MailAddress constructor is clever and I did not have to set trustworthy on to use it. The RegEx version is nice too. I wonder...

sjimmo (1/15/2013)

---

This is good as long as nobody...

What does this query yield?

SELECT DISTINCT

PERSONID AS EmpID,

CONVERT(NUMERIC, 722) AS ClockNo, -- we know...

aykut canturk (1/15/2013)

---

okay, not related with this topic but if I use ms azure for hosting instead of renting my own physical one, would I guarantee that my sql data...

ScottPletcher (1/14/2013)

---

opc.three (1/14/2013)

---

YSLGuru (1/14/2013)

---

opc.three (1/12/2013)

---

AD Groups as SQL Logins and Database Users work great unless you need the User to have a default schema. In SQL 2012 the loop has...

YSLGuru (1/14/2013)

---

opc.three (1/12/2013)

---

AD Groups as SQL Logins and Database Users work great unless you need the User to have a default schema. In SQL 2012 the loop has been closed,...

I do not condone using xp_cmdshell at all, and especially not for something like this, but if you must here is someone who has detailed the technique from beginning to...

sqlfriends (1/14/2013)

---

I ask because our network people are investigating some SAN I/O issues.

They are wondering the backup or restore could generate a lot of I/O and cause problems.

They...

Yes.

It depends on where the backup file resides, whether compression is on...

I do not think so. SUSER_NAME() does not have a restriction related...

It depends on what other controls are in place. If you have a firewall blocking 1433 requests from untrusted networks then the SQL Server will never even see the request....

rynmthw3 (1/14/2013)

---

I am setting up the Resource Governor on one of my servers and it creates a function in the master database. The function is used to point Users...

Ed Wagner (1/14/2013)

---

Now I see the trouble with what you were asking. Does this give you what you're after? It uses a correlated subquery [child] to concatenate the...

Dung Dinh (1/14/2013)

---

Hi all,

I have a request from my client that they need to export data to an excel using BCP command and the excel file is with format:

Row 1:...