Tuesday, May 7, 2013

[SQL 2012] SQL Server 2012 New Features

[SQL 2012] SQL Server 2012 New Features

SQL Server 2012 New Features

Posted: 07 May 2013 12:35 AM PDT

I'm asking this question for two reasons:1. I'm just plain curious.2. I'm hoping this will help me make the business case for an upgrade from SQL 2008.Question: Regarding SSIS, SSRS, and SSAS what are you favorite new features you have enjoyed the most or found the most helpful in SQL Server 2012 that you consider worthy to have over SQL Server 2008?Thank You all in advanced.JamesNT

Restore of .bak file returns error: 13(The data is invalid.)

Posted: 06 May 2013 12:34 PM PDT

Hello all....maybe someone can help me out - or break the bad news to me...[b]Restore error:[/b] 13 (The data is invalid).[b]Error Log information:[/b]"05/06/2013 19:28:13,Backup,Unknown,BackupIoRequest::ReportIoError: read failure on backup device 'F:\Backups\ToBeRestored\FullBackup.bak'. Operating system error 13(The data is invalid.).05/06/2013 19:28:13,Backup,Unknown,Error: 18210<c/> Severity: 16<c/> State: 1."[b]Product:[/b] Sql Server 2012 SP1[b]OS:[/b] Windows Server 2008 R2 Standard SP1I have googled my (what's left of my) brains out with this error....and all I have found is that it may lead to insufficient disk space; however, I'm leading towards it being corrupt.I have run RESTORE FILELISTONLY and verified the file sizes...and according to that - I have enough disk space (with 100GB+ to spare).I have run RESTORE HEADERONLY just to see if that would run.I do get the same error (13 The data is invalid) when I try to run RESTORE VERIFYONLY.This area definitely isn't my forte....so I apologize if this is a stupid question (or if I have posted in the wrong forum) :-)Is there ANY way to get find out what is causing the error - or to even get this data restored if it is a corrupt backup?Thanks so much!

Cannot Start Cluster service in Windows server 2012:

Posted: 07 May 2013 01:30 AM PDT

Hi,I got the following error while starting the clustering service in windows server 2012. Error 1297:A privilege that the service requires to function properly does not exist in the service account configuration.You may use the services Microsoft Management Console(MMC) snap-in and the local security settings MMC snap-in (secpol.msc) to view the service configuration and the account configuration.Kindly provide the solutions ASAP.

do I need locking or what's the best way to do this ?

Posted: 06 May 2013 05:20 PM PDT

dear friends,I need to implement a code in my application that updates monthly revenues when any transaction occurs. meaning:after this statement executes:INSERT INTO Transactions (amount, transactiondate, companyID) VALUES (3.5, transactiondate, SomeCompanyID)the following code should run:IF EXISTS( SELECT * FROM Revenues WHERE companyID=SomeCompanyID AND month = DATEPART(mm,transactiondate) ) -- update revenue table UPDATE Revenues SET Revenue = Revenue + amount WHERE companyID=SomeCompanyID AND month = DATEPART(mm,transactiondate) else INSERT INTO Revenues (Revenue, Month, CaompanyID) VALUES (amount, DATEPART(mm,transactiondate) , SomeCompanyID)endAs far I I see I can do that in sp or in my aspnet application with code. my first question is which one should I choose and second one is if I do that in code side, should I need some kind of tablelock. Please note its very likely that there can be multiple transaction at exactly same time as there is heavy usage. What I'm afraid of is right after EXISTS statement runs, some other process inserts a new record just before UPDATE command is executed. is that possible ? can this worst case scenario happens if I use sp ? it can obviously happen if I use aspnet code. Am I right ? what do you suggest ? have a wonderful day:-)

SQL 2012 AG/FCI Failover

Posted: 15 Apr 2013 06:43 PM PDT

Hi AllMy Setup:>> 3 Servers (Node1-Node2-Node3) all part of the same Cluster "Cluster1">> SQL installed as clustered on Node2 & Node3, producing "SQLCluster">> SQL installed as nonclustered on Node1, producing "Node1\SQL">> Availability Group has been set up between "SQLCluster" & "Node1\SQL"Quorum: What is the recommended Quorum configuration for my setup, I'm assuming Node majority.DTC: Should all the nodes be a possible owner of DTC? Should the DTC disk be presented to all the nodes?Failover: When configuring the failover mode, I am unable to change it to Automatic, is Automatic failover not supported when you combine an AG with an FCI or am I missing something?Thanks

unexpected SQL server 2012 shutdown

Posted: 06 May 2013 09:39 PM PDT

Hi,I have installed 3 new instances of SQL Server 2012 on a stand alone server. SQL Service is set to automatic on all of them. Yet, suddenly, all the instances have shut down abruptly throwing the following errors. Need some advice around this issue?SQL Server must shut down in order to recover a database (database ID 2). The database is either a user database that could not be shut down or a system database. Restart SQL Server. If the database fails to recover after another startup, repair or restore the database.During undoing of a logged operation in database 'tempdb', an error occurred at log record ID (438:376:163). Typically, the specific failure is logged previously as an error in the Windows Event Log service. Restore the database or file from a backup, or repair the database.

Certification Practice Exams

Posted: 06 May 2013 08:09 AM PDT

Having passed the 70-450 and 70-451 I'm now starting to work on my MCSE and MCSA. I've been researching practice tests and found ActualTests to be the best deal.What I'm wondering is what kind of quality they are? Does anyone have some experience with them? I've tried Measureup and Transcender and quite liked both of them.

SQL Server 2012 Evaluation (Trial) or Beta Version?

Posted: 06 May 2013 06:48 AM PDT

We are in the process of setting up a Windows Server 2008 R2 Standard Edition SP1 64 Bit machine where we plan to install SQL Server 2012. When I look at the Microsoft Site for a free download of SQL Server 2012, it says "Download free full-featured trial and beta versions of SQL Server that you can use for up to 180 days." Does this mean there is a trial version and a beta version? Or is this one and the same version?http://www.microsoft.com/en-us/sqlserver/get-sql-server/try-it.aspxOr should I download SQL Server 2012 SP1 (evaluation) from the Technet Evaluation Center?http://technet.microsoft.com/en-US/evalcenter/hh225126I want to make sure I download the right version, that is, free, full-featured (standard or enterprise) and get to use it for about 6 months. I notice at this point it does not state whether it is standard or enterprise edition.Thanks, Kevin
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog