Technology Survey SQL Server 2016: the Time Travel with temporal table – Part I 28.08.2015 by Stéphane Haby Principle & Creation Microsoft create in SQL server 2016 a new feature temporal table, based on the latest edition of the SQL standard: SQL:2011. If you want read more about this standard, click here. I(…)
Database Administration & Monitoring SQL Server, Integration Services and Package Versions 27.08.2015 by Stéphane Haby A lot of people ask me about the different versions of SQL Server Integration Services and packages. I create rapidly this little table to summarize it: With SQL Server 2008 and 2008 R2, the SSIS version(…)
Database Administration & Monitoring SQL Server Tips: Logical names don’t match with physical files names 25.08.2015 by Stéphane Haby During a copy of a database from an environment to another (from Production to pre-production for instance), people usually don’t changed the logical name of the data or log files when they rename the database and the physical file names.
Technology Survey SQL Server 2016: native support for JSON 12.06.2015 by Stéphane Haby A lot of discussions and most important, a feature requests in the Microsoft connect site here with more than 1000 votes is the origin of this new feature in SQL Server 2016. A lot of NoSQL have already this function(…)
Database management SQL Server Tips: How to know if In-Memory Feature is supported by your server? 18.05.2015 by Stéphane Haby A customer asks me, how to know if In-Memory Feature is supported by my SQL Server server? An easy way is to check the edition, version etc. but now, you have directly a property for that. On msdn(…)
Technology Survey Azure DocumentD8: Microsoft goes to NoSQL 18.05.2015 by Stéphane Haby Azure DocumentDB is a documentary database service and as like its name suggests, it is aMicrosoft Azure Cloud service. Since the last summer, developers have access to this new service, and now it is available(…)
Database management SQL Server – Change Management: list all updates 18.05.2015 by Stéphane Haby I am looking to have all SQL Server updates on a server including Service Packs, Cumulative Updates and other fixes like we can see in the uninstall panel from Windows. I take the opportunity of this(…)
Database management Security via policies 10.02.2015 by Stéphane Haby 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(…)
Database management SQL Server tips: how to list orphaned logins 05.12.2014 by Stéphane Haby I read a lot of about orphaned database users in SQL Server, but I have almost never read about orphaned logins. Many of my customers migrate or remove databases in SQL Server. They forget – not every time but(…)
Database management SQL Server tips: Executing a query with the EXECUTE command 25.11.2014 by Stéphane Haby 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(…)