Infrastructure at your Service

SQL Server 2012 Archives - Blog dbi services

Stéphane Haby

Live from SQL Saturday Slovenia 2016!

By | Technology Survey | No Comments

After a little trip, just 1-hour flying from Zürich to Ljubljana yesterday, the SQL Saturday Slovenia 2016 begins this morning at the Faculty of Computer and Information Science of the University of Ljubljana… I needed to wake up very fast because my session was the first of the day at 9:00 AM. I also very happy to meet and to share my expertise with Slovenian and other SQL Server experts. My session was about the…

 
Read More
David Barbarin

SQL Server AlwaysOn availability groups and statistic issues on secondaries

By | Database Administration & Monitoring | No Comments

I would like to share with you an interesting issue you may face while using SQL Server AlwaysOn availability groups and secondary read-only replicas. For those who use secondary read-only replicas as reporting servers, keep reading this blog post because it is about update statistics behavior on the secondary replicas and as you may know cardinality estimation accuracy is an important part of the queries performance in this case. So a couple of days ago,…

 
Read More
David Barbarin

Columnstore index rebuild cannot start

By | Database Administration & Monitoring | No Comments

A couple of weeks ago, I was charged to migrate an SQL Server datawarehouse environment to a more recent version of SQL Server (from 2005 to 2012 in my case). After discussing with my customer we decided to benefit from the nonclustered columnstore index feature to improve reporting queries performance directly executed against the concerned database. So the implementation was successful and we included an additional job that consists in disabling as well as rebuilding…

 
Read More
Nathan Courtine

syspolicy_purge_history job and PowerShell ExecutionPolicy

By | Database Administration & Monitoring | No Comments

Since SQL Server 2008, Microsoft has introduced a system job called “syspolicy_purge_history”. This job is installed and enabled by default, and it contains three steps scheduled at 02:00 AM:   What is this job? And what is it for? Since SQL Server 2008, a new feature called Policy Based Management has been added. When your policies are run, the results are stored in the msdb. But without a purge mechanism, msdb will keep growing. So…

 
Read More
Stéphane Haby

Journées SQL Server 2015: Retrouvez nos sessions sur SlideShare et Youtube!

By | Technology Survey | No Comments

Avant de partir pour des vacances bien méritées et une année pleine d’aventures sur SQL Server, je fais un dernier petit article pour vous informer que nos sessions des Journées SQL Server 2015 sont disponible sur SlideShare et Youtube. Un grand merci à l’équipe du GUSS pour l’organisation et leur confiance en nous. N’hésitez pas à aller également évaluer nos sessions et celle des autres ici   SlideShare: http://fr.slideshare.net/GUSS_FRANCE/jss2015-nouveauts-sql-server-2016scurittemporal-stretch-tables Youtube: https://www.youtube.com/watch?v=CP4c8dy97Yk       SlideShare:…

 
Read More
Stéphane Haby

How to be sure that tempdb size is good to run a DBCC CHECKDB?

By | Database Administration & Monitoring, Database management | No Comments

In many blogs or forums, you can read that the answer is to use the option: WITH ESTIMATEONLY. With this option, you can easily have the space estimation needed to check the database in tempdb. But be careful, only since SQL Server 2014, this estimation has been good! See the PS from Paul Randal’s blog for this information, here But between SQL server 2008, 2012 and 2014…and 2016, the result of this query changed!  

 
Read More
Stéphane Haby

Security via policies

By | Database management | No Comments

Few weeks ago, I presented the session on security via Policies for “Les journées SQL Server 2014″, organized by the French SQL Server User Group (GUSS) in Paris. I promised to post our policies script on a blog. Security Policies are split into 4 categories: Server Instance Database Data All policies follow this naming convention: dbi_”Level number”_”Level name”_”Policy name” I give you the policy name, the condition and the query or facet associated. To understand…

 
Read More
Stéphane Savorgnano

Windows Server 2012 R2: solving .NET Framework 3.5 installation problems

By | Operation systems | 12 Comments

I faced a problem at a customer site last week when I tried to install the .NET Framework 3.5 – a prerequisite for installing SQL Server 2012 on a Windows Server 2012 R2. I opened the Server Manager and then navigated to the Manage, Add Roles and Features section: I selected the .NET Framework 3.5 Features option: I specified an alternate source path: … and surprise! Even though an ISO of Windows Server 2012 R2…

 
Read More
Stéphane Haby

SQL Server tips: Executing a query with the EXECUTE command

By | Database management | No Comments

This short SQL Server blog post is meant to help people who have experienced the error messages 2812 and 203 with the EXECUTE command. The goal is to execute a simple query from a variable in a string format with the EXECUTE (exec) command. Very easy, isn’t it? Ok, let’s GO! If I execute “select * from sys.databases” in SSMS, in SQLCMD or in PowerShell – no problem, I have the list of all databases…

 
Read More
David Barbarin

Pass summit 2014: My favorite sessions of this great event

By | Technology Survey | No Comments

The Pass Summit 2014 is now over and it’s time for us to go back home. I want to share my favorite sessions with you in this post.   Pass Summit was really an amazing event regardless of the expertise area (BI or SQL Server engine). This was also a good opportunity to meet SQL Server guys in others countries as well as the French SQL Server community. We attended a lot of interesting sessions…

 
Read More