SQL Server

SQL Server 2016: the Time Travel with temporal table – Part IV

Maintenance & Metadata My last chapter is about the maintenance backup/restore, index rebuild/reorg., etc. and the Metadata. I divide my article into 4 parts to be clearer and easier to read:(…)

SQL Server 2016: the Time Travel with temporal table – Part III

SELECT command In this article, I present the last command SELECT. I divide my article into 4 parts to be clearer and easier to read: Part I – Principle &(…)

SQL Server 2016: the Time Travel with temporal table – Part II

INSERT, UPDATE & DELETE commands After the introduction and the table creation, in this second part, I present the 3 important commands INSERT, UPDATE & DELETE. I divide my article into 4 parts to be clearer and easier to(…)

SQL Server 2016: the Time Travel with temporal table – Part I

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(…)

SQL Server, Integration Services and Package Versions

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(…)

SQL Server Tips: Logical names don’t match with physical files names

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.

How to solve accent sensitive problems?

Some days ago, one of my customer claimed that searching for “Muller” doesn’t return “Mueller” and “Müller” as well! This is typically an issue due to the collation of the SQL Server database, but how to resolve this problem?(…)

Don’t use the default database file autogrow settings !

I often noticed default values for database file autogrow settings during my audits. You don’t trust me? Let me talk about a funny story about an incredible (and extreme) situation that concerns a transaction log file and its default settings.

Clustered columnstore index and memory management

Few weeks ago, I had the opportunity to give a session about the clustered columnstore index feature (CCI) at our In-Memory event dedicated to In-Memory technologies for Microsoft SQL Server, Oracle and SAP HANA. During our session, I explained(…)

SQL Server 2016 : availability groups and the new SSISDB support

This blog post is focused on the new supportability of SSIDB catalog on AlwaysOn architecture. Others studies are available here: New database issue level detection for automatic failover Potential features in standard(…)