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.
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! 🙂
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! 🙂
Directly from the Microsoft Release Service blog, here is the list of latest updates for SQL Server 2012 and 2014 RTM:
SQL Server 2012
SQL Server 2012 Service Pack 2 RTM
Fix of SP2 issue (described here)
SQL Server 2014 RTM
Cumulative Update #2 for SQL Server 2014 RTM
Stay Tuned! 🙂
I’ve already spoken about source controlling database using Visual Studio Online and Red-Gate SQL Source Control in this post. The described kind of approach brings a drawback, due to the nature of the plugin and VSO APIs: High latency when getting and syncing local database and workspaces.
Due to this problem, I’ve changed my settings when linking my databases, switching them from “Team Foundation Server (TFS)” to “Working folder“, as in the following picture:
Continue reading “SQL Server with Red-gate SQL Source Control – Working folder management with TFS”
Directly from the Microsoft Release Service blog, here is the list of latest updates for SQL Server 2012 SP1:
SQL Server 2012 SP1
Cumulative Update #10 for SQL Server 2012 SP1
Additionally, a good news for SQL Server 2008 and 2008 R2 here.
Stay Tuned! 🙂
In previous posts, I’ve spent a lot of words speaking about third party add-in for SQL Server Management Studio.
Finally we have developed a new extension! We’re proud to present….
Continue reading “Engage IT Services SQL Todo Explorer – our *FIRST RELEASE*!”
I’ve spoken about SSMS Boost in this post and now I’m going to apply one of its feature in order to improve the productivity of my team. Speaking about the database side, a table that contains static data can be used as a foreign key referenced table. In my experience those kind of tables are often mapped to enums in our application layer. Creating that enum can be a tedious operation and sometimes it can be very uncomfortable. With SSMS Boost we can enhance our development experience. Continue reading “Create C# enum template with SSMS Boost”
Directly from the Microsoft Release Service blog, here is the list of latest updates for SQL Server 2008 R2 SP2 and 2014 RTM (actually, for 2014 is also the first 😉 ):
SQL Server 2008 R2 SP2
Cumulative Update #12 for SQL Server 2008 R2 SP2
SQL Server 2014 RTM
Cumulative Update #1 for SQL Server 2014 RTM
Please note that there is an issue that affects the packaging of CU1 that is causing a failure during slipstream installation. More details on this KB Article.
Stay Tuned! 🙂
Alessandro Alpi's Blog 