Forum Replies Created
Viewing 11 posts - 61 through 72 (of 72 total)
-
RE: Contained database
c4ntaloop (7/11/2013)
Thanks Steve.So that makes me think in what real scenario do we want to use contained database? We know that it can have contained users and solve collation issue,...
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 -
RE: Reason for Migrating SQL 2012 to SQL 2014
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 - if In-Memory-OLTP...
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 -
RE: error logging and Transaction Rollback
Catch the stuff you want to log inside a Variable. After the rollback you can still insert from that variable - it does not get emptied.
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 -
RE: Problems moving Report Server catalog
very good.. I will try that myself anyway, it seemy like its worth an extra practice.
Sorry for hinting you in the wrong direction, but I think the encryption-topic is definetely...
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 -
RE: Problems moving Report Server catalog
Hi, I'm sorry
was just a good guessing, since I have no time to test it presently.
Next week I'll have a Class in Reporting-Services.....
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 -
RE: Problems moving Report Server catalog
and Re-encrypted the DATABASE-Master Key with the new Service Master Key?
ALTER KEY -- DB MAster Key
ADD Encryption -- service master key or your password for testing
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 -
RE: How to fix a non-indexed huge table?
>>or you could just exec sp_rename...
which is not the point I was trying to make - I was trying to stress was the GUI (which USES sp_rename) actually DOES
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 -
RE: HELP to connect to MSSQL server
Also check in the "Properties of the Server - Security Settings" from the Server in Enterprise manager whether mixed authentication is enabled - that user you are using in your...
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 -
RE: How to fix a non-indexed huge table?
I totally aggree on Jeff, except that the "rename" of the new well designed table won't be a "snap". Rename is just not possible with SQL. It might look like...
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 -
RE: alert question
With SQL 2005 you can easily implement a DDL-Trigger in the database.
like
CREATE TRIGGER log_ddl_statements
ON Database
FOR ALL_DDL_STATEMENTS
AS
"Code for raiserror with log and log into table"
AW
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 -
RE: Problems moving Report Server catalog
I am not quite sure and cannot test it right now. Bute maybe it goes this direction:
The encryption key inside that Catalog database is secured by the Service master key...
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
Viewing 11 posts - 61 through 72 (of 72 total)