Sites anglophones


SQL Server IO Analysis Part 2

Publié le 23 décembre 2016 sur sqlmag.com
 

Never Upset a Nerd In 2010 I wrote a book on Dynamic Management Objects with fellow SQL Server MVP Louis Davidson.  Over the years I’ve grown even more passionate about what these constructs offer to the DBA and Developer alike in identifying (or …

SQL Server IO Analysis Part 1

Publié le 23 décembre 2016 sur sqlmag.com
 

The SQL Server Dynamic Management Objects provide a wealth of information about performance within the internal structures of Microsoft SQL Server. In this series Tim Ford will start with identifying the base Dynamic Management Function involved in col …

GroupBy Registration is Open for 3 More Days

Publié le 23 décembre 2016 sur brentozar.com
 

GroupBy is a new community-driven conference where your voting picks the lineup. Here’s the sessions you chose: Friday January 13th: 8AM Eastern: SQL Server 2016: It Just Runs Faster with Bob Ward 9:30: SQL Server and PowerShell: Let’s Get …

What is Memory Grants Pending in SQL Server? – Interview Question of the Week #103

Publié le 23 décembre 2016 sur journey to sqlauthority
 

Question: What is Memory Grants Pending in SQL Server? Answer: Very interesting question and this subject is so long, it will be difficult to cover in a single blog post. I will try to answer this question in just 200 words as usual in the intervi …

Level 3 – Building the Ideal VMware-based SQL Server Virtual Machine

Publié le 23 décembre 2016 sur sqlservercentral.com
 

In this level of the Stairway to SQL Server Virtualization David looks at the ideal virtual machine setup for a SQL Server instance on VMware.

Managing Packages Using Windows PowerShell

Publié le 23 décembre 2016 sur sqlservercentral.com
 

Windows hasn’t had a package manager in the style of the Advanced Packaging Tool (APT) of Linux distributions. Apt-get is a great way of installing packages and other software. We have Chocolatey, of course which has a growing library of software and e …

Quickie – SSIS Expression Function – REPLACENULL

Publié le 23 décembre 2016 sur sqlblog.com
 

When I am not designing a database, I am usually loading it with data (a good percentage of my time is spent designing data warehouse structures, along with relational ones. Using SSIS is often a challenge, for many reasons, but the most challenging fo …

SQL SERVER – SqlServerWriter Missing from an Output of VSSadmin List Writers Command

Publié le 23 décembre 2016 sur journey to sqlauthority
 

One of a DBA from my client contacted me for a quick suggestion when I was working with them on a performance tuning exercise. I always ask for some time to explain the exact problem and behavior. As per the DBA, they are using 3rd party backup solutio …

Three Free Webinars About Using the SSIS Catalog

Publié le 22 décembre 2016 sur sqlblog.com
 

Kent Bradshaw and I are delivering a series of webinars 27-29 Dec 2016 called SSIS Academy: Using the SSIS Catalog . Why? We’ve been using the SSIS Catalog in Production since 2012. We’ve learned a lot about how it works. Some parts of the …

Filtered Statistics Follow-up

Publié le 22 décembre 2016 sur brentozar.com
 

During our pre-con in Seattle A really sharp lady brought up using filtered statistics, and for a good reason. She has some big tables, and with just 200 histogram steps, you can miss out on a lot of information about data distribution when you have mi …

Using Mod to Generate Work Shifts

Publié le 22 décembre 2016 sur sqlservercentral.com
 

A short story on using the mod function to a shifting query.

Capacity Planning Using Performance Data

Publié le 22 décembre 2016 sur sqlservercentral.com
 

Erin Stellato discusses the types of performance data needed to help with capacity planning.

New course: Installing and Configuring SQL Server 2016

Publié le 22 décembre 2016 sur sqlskills.com - paul randall
 

Glenn’s latest Pluralsight course has been published – SQL Server: Installing and Configuring SQL Server 2016 – and is just over two hours long. The modules are: Introduction Pre-installation Tasks for the Ope …

SQL Server – PowerShell Script – Getting Properties and Details

Publié le 22 décembre 2016 sur journey to sqlauthority
 

I write and play around a lot with SQL Server Management Studio and I love working with them. Having said that, I also explore the ways people want to run code to achieve certain objectives. In the DBA’s world when the number of servers we are ta …

Ten Ways to Set MAXDOP

Publié le 21 décembre 2016 sur brentozar.com
 

Whenever I work with SQL Server, I’m amazed at how many ways there are to influence its behavior. For example, take the maximum degree of parallelism for a query. Just offhand, I thought of ten different ways you can tweak it: 1. At the serv …


Pages :