Sites anglophones


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 …

SQL Server Diagnostic Information Queries Detailed, Day 18

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

For Day 18 of this series, we start out with Query #41, which is Memory Clerk Usage. This query retrieves information from the sys.dm_os_memory_clerks dynamic management view about total memory usage by your active memory clerks. Query #41 is shown in …

[Video] Free Training of the Week: Storage Tiering

Publié le 18 janvier 2016 sur brentozar.com
 

This year, we’re trying something new: every Monday, we’re going to show you one module out of our online training classes. It’s the whole module, not a sneak peek, and it’s available the whole week. But you’d better not p …

The Real World: Implementing Data Compression in SQL Server 2008 R2

Publié le 18 janvier 2016 sur sqlservercentral.com
 

Sharing our experience using Data Compression as a space savings option in MS SQL Server 2008

Documenting Your PowerShell Binary Cmdlets

Publié le 18 janvier 2016 sur sqlservercentral.com
 

Whereas it is easy to provide inline documentation for a normal scripted PowerShell cmdlet or function so as to provide comprehensive help at the command-line or IDE, the same isn’t true of binary cmdlets written in C#. At last, there is an open-source …

SQL SERVER – Dedicated Database Development with SQL Source Control

Publié le 18 janvier 2016 sur journey to sqlauthority
 

We all make mistake and we all wish that we have not made those mistakes. In the field of the development, there are proper solutions, but in the world of SQL, there are not many solutions. I recently asked the same question to my friend Andrey from De …

SQL Server Diagnostic Information Queries Detailed, Day 17

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

For Day 17 of this series, we start out with Query #39, which is PLE by NUMA Node. This query retrieves information from the sys.dm_os_performance_counters dynamic management view about your page life expectancy (PLE) by NUMA node. Query #39 is shown i …

New-Object : Constructor not found. Cannot find an appropriate constructor for type

Publié le 17 janvier 2016 sur sqlblog.com
 

This one is here so that I don’t forget it in future. I’ve been writing Powershell again all day today and I spent ages trying to find this error when instantiating a particular object. Bottom line is that there was a valid constructor that …


Pages :