Sites anglophones

Calling all user group leaders! We want to present for you in 2016!

Publié le 18 novembre 2015 sur - paul randall

By the end of December, we at SQLskills will have remotely presented to 87 user groups and PASS virtual chapters around the world in 2015! We’d love to present remotely for your user group in 2016, anywhere in the world. It’s not …

Managing SSIS Catalog Project Parameter Values

Publié le 18 novembre 2015 sur

One of the coolest features of the SSIS Catalog is Catalog Environments. Catalog Environments offer a compelling and rich solution for Catalog Project Parameter value externalization and configuration management, whether the parameters are connections …

Is SQL Server killing your application’s performance?

Publié le 18 novembre 2015 sur

When an application suffers from performance problems, it’s common to assume the database is at fault. Ben Emmett examines why this often isn’t the case, and shows how you can dig into a .NET application’s use of SQL Server.

SQL Prompt Tips #6 – Insert Semicolons

Publié le 18 novembre 2015 sur

A quick SQL Prompt tip to automatically add semicolons to your code.

A Single-Parameter Date Range in SQL Server Reporting Services

Publié le 18 novembre 2015 sur

Many reports you will generate in SSRS will need to report within date ranges, and most of those will need a date range parameter. Here’s an way to make an easy-to-use date range parameter. « A real time saver » Andy Doyle, Head of IT ServicesAndy and hi …

SQL SERVER – Puzzle with Miliseconds – Win USD 50 Amazon Gift Card

Publié le 18 novembre 2015 sur journey to sqlauthority

Last contest, which we had ran was in May and it had received amazing responses. I once again reached out to kind team of Embarcadero and they agreed to support the next contest. The contest has two steps and they are very simple. It took me a while to …

Why is SQL Server Slow Sometimes – But Only Sometimes?

Publié le 17 novembre 2015 sur

Brace yourselves. Our Black Friday sale is coming. Have you got a SQL Server that usually performs just fine, but every now and then, everything falls to pieces? Users complain about performance, and then minutes – or hours – later, the pro …

Apply AND instead of OR logic to multiple selection in a slicer #dax #powerpivot #powerbi

Publié le 17 novembre 2015 sur

I recently write a small article on SQLBI to describe how to create a DAX measure that search for items that have all the items selected in a slicer, instead of any of them. For example, you might want to create a measure that display how many customer …

Making Deployments Simpler with Re-runnable Scripts

Publié le 17 novembre 2015 sur

Make sure your SQL Server database release scripts to make life easier.

SQL SERVER – Looking Inside SQL Complete – Advantages of Intellisense Features

Publié le 17 novembre 2015 sur journey to sqlauthority

Recently SQL Complete add-in was updated, which I use when writing SQL queries in SSMS. In the product history I saw that a several features were added, such as code refactoring or automatic semicolon insertion. However, in this post I do not want to t …

Jodie Beay and the Production Database Drift

Publié le 17 novembre 2015 sur

You make an example database, like NorthWind or WidgetDev in order to test out your deployment system and the next thing you know you’re worrying about constraints, backup and security. Then you add an index to the production system and feel a pang of …

The free #eBooks series #SQLServer and .NET Blog

Publié le 16 novembre 2015 sur

The series of free eBooks « The SQL Server and .NET Blog eBook Series » by Artemakis Artemiou (@artemakis) collects dozens of articles explaining how to solve practical problems in these areas: Database DevelopmentDatabase Administrat …

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

Publié le 16 novembre 2015 sur

Hello! It is Monday so I am delivering you the new articles to read! Hope you will have a lot of fun reading all of them!     Author Title Link CSS SQL Server Engineers Are my statistics correct? Chris Webb Power BI …

November 2015–Learn SQL Server and Visual Studio

Publié le 16 novembre 2015 sur

A reader emailed to ask what I recommend for learning current software and database development. I responded with these links: VirtualBox Windows 2016 Server TP3 SQL Server 2016 CTP 3 Visual Studio 2015 I believe the software is all free, though it is …

Hash Joins on Nullable Columns

Publié le 16 novembre 2015 sur

Paul White explores some less well-known query optimizer features and limitations, and explains the reasons for extremely poor hash join performance in a specific case.

Pages :