Sites anglophones

SAN and NAS protocols and how they impact SQL Server

Publié le 24 juillet 2015 sur

Discusses the various SAN and NAS protocols (FC, iSCSI, NFS) and how choosing one over the other can impact your SQL Server Performance.

SQL Style Habits: Attack of the Skeuomorphs

Publié le 24 juillet 2015 sur

Although we like to think that our programming techniques are progressive and in tune with the bleeding edge of software development practices, too often they are directly influenced by restrictions faced when computers first became mainstream in the p …

SQL Explained

Publié le 24 juillet 2015 sur

A short explanation and infographic of what SQL is. For the non-SQL people in your life.

SQL SERVER – FIX – Property IsLocked is Not Available for Login

Publié le 24 juillet 2015 sur journey to sqlauthority

I play and experiment with SQL Server to the max. Sometimes I am not sure what I did and I land into something undesired. Then the reason to troubleshoot starts and I get to learn something new. Sometimes these learnings are based on error messages tha …

Microsoft and Database Lifecycle Management (DLM): The DacPac

Publié le 24 juillet 2015 sur

The Data-Tier Application Package (DacPac), together with the Data-Tier Application Framework (DacFx), provides an alternative way to automate the process of scripting out, or deploying a SQL Server database, reporting on changes, or checking version-d …

Scaling SQL Server With No Hardware

Publié le 23 juillet 2015 sur

Core database performance factors Learn about SQL Server’s core database performance factors read more

What’s New in Master Data Services – SQL2016 CTP2.2(July) Release

Publié le 23 juillet 2015 sur

SQL Server 2016 Community Technology Preview 2.2 is publicly released and the latest bits can be found at In CTP2.2 MDS introduced following changes: 1. Custom Indexes You can create a …

SQL Server Cumulative Update Highlights

Publié le 23 juillet 2015 sur - glen berry

I have a series of blog posts (that I try to keep updated over time) that list I what I consider to be the more important hotfixes in each cumulative update for the respective branch of code for that version of SQL Server. In order to make it easier fo …

Performance and Stability Related Fixes in Post-SQL Server 2014 SP1 Builds

Publié le 23 juillet 2015 sur - glen berry

As of June 19, 2015, there has been one Cumulative Update (CU) for the Service Pack 1 branch of SQL Server 2014. There were a large number of hotfixes in this Cumulative Update, in order to get this branch caught up with the RTM branch of SQL Server 20 …

Out of Office: Time For the Brent Ozar Unlimited Retreat

Publié le 23 juillet 2015 sur

Thank you for your web visit. We’re out of the office and will be back on Monday, August 3. During this period we will have limited access to our email. We’ll still have full access to Twitter, Facebook, and Instagram. We apologize in advan …

Professional Development – Set the Bar High

Publié le 23 juillet 2015 sur

Originally appearing at . Henry Ford is reported to have once said, “Whether you think you can or think you can’t – you’re right.” That’s great insight. Too often people place self-imposed and artificial limi …

Large SQL Server Database Backup on an Azure VM and Archiving

Publié le 23 juillet 2015 sur

For a large SQL Server database on an Azure VM, backing up the data can have some challenges. In this article, Murshed Zaman focuses on the two most common challenges: size and speed.

Free webinar: Embracing DLM – The Definitive Guide

Publié le 23 juillet 2015 sur

Database Lifecycle Management (DLM) is about enabling rapid, risk-free database development and deployments. However, the most effective DLM processes actually reach beyond the database. Embracing the full scope of it can be daunting, so Grant Fritchey …

Is It Worth Writing Unit Tests?

Publié le 23 juillet 2015 sur

What’s the overhead for writing unit tests? Ed Elliot breaks it down, looking at the ways in which unit tests both take more time and save time.

SQL SERVER – What are T-SQL Median? – Notes from the Field #090

Publié le 23 juillet 2015 sur journey to sqlauthority

[Note from Pinal]: In this episode of the Notes from the Field series database expert Kathi Kellenberger explains about T-SQL Median. Kathi is an amazing instructor, she was the SQL author I have read in my early career. The reason, I lo …

Pages :