Sites anglophones

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

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

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

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

Capacity Planning Using Performance Data

Publié le 22 décembre 2016 sur

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 - 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

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 …

Santa Claus brings presents to #dax, #powerbi, and #ssas #tabular users

Publié le 21 décembre 2016 sur

If you think that the end of the year would have been a quiet time because the Power BI team will skip their monthly release (but are we sure?), you might be reassured (or disappointed depending on your perspective) looking at the news I have in this b …

Disconnecting SQL Server connections after query execution

Publié le 21 décembre 2016 sur

One way to improve SQL Server performance is to use as few resources as possible. In this post Rahul Mehta demonstrates how you can do this by disconnecting queries post-execution with a simple change in SSMS.

Stairway to Exploring Database Metadata Level 6: Idempotent DDL scripts that always achieve the same result: Making changes only once

Publié le 21 décembre 2016 sur

Idempotence is the property of certain operations in mathematics and computer science, that can be applied multiple times without changing the result beyond the first time they are run. When you are making changes to a database to deploy a new version, …

What is Azure SQL Data Warehouse?

Publié le 21 décembre 2016 sur

Azure SQL Data Warehouse is a cloud-based, scale-out database capable of processing massive volumes of data, both relational and non-relational. Built on our massively parallel processing (MPP) architecture, SQL Data Warehouse can handle your enterpris …

SQL SERVER – Testing Database Performance with tSQLt and SQLQueryStress

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

I guess, it is no secret that testing plays a critical part in development of any software product. The more rigorous testing is, the better the final product will be. In this blog post we will be Testing Database Performance with tSQLt and SQLQueryStr …

Is NOLOCK Ever The Right Choice?

Publié le 20 décembre 2016 sur

I’ve poked a lot of fun at NOLOCK I mean, it sucks. You can get incorrect data, and it can throw errors if your data is particularly volatile. Generally, outside of testing a query or grabbing some sample data, I’m going to avoid it. Crappy …

Adjust autogrow setting for your database files

Publié le 20 décembre 2016 sur

I very frequently see too small autogrow value for database files. Even the default in many cases. The defaults prior to SQL Server 2016 are 1 MB for data files and 10% for log files, adjusted to a little bit better values in 2016. One of the tings I o …

Pages :