Viewing 15 posts - 46 through 60 (of 72 total)
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,...
Andreas
---------------------------------------------------
MVP SQL Server
Microsoft Certified Master SQL Server 2008
Microsoft Certified Solutions Master Data Platform, SQL Server 2012
www.insidesql.org/blogs/andreaswolter
www.andreas-wolter.com
September 2, 2013 at 1:17 pm
WendellB (8/30/2013)
Andreas
---------------------------------------------------
MVP SQL Server
Microsoft Certified Master SQL Server 2008
Microsoft Certified Solutions Master Data Platform, SQL Server 2012
www.insidesql.org/blogs/andreaswolter
www.andreas-wolter.com
August 30, 2013 at 4:18 pm
Perry Whittle (8/29/2013)
Andreas
---------------------------------------------------
MVP SQL Server
Microsoft Certified Master SQL Server 2008
Microsoft Certified Solutions Master Data Platform, SQL Server 2012
www.insidesql.org/blogs/andreaswolter
www.andreas-wolter.com
August 29, 2013 at 2:46 am
Perry Whittle (8/28/2013)
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
---------------------------------------------------
MVP SQL Server
Microsoft Certified Master SQL Server 2008
Microsoft Certified Solutions Master Data Platform, SQL Server 2012
www.insidesql.org/blogs/andreaswolter
www.andreas-wolter.com
August 28, 2013 at 12:31 pm
Andreas Wolter-332291 (8/28/2013)
HanShi (8/28/2013)
Andreas Wolter-332291 (8/28/2013)
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...
Andreas
---------------------------------------------------
MVP SQL Server
Microsoft Certified Master SQL Server 2008
Microsoft Certified Solutions Master Data Platform, SQL Server 2012
www.insidesql.org/blogs/andreaswolter
www.andreas-wolter.com
August 28, 2013 at 3:56 am
HanShi (8/28/2013)
Andreas Wolter-332291 (8/28/2013)
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...
Andreas
---------------------------------------------------
MVP SQL Server
Microsoft Certified Master SQL Server 2008
Microsoft Certified Solutions Master Data Platform, SQL Server 2012
www.insidesql.org/blogs/andreaswolter
www.andreas-wolter.com
August 28, 2013 at 3:36 am
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
---------------------------------------------------
MVP SQL Server
Microsoft Certified Master SQL Server 2008
Microsoft Certified Solutions Master Data Platform, SQL Server 2012
www.insidesql.org/blogs/andreaswolter
www.andreas-wolter.com
August 28, 2013 at 3:13 am
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...
Andreas
---------------------------------------------------
MVP SQL Server
Microsoft Certified Master SQL Server 2008
Microsoft Certified Solutions Master Data Platform, SQL Server 2012
www.insidesql.org/blogs/andreaswolter
www.andreas-wolter.com
August 27, 2013 at 3:56 pm
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,...
Andreas
---------------------------------------------------
MVP SQL Server
Microsoft Certified Master SQL Server 2008
Microsoft Certified Solutions Master Data Platform, SQL Server 2012
www.insidesql.org/blogs/andreaswolter
www.andreas-wolter.com
August 25, 2013 at 6:24 pm
dokledon (8/25/2013)
I don't think you can have more than 1 default instance.
That's true for Standalone SQL, but I was wondering for Cluster SQL, since the VIP Name (SQL...
Andreas
---------------------------------------------------
MVP SQL Server
Microsoft Certified Master SQL Server 2008
Microsoft Certified Solutions Master Data Platform, SQL Server 2012
www.insidesql.org/blogs/andreaswolter
www.andreas-wolter.com
August 25, 2013 at 12:10 pm
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
Andreas
---------------------------------------------------
MVP SQL Server
Microsoft Certified Master SQL Server 2008
Microsoft Certified Solutions Master Data Platform, SQL Server 2012
www.insidesql.org/blogs/andreaswolter
www.andreas-wolter.com
August 25, 2013 at 9:50 am
arr.nagaraj (8/22/2013)
Andreas
---------------------------------------------------
MVP SQL Server
Microsoft Certified Master SQL Server 2008
Microsoft Certified Solutions Master Data Platform, SQL Server 2012
www.insidesql.org/blogs/andreaswolter
www.andreas-wolter.com
August 22, 2013 at 4:11 am
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...
Andreas
---------------------------------------------------
MVP SQL Server
Microsoft Certified Master SQL Server 2008
Microsoft Certified Solutions Master Data Platform, SQL Server 2012
www.insidesql.org/blogs/andreaswolter
www.andreas-wolter.com
August 14, 2013 at 10:52 am
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...
Andreas
---------------------------------------------------
MVP SQL Server
Microsoft Certified Master SQL Server 2008
Microsoft Certified Solutions Master Data Platform, SQL Server 2012
www.insidesql.org/blogs/andreaswolter
www.andreas-wolter.com
August 3, 2013 at 2:52 pm
Jason-299789 (7/30/2013)
Andreas Wolter-332291 (7/16/2013)
Andreas
---------------------------------------------------
MVP SQL Server
Microsoft Certified Master SQL Server 2008
Microsoft Certified Solutions Master Data Platform, SQL Server 2012
www.insidesql.org/blogs/andreaswolter
www.andreas-wolter.com
July 30, 2013 at 10:44 am
Viewing 15 posts - 46 through 60 (of 72 total)