Sites anglophones


Holidays and Calendar Generation

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

Create the definition of your holidays and have them available for any year. Create a Calendar including holidays and business/work dates.

Introduction to Azure SQL Database Elastic Database Pools

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

Traditional deployments of Azure SQL Database involve identifying projected resource requirements and selecting individual Azure SQL Database instances. For fluctuating workloads, this frequently results in over- or under-provisioning. To address this …

Row Level Security – Part 1–Simple Read operations

Publié le 16 février 2016 sur sqlblog.com
 

This is part 1 of my Row Level Security blogs for my upcoming book project . Row Level Security is a very interesting feature. Unlike Dynamic Data Masking (link), which looks interesting on it’s face, once you dig in the utilization of the feature look …

SQL SERVER – View Dependencies on SQL Server: Hard & Soft Way

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

As an independent database consultant, I often face a challenge when analyzing the performance of SQL Server instances, which I see for the first time in my life. In many cases, this may seem a difficult task, because in order to fix something you must …

A Fitbit report in Power BI for T-SQL Tuesday

Publié le 16 février 2016 sur sqlblog.com
 

Finding things to publish online for public consumption is something I’m often a bit reluctant to do. Most of my work is for customers, and there’s no way I’m going to share some of their data unless they’ve explicitly allowed i …

Easy SSIS Migration with SSIS Catalog Compare Recording is Available!

Publié le 15 février 2016 sur sqlblog.com
 

The recording for the webinar titled Easy SSIS Migration with SSIS Catalog Compare is now available! Enjoy! :{>…(read more)

Getting Started With Oracle: Working With Dates

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

Contrary to popular belief You will not burst into eternal flames if you’re a SQL Server guy or gal, and you happen to be within 100 feet of an Oracle database. You might feel lost and confused for a while, but you probably felt the same way when …

The DBA’s Essential Index Monitoring and Maintenance Tasks

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

Indexes can be the most critical part of any database. they can drastically improve performance or they can ruin it. Wise management is the key to success.

GROUPBY vs SUMMARIZE in #dax #powerbi #powerpivot

Publié le 15 février 2016 sur sqlblog.com
 

If you are using Power BI Desktop or Power Pivot in Excel 2016, you should learn when and how you can use GROUPBY instead of SUMMARIZE. The SUMMARIZE function is very powerful and internally very complex, so it’s easy to find scenarios where you …

SQL SERVER – Showplan Additions for ColumnStore Indexes

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

The last time when I wrote about ColumnsStore FAQ, one of the readers had an interesting question. The question was around how to identify the traits of using a column store inside an execution plan. The very thought got me thinking. I was thinking whe …

Using Apache Zeppelin on SQL Server

Publié le 14 février 2016 sur sqlblog.com
 

At the beginning of February I started an exploratory project to check if Apache Zeppelin could be easily extended in order to interact with SQL Server and SQL Azure. In the last week I’ve been able to have everything up an running. Given that I …

Interview Question of the Week #058 – What is the Difference Among DECIMAL, FLOAT and NUMERIC?

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

Question: What is the Difference Among DECIMAL, FLOAT and NUMERIC? Answer:  The basic difference between Decimal and Numeric : They are the exact same. Same thing, different name. The basic difference between Decimal/Numeric and Float : Float …

SQL SERVER – FIX: Error: 18456, Severity: 14, State: 58. Login failed for user

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

One of the most common and searched SQL Server failure is around “Logins”. Login failed for user has always been tricky and interesting to troubleshoot. I don’t think there is a silver bullet to easily troubleshoot the same. With ever …

Your Data’s Rate of Decay

Publié le 12 février 2016 sur sqlmag.com
 

Did you know that data has a half-life? That is the amount of time it takes for the information in your database to go bad. How? Because contact data is always changing. SQL Server Pro Guest Blogs read more

[Video] Office Hours 2016/02/10

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

In this week’s Office Hours Q&A, the whole team shows up – but Doug is the invisible man. We answer questions about hot-add CPU and memory, whether to sync jobs across Availability Group replicas, and how you get a single query to …


Pages :