As of last night, there are now 0 certifications that one can take that I will immediately respect. MCITP/MCTS/MCSA/MCSE tell me that either a person is interested in learning more,...

WendellB (8/30/2013)

---

This is actually a linked table with a Microsoft Access front-end using ODBC, and in typical ODBC fashion, it gives an obscure error code that indicates the user does...

Perry Whittle (8/29/2013)

---

I have never hacked SQL server to attempt this not sure i'd even want to. Not even sure this would actually be possible due to the registry hive...

Perry Whittle (8/28/2013)

---

For clarification

I have a 3 node cluster comprising Node1, Node2 and Node3.

I create a clustered default instance on Node2 and Node3. I then attempt to install an...

Andreas Wolter-332291 (8/28/2013)

---

HanShi (8/28/2013)

---

Andreas Wolter-332291 (8/28/2013)

---

No

again:

"the port has to be unique. But you should be able to just connect via Network Name, and have the SQL Server Browser Service have...

HanShi (8/28/2013)

---

Andreas Wolter-332291 (8/28/2013)

---

No

again:

"the port has to be unique. But you should be able to just connect via Network Name, and have the SQL Server Browser Service have the port...

dokledon (8/28/2013)

---

I say again

Erm, no.whether stand alone or clustered you can only have one default instance, it has nothing to do with separate groups but the registry keys which are...

Andreas,

1) About having unique or multiple default instances inside a cluster, my doubt persist (see HanShi answer. It's a good debate)

2) About Alias, I thought about it. It could solve...

Sorry if my question wasn't very clear.

I have 4 Standalone/Default Instance SQL Servers, and I'm looking for High Availability for them.

I want to create a 2 node Cluster.

On each Node,...

dokledon (8/25/2013)

---

That's true for Standalone SQL, but I was wondering for Cluster SQL, since the VIP Name (SQL...

Yes, unfortunately you have to manually combine the msdb backup history data across all replicas. Which one can actually include a backup is statet in sys.availability_replicas

arr.nagaraj (8/22/2013)

---

For enabling and moving TDE enabled databases certificate backup & private key are sufficient. Exactly under what scenarios you will need SMK backups , DMK backups or restore SMK...

You should create procedures which do the select and only grant EXECUTE to those procedures (preferably in a dedicated schema) to that user / role

Same would work with a View...

First of all, opc.three is right: sa is a NO GO

No failed penetration test would ever give you enough confidence, that it cannot be exploitet.

As you notice, those tools each...

Jason-299789 (7/30/2013)

---

Andreas Wolter-332291 (7/16/2013)

---

Even though SQL 2014 is by far not complete in CTP1 and more is to come, you should be ready for a new way of developing Datawarehouses...