Sites anglophones


Public Data Sets

Publié le 26 février 2016 sur sqlservercentral.com
 

A list of data sets you can download and play with for practice, demos, or your own analysis.

Database Design Follies: NULL vs. NOT NULL

Publié le 26 février 2016 sur sqlservercentral.com
 

It sounds simple enough. Either your column will always have a value or it may not. Yet somehow such a seemingly simple decision can become a never-ending debate where database schema begins to resemble superstition and designing effective tables seems …

SQL SERVER – 2016 – Check Value as JSON With ISJSON()

Publié le 26 février 2016 sur journey to sqlauthority
 

I have been wanting to write about the various operators that govern using JSON and my first shot has been with: SQL SERVER – Getting started and creating JSON using SQL Server 2016. That was like a primer and as I see the subsequent releases of …

How often should I run DBCC CHECKDB?

Publié le 25 février 2016 sur brentozar.com
 

There’s an old DBA saying… May you already have a backup restored A half hour before your boss knows there’s corruption What? There’s no such thing as old DBA sayings? Well, maybe if you all said something other than …

Beta for new Redgate tool

Publié le 25 février 2016 sur sqlservercentral.com
 

Redgate is looking for beta participants to give feedback on a new tool: SQL Instant Clone. With Instant Clone, you can take a ‘data image’ of a database, then rapidly create an unlimited number of clone databases. These clone databases tak …

Auto Generate Your Database Documentation

Publié le 25 février 2016 sur sqlservercentral.com
 

Script provided to create missing extended properties allowing you to auto generate your database documentation.

SQL SERVER – Boosting User Experience with Perspectives in Analysis Services – Notes from the Field #116

Publié le 25 février 2016 sur journey to sqlauthority
 

[Note from Pinal]: This is a new episode of Notes from the Field series. When I was new to SSAS it took me quite a while to understand the various terminology of SSAS. The reason for the same was, I was from networking background and not familiar …

Issue Tracking for Databases

Publié le 25 février 2016 sur simple-talk.com
 

Any database development project will be hard to manage without a system for reporting bugs in the code, anomalies and incidents from live environments, and for keeping track of new features. Matthew Skelton discusses the critical role of an integrated …

Announcing SQLSaturday Houston Pre-Con: Performance Tuning When You Can’t Fix the Queries

Publié le 24 février 2016 sur brentozar.com
 

Your users are frustrated because the app is too slow, but you can’t change the queries. Maybe it’s a third party app, or maybe you’re using generated code, or maybe you’re just not allowed to change it. Take heart – there …

SQL Server 2016 R Services: Display R plots in Reporting Services

Publié le 24 février 2016 sur sqlservercentral.com
 

Koen Verbeeck looks at how to embed data visualizations created with R into Reporting Services (SSRS) reports.

Stairway to AlwaysOn Level 1: What is « SQL Server AlwaysOn »?

Publié le 24 février 2016 sur sqlservercentral.com
 

Level 1 of the stairway looks at exactly what the technologies « AlwaysOn », « Failover Cluster Instance » (FCI) and « Windows Server Failover Cluster » are. We’ll look at each in detail and summarize where in the High Availability stack they sit.

Free eBook: SQL Server Execution Plans, Second Edition

Publié le 24 février 2016 sur sqlservercentral.com
 

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slow …

SQL SERVER – Free SQL Server Formatting Add-in

Publié le 24 février 2016 sur journey to sqlauthority
 

This article describes the ways in which you can format SQL code using ApexSQL Refactor features and options. ApexSQL Refactor is a free add-in with over 200 formatting options and nearly 15 code refactors. You can qualify object names, expends wildcar …

Creating a Date Dimension in an Analysis Services (SSAS) Cube

Publié le 24 février 2016 sur simple-talk.com
 

A walk-through can be a great help to understanding SQL Server Analysis Services, especially when it solves the problem of providing an effective date dimension to a cube. Dennes takes Adventureworks, and demonstrates all the twists and turns of creati …

Creating a Date Dimension in an Analysis Server (SSAS) Cube

Publié le 24 février 2016 sur simple-talk.com
 

A walk-through can be a great help to understanding SQL Server Analysis Server, especially when it solves the problem of providing an effective date dimension to a cube. Dennes takes Adventureworks, and demonstrates all the twists and turns of creating …


Pages :