Directly from the SQL Server Release Service blog, here the latest updates for SQL Server 2012 SP2 and SP3:
Cumulative Update #1 for SQL Server 2012 SP3
Cumulative Update #10 for SQL Server 2012 SP2
Additionally, Microsoft announced the release of TLS (Transport Layer Security) 1.2 support for SQL Server 2008, 2008 R2, 2012 and 2014. Read more here.
Stay Tuned! 🙂
One of the most common issue you can find when source controlling the database is about the security. How to manage the users and the related permissions?
If you use to apply permission to users and to assign users to the database, this can be a problem, especially when you are in the deployment phase (or else when getting latest versions from the source control). Let’s see these two scenarios:
Continue reading “How to manage SQL Server security with SQL Source Control”
After SQL Saturday Pordenone, I’ll keep speaking about DLM (aka ALM on databases) during the following events:
.Net Campus a Roma
, May 30, I’ll speak about continuous integration with SQL Server (source control, unit testing, deploy).
There’s a lot of work to do. But I’m thinking now about two or three new sessions. I hope to finish them in the last months of the year, and I hope to meet you in one of these events, at least online.
Recently Michael suggested me a lightweight framework for accessing and manipulating data with SQL Server. I’ve tried it and I’ve found some misunderstanding on the official documentation. The framework I’m speaking for is Simple.Data, a very user-friendly, simple-to-install, quick-to-apply, open and lightweight framework.
After some tests I’ve started to write down an article, that should be taken like a reference due to missing information on official documentation.
You can find it here (in italian).
Hope this helps!
Stay Tuned! 🙂
EssentialSQL.com is a very useful resource for learning SQL Server.
As in the website homepage: “Now it is time to learn SQL in simple English.”
Kris would like to reach the following goals:
- Get started in an easy to follow step-by-step manner.
- Use reader’s time wisely (focusing on what is important to learn to get the most value from your time).
- Answer the questions.
I’ve found this interview very interesting. We’ve spoken about my favourite topics, like Source control on database and database unit testing. This is my job, everyday.
We’ve spoken also about worst practices I saw in my past experiences and then he asked me to give some suggestion to people who start to explore SQL Server.
Stay tuned! 🙂
My SQL Saturday Parma slide decks are available to download on SlideShare.
Concepts: ALM/DLM, team work, differences between code and databases.
Stay Tuned! 🙂
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 “LepideAuditor for SQL Server review”