Sites anglophones


What Is a Staging Environment and How Do You Build One?

Publié le 20 janvier 2016 sur brentozar.com
 

If you’re a full time production database administrator, you need a staging environment. This is where you test infrastructure tasks like failing over mirroring, doing a disaster recovery role swap, cluster quorum changes, log shipping configurat …

Stairway to Columnstore Indexes Level 6: Updating and Deleting Data in a Columnstore Index

Publié le 20 janvier 2016 sur sqlservercentral.com
 

This level looks in detail at what happens when we update or delete data from a clustered columnstore index, the impact it has on concurrent data access, and how without careful maintenance the efficiency of columnstore indexes can degrade over time.

Network Load Testing Using iPerf

Publié le 20 janvier 2016 sur sqlservercentral.com
 

Tim Radney of SQLskills shows how to measure your network so you have more ammo to take to your network team when there is a performance issue.

Geek City: SQL Server 2016 CTP3 In-Memory OLTP Internals Whitepaper

Publié le 20 janvier 2016 sur sqlblog.com
 

Just a quick note that my CTP3 paper has finally been published, and now I can start working on the final version! Here’s the link: http://download.microsoft.com/download/D/5/2/D52D374F-D442-4275-B570-0EB527102F4D/SQL_Server_In_Memory_OLTP_Intern …

Is It Ever Better to Not Name Constraints?

Publié le 20 janvier 2016 sur sqlblog.com
 

This is part 1 of my Tips and Tricks blogs for my upcoming book project . For all of my professional writing career, I have been forced to be on the top of my formatting game when writing code. Uppercasing this, spacing this, aligning that, formatting …

Hyper V: Error and Fix – Fix – Boot failure. Reboot and Select proper Boot device

Publié le 20 janvier 2016 sur journey to sqlauthority
 

While trying to deploy new machines on my Hyper-V, I faced an error. Boot failure. Reboot and Select proper Boot device or Insert Boot Media in selected Boot device It was a VHD file which I downloaded from Microsoft site. I searched for the solution o …

SQL Server Diagnostic Information Queries Detailed, Day 19

Publié le 20 janvier 2016 sur sqlskills.com - glen berry
 

After eighteen days of queries, we have made it through all of the instance-level queries in this set. Now, we move on to the database-specific queries in the set. For these queries, you need to be connected to a particular database that you are concer …

More Training from Andy Leonard!

Publié le 19 janvier 2016 sur sqlblog.com
 

First, thanks to everyone who has attended one of my free webinars! I enjoy delivering training and hope that it shows. Where can you learn about upcoming training from me? At the Enterprise Data & Analytics   Training page , of course. Upcomi …

CPU-Z Benchmark Survey

Publié le 19 janvier 2016 sur sqlskills.com - glen berry
 

The latest version of the free CPU-Z utility has a quick CPU benchmark test that just takes a couple of minutes to run. As part of a personal project that I am working on (which I think will be very interesting and beneficial to the community), I am tr …

How to Get Your Very First Full Time DBA Job

Publié le 19 janvier 2016 sur brentozar.com
 

It’s about time. Step 1: get a job as a developer or a sysadmin. Step 2: stand near the database. Step 3: wait. Almost every DBA I know got their start this way. Sooner or later, something went wrong with the database, and management grabbed the …

Power Pivot Utils: a nice collection of VBA macros #powerpivot #dax

Publié le 19 janvier 2016 sur sqlblog.com
 

When you use Power Pivot, there are a number of operations requiring more than one click (or much more than just Excel): Creating a pivot table based on the current data model (at least 2 or 3 clicks) Create a table of existing measures (including its …

Time and Space: How to Monitor Drive Space in SQL Server

Publié le 19 janvier 2016 sur sqlservercentral.com
 

How to monitor drive space in T-SQL and calculate when your drives will run out of space.

Getting Started with Stretch Database Functionality in SQL Server 2016 – Part 2

Publié le 19 janvier 2016 sur sqlservercentral.com
 

Arshad Ali explains and demonstrates the impact of enabling the Stretch database feature on backup and restore operations. He also discusses ways to pause, resume, and disable this feature altogether when not needed.

SQL SERVER 2016 – InMemory OLTP support for Foreign Key

Publié le 19 janvier 2016 sur journey to sqlauthority
 

When InMemory OLTP was introduced in SQL Server 2014, there were a number of limitations that restricted customers to effectively use the capability. One of the most commonly asked capability was around the ability to create Foreign Keys. On first look …

What you should have read 🙂 during the weekend – weekly SQL Server blogs review part 12

Publié le 18 janvier 2016 sur sqlblog.com
 

Hello! Happy New Year to you all! I was really busy at the end of the last year because I was trying to close all opened projects. Which was not possible and now I know this! I am coming back to you with a list of posts that are a must to read !!! Hope …


Pages :