|
|
-
|
|
2003, 2008, 2008 R2
SQL Server 2000, 2005, 2008, 2008 R2, 2012
*/
sp_configure 'show advanced options',1
RECONFIGURE WITH OVERRIDE
GO
sp_configure 'xp_cmdshell',1
RECONFIGURE WITH OVERRIDE
GO
DECLARE @TimeZone NVARCHAR(100)
,@ProductVersion SYSNA...
|
|
-
|
|
Today, I am going to share few very useful scripts which will report us on Database Backup from different view points. To get the List/History/Log of all the Successful Backups SELECT b.machine_name, b.server_name, b.database_name...
|
|
-
|
|
It's my bad that I did not made a post since long lately. I would not make an excuse like I was busy, rather, I would say I am little lazy DBA, but I now onward I will try to post blog more frequently.
Well, if you remember, earlier I have posted som...
|
|
-
|
|
`As we all are aware SQL Server 2012 virtual launch is scheduled after 60 hours roughly. Earlier I have discussed what’s new in SQL Server 2012 setup, MS has released SQL Server 2012 training kit and made it available for us to download. In recent past, I ...
|
|
-
|
|
Microsoft has released one more free eBook, this time it is on SQL Server 2012. However, this is the second draft of this book. SQL Server MVP Ross Mistry and Stacia Misner has covered Administration and BI part, there are 10 chapters in total divided in t...
|
|
-
|
|
Yesterday night one of FB Friend have ping me, he has issue with his local SQL Server instance. Our conversation goes like: FB Friend: Hi I : Hi FB Friend: I need your help FB Friend : My SQL Server is not starting... I : What is an error you are gett...
|
|
-
|
|
Datacentre Edition is no longer available as a MS SQL Server 2012 RC0 candidate, Read More MS SQL Server 2012 RC0 includes new edition – SQL Server Business Intelligence, Read More Service Pack 1 is the minimum requirem...
|
|
-
|
|
Microsoft has released SQL Server 2010 Developer Training Kit which includes :
Labs
Demos
and, Presentations
This kit will greatly help you learning Developer and BI Solutions.
One will require to have Windows 7 or Windows Server 2008 R2 to install...
|
|