Infrastructure at your Service

Tag

SQL Server 2014 Archives - Page 4 of 7 - Blog dbi services

Stéphane Haby

SQL Server 2014 Tips: Create indexes directly via CREATE TABLE

By | Application integration & Middleware | 2 Comments

This week, I discovered a new enhancement which is not hidden but not really visible in SQL Server 2014. Among Hekaton and other new features in SQL Server 2014, a little option appears in table creation.8-O On the msdn website, we can see a new section in the “CREATE TABLE” code:   We can directly create an index in the “CREATE TABLE” query. Ok, then let’s go! In my example, I create a diver table with…

Read More
Microsoft Team

SQL Server 2014: classic commit vs commit with delayed durability & I/Os

By | Application integration & Middleware | 4 Comments

When you learn about SQL Server, you will often hear that a commit transaction is a synchronous operation and that you can trust it. In this blog post, I will provide some details about what we mean by synchronous behavior. The reason is that sometimes, when I talk about the new delayed durability feature provided by SQL Server 2014, there are some confusions. If you want more details on this new feature, please read the…

Read More
Nathan Courtine

Improving your SharePoint performance using SQL Server settings (part 2)

By | Technology Survey | No Comments

Last week, I attended the SQLSaturday 2014 in Paris and participated in a session on SQL Server optimization for Sharepoint by Serge Luca. This session tried to list the best pratices and recommendations for Database Administrators in order to increase the SharePoint performance. This blog post is based on this session and is meant as a sequel to my previous post on Improving your SharePoint performance using SQL Server settings (part 1). SQL Server instance…

Read More
Microsoft Team

SQL Saturday 323: SQL Server AlwaysOn and availability groups session slides

By | Hardware & Storage | 4 Comments

This SQL Saturday’s edition in Paris is now over. It was a great event with a lot of French and international speakers. There were also many attendees indicating that this event is a great place to share about SQL Server technologies. Maybe the Montparnasse tower in Paris played a role here with its panoramic view over Paris from the 40th floor! 🙂 For those who didn’t attend on Saturday, you will find our SQL Server…

Read More
Nathan Courtine

Deploying a SQL Server database to Azure

By | Database management | One Comment

Deploying an SQL Server database to a Windows Azure virtual machine is a feature introduced with SQL Server 2014. It can be useful for an organization  that wants to reduce its infrastucture management, simplify the deployment, or have a fast virtual machine generation. Concept This new feature is a wizard which allows either to copy or migrate an On-Premise SQL Server database to a Windows Azure virtual machine. The following schema explains the main process…

Read More
Microsoft Team

SQL Server 2014: DBCC CHECKDB and ReFS support

By | Database management | One Comment

Have you noticed an interesting behavior with SQL Server 2014 when you are running a dbcc checkdb command? If not, you should have a look at this blog post. I discovered it completely by accident during some tests. If you watch carefully, you will see “weird” files appear while the dbcc checkdb command is running. Below is a sample of the file you will find near the corresponded database file: The file immediately disappears after…

Read More
Microsoft Team

SQL Server: DBCC CHECKDB does not detect corruption

By | Database management | 3 Comments

During my audits at customer places, it still happens very often to find SQL Server databases with page verification option configured to “none”. I always alert my customers on this configuration point because it can have an impact on the overall integrity of their databases. One of my customer told me that the integrity task of its maintenance will detect the corruption anyway and alert him by email – but is it really the case?…

Read More
Microsoft Team

SQL Saturday in Paris on 12 -13 September

By | Database management | No Comments

As you certainly know SQL Saturday events are very popular in SQL Server world community. This is the second time the event takes place in Paris (France), but this time, we have a new format with pre-conferences on Wednesday and classic sessions on Saturday. During pre-conferences, we will talk about a particular subject for a whole day. This time, I have the opportunity to participate twice by giving two sessions (in French) with the following program:…

Read More
Nathan Courtine

Backup a SQL Server database from On-Premise to Azure

By | Hardware & Storage | No Comments

SQL Server database backup & restore from On-Premise to Azure is a feature introduced with SQL Server 2012 SP1 CU2. In the past, it could be used with these three tools: Transact-SQL (T-SQL) PowerShell SQL Server Management Objects (SMO) With SQL Server 2014, backup & restore can also be enabled via SQL Server Management Studio (SSMS). Concept This feature is quite similar to a “classic” backup & restore tool. Indeed, the main different lies in…

Read More
Stéphane Haby

SQL Server 2014: Are DENY ‘SELECT ALL USERS SECURABLES’ permissions sufficient for DBAs?

By | Database management | No Comments

SQL Server 2014 improves the segregation of duties by implementing new server permissions. The most important is the SELECT ALL USERS SECURABLES permission that will help to restrict database administrators from viewing data in all databases. My article is a complement to David Barbarin’s article ‘SQL Server 2014: SELECT ALL USERS SECURABLES & DB admins’. I have tested some cases to be sure that I can do my DBA’s job as well. As a reminder,…

Read More