Sites anglophones


Tinkering with SSIS 2016 RC2

Publié le 11 avril 2016 sur sqlblog.com
 

I’ve been testing SSIS 2016 as the CTPs (Community Technology Previews) and RCs (Release Candidates) have been made available. I’ve been most interested in changes to the SSIS Catalog. Getting RC2 running posed a couple challenges for me so …

[Video] Free Training of the Week: Dynamic Quorum and Dynamic Witness

Publié le 11 avril 2016 sur brentozar.com
 

In this week’s free video training sample, dig into the details of dynamic quorum and dynamic witness: what do they do? What’s strange about them at small node counts in a cluster? You’ll also learn how to configure quorum in three co …

NonClustered Index Structure

Publié le 11 avril 2016 sur sqlservercentral.com
 

Learn how the clustered index keys affect the non clustered index structure.

Getting Started with Temporal Table in SQL Server 2016 – Part 1

Publié le 11 avril 2016 sur sqlservercentral.com
 

With the new temporal table feature, SQL Server 2016 internally manages two tables: a base table, which contains the latest data all the time, and a history table, which contains a history of all of the changes. Arshad Ali looks at the new feature, how …

Podcast – Conversation With Author – Serving a Benevolent Master

Publié le 11 avril 2016 sur journey to sqlauthority
 

I had amazing fun time earlier last week when I was interviewed by prominent podcaster Dave Rael. He is amazing interviewer and knows how to get secret information from the people. He had asked me indeed very, very difficult question in the podcast. I …

Implementing SQL Server In-Memory OLTP

Publié le 11 avril 2016 sur simple-talk.com
 

How do you go about transferring a disk-based workload to the respective memory-optimized design? How do you process memory-optimized tables? How important for performance are natively-compiled Stored Procedures? Artemakis Artemiou comes up with a step …

What is ACID Property in Database? – Interview Question of the Week #066

Publié le 10 avril 2016 sur journey to sqlauthority
 

Today I want to take you all back to the one of the very original database interview questions and answer which I see often discussed in the interview. I have previously written about this ACID properties as well. In my career, I have seen 1000s of the …

SQL Saturday Silicon Valley

Publié le 9 avril 2016 sur sqlmag.com
 

Network and learn the latest SQL tips and tricks Join other SQL Server and business intelligence professionals in Silicon Valley on April 9 for a free training and networking event on the Microsoft campus.  read more

SQL SERVER – InMemory OLTP Migration Assistant Powershell Script

Publié le 9 avril 2016 sur journey to sqlauthority
 

In one of my recent interaction with my client, they were so much impressed with the fact that SQL Server has now introduced the ability to use In Memory OLTP. They said they were interested in implementing the same in their environment for a number of …

SQL Down Under podcast Show 67–Kasper DeJonge and SQL Server 2016 Analysis Services

Publié le 9 avril 2016 sur sqlblog.com
 

Last week I had an opportunity to record a new podcast with Kasper DeJonge from the SQL Server Analysis Services team. Kasper has also been working on Power Pivot and many other areas. SQL Server 2016 is lining up to be a great release for Analysis Ser …

Maximizing Availability for Mission Critical Applications

Publié le 8 avril 2016 sur sqlmag.com
 

Michael Otey The availability of your mission critical applications is without a doubt the DBA and database professional’s most important priority. Although performance is always critical, it takes a back seat if the applications and the database …

Maximizing your Application Performance with SQL Server 2016 In-Memory Technologies and HPE Superdome X

Publié le 8 avril 2016 sur sqlmag.com
 

Michael Otey Mission critical application performance is always one of the DBA and database professional’s top concerns. Meeting demanding SLAs is consistently growing more difficult because virtualization hosts and cloud platforms typically shar …

New course: Scaling SQL Server 2012 and 2014: Part 2

Publié le 8 avril 2016 sur sqlskills.com - paul randall
 

Glenn’s new course is called SQL Server: Scaling SQL Server 2012 and 2014: Part 2 and is just under 3 hours long. It covers a plethora of configuration and hardware issues that can prevent a workload from scaling, plus methods …

Breaking News, Literally: SQL CLR Support Removed from Azure SQL DB

Publié le 8 avril 2016 sur brentozar.com
 

In the on-premises, boxed-product version of SQL Server, you can build your own CLR assemblies and call them from your T-SQL code. For years, this feature was missing from Azure SQL DB – Microsoft’s platform-as-a-service database offering …

[Video] Office Hours 2016/04/06

Publié le 8 avril 2016 sur brentozar.com
 

This week, Brent, Erik, Jessica, and Richie discuss the sudden increase in AWS cloud clients, whether you should use cardinality estimator hints, how to do indexing on a former SQL Server 2000 database, and Brent’s hilarious Jerusalem t …


Pages :