Sql Server: Backup all the databases of the instance

suxstellino (Alessandro Alpi):

ahahahah, thank you Michael :)

Originally posted on .Net Diaries:

security8

They told me (Alessandro Alpi), to don’t blog this :) because there’s a lot of this stuff out there, but this my blog, and it is too cool when developing in load testing environment, and you need to backup, try load test data, and restore previous version, so forgive me about this:

1

Change the “C:_Databases_BackupDatabases” into your default BackupDirectory found in the instance facets, to avoid security problem.

DON’T USE THIS CODE IN PRODUCTION!!

View original

SQL Server latest Updates (Oct. 2014)

Directly from the Microsoft Release Service blog, here is the list of latest updates for SQL Server 2014 RTM:

Cumulative Updates #4 for SQL Server 2014 RTM

 

Additionally, a set of workarounds regarding the Report Builder error introduced in SQL Server 2008 R2 SP3 have been suggested here.

 

Stay Tuned! :)

PASS SQL Saturday Parma Agenda now available!

PASS SQL Saturday Parma agenda is now available!

This is the timetable:
From        To
————————–
10:00       11:00
11:15       12:15
12:30       13:30
13:30       14:30
14:30       15:30
15:45       16:45
16:45       17:00
17:00       18:00
————————–
 
We will have three tracks:
  • BI, for Business Intelligence, BigData, xVelocity, etc.
  • DEV, for developers 
  • OPS, for operations and administration
Checkout the agenda here and organize your Saturday with the schedule builder!
 
Stay Tuned! :)
 
 
 
 

SQL Server latest Updates (Sept. 2014)

Directly from the Microsoft Release Service blog, here is the list of latest updates for SQL Server 2008 R2 and 2012 SP1/SP2:

SQL Server 2008 R2 SP3 released

SQL Server 2008 R2 Service pack 3

SQL Server 2012 SP1

Cumulative Update #12 for SQL Server 2012 SP1

SQL Server 2012 SP2

Cumulative Update #2 for SQL Server 2012 SP2

Additionally, the SQL Server 2008 Service Pack 4 has been released.

 

Stay Tuned! :)

LepideAuditor for SQL Server review

LepideAuditor for SQL Server review

Every day a DBA (or a developer), has to reply to questions like “who changed that table?” or “who tried to login on our production database?”. These answers are not so simple to find out, actually. LepideAuditor for SQL Server is a tool that can helps us to audit operations on a SQL Server instance and to monitor both the server and the database level.

Continue reading

SQL Server latest Cumulative Updates (August 2014)

Directly from the Microsoft Release Service blog, here is the list of latest updates for SQL Server 2014 RTM:

 

SQL Server 2014 RTM:

Cumulative Update #3 for SQL Server 2014 RTM

 

Additionally, here is a security update for 2008, 2008 R2, 2012 and 2014.

 

Stay Tuned! :)

SQL Server latest Cumulative Updates (July 2014)

Directly from the Microsoft Release Service blog, here is the list of latest updates for SQL Server 2008 R2 SP2 and 2012 SP1/SP2:

SQL Server 2008 R2 SP2

Cumulative Update #13 for SQL Server 2008 R2 SP2 (8 July 2014 – end of mainstream support for 2008 and 2008 R2)

SQL Server 2012 SP1

Cumulative Update #11 for SQL Server 2012 SP1

SQL Server 2012 SP2

Cumulative Update #1 for SQL Server 2012 SP2

 

Additionally, here is the SQL Server 2012 with SP2 Slipstream ISO image fix.

 

Stay Tuned! :)