Sites anglophones


Packaged-Application Database Nightmares – A Horror Story.

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

The business decides on a packaged application and buys it. After installation, you look at the schema and realize that is is a nightmare. How do you manage this nightmare?

SQL SERVER – Error and Fix for Msg 1907 Cannot recreate index The new index definition does not match the constraint being enforced by the existing index

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

This particular blog post is around usage of Clustered ColumnStore Indexes and how one of my customer in a recent conversation brought this up to my notice. They were on SQL Server 2012 and were upgrading to SQL Server 2014 and were very much intereste …

SSIS Design Patterns and BIML: A Day of Intelligent Data Integration

Publié le 21 décembre 2015 sur sqlblog.com
 

I’m honored to deliver a brand new precon (the PowerPoint slides still have that new slide smell) at SQL Saturday #477 – Atlanta – BI Edition ! The precon is titled SSIS Design Patterns and Biml: A Day of Intelligent Data Integration …

Microsoft acquires Metanautix to pierce through database silos

Publié le 21 décembre 2015 sur sqlmag.com
 

After a year of big updates, expect more on the way Most companies viewed endless data silos as a nightmare; Metanautix saw it as an opportunity, and is now joining Microsoft’s data group to help business every tackle the challenge. read more

Presenting “Use Biml to Automate SSIS Design Patterns” at SQL Saturday-Nashville!

Publié le 21 décembre 2015 sur sqlblog.com
 

I’m honored to present “ Use Biml to Automate SSIS Design Patterns ” at SQL Saturday – Nashville 16 Jan 2016! Abstract: Perhaps you’ve heard the buzz about Business Intelligence Markup Language (Biml) and wondered, “ …

The State of Power BI #powerbi

Publié le 21 décembre 2015 sur sqlblog.com
 

The 2015 has been an amazing year for Power BI. One year ago, I was commenting on this blog the public preview of Power BI dashboards. A few days ago, Microsoft released the December update of Power BI Desktop and several updates of the Power BI servic …

Liberating the DBA from SQL Authentication with AD Groups

Publié le 21 décembre 2015 sur sqlservercentral.com
 

It’s 15 years after the beginning of the century. Time to eliminate the security exposure of SQL logins, and implement integrated security. Active Directory Groups make this easy for the DBA.

Azure Data Lakes

Publié le 21 décembre 2015 sur sqlservercentral.com
 

The Data-lake is basically a large repository of data for ‘big data’ analytic workloads, held in its original format. The Azure Data Lake adds Data Lake Analytics, and Azure HDInsight. Although the tools are there for Big Data Analysis, it will require …

SQL SERVER 2016 – New T-SQL Functions – COMPRESS and DECOMPRESS

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

With every release of SQL Server, Microsoft has been adding enhancements to the product. Earlier I have written below blogs talking about new features/enhancements. SQL Server – 2016 – New Feature: Dynamic Data Masking SQL Server – 20 …

SQL SERVER – The Best Time to Buy – Devart Christmas Price Fall

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

Have you missed out the deals you were hoping to grab on Black Friday or Cyber Monday? Good news! You still have time to save. 16 December 2015 — 16 January 2016 is your next big window of opportunity for many software products from Devart. 20% O …

SQL Server 2005 End of Life: Time for a Hardware Refresh

Publié le 20 décembre 2015 sur sqlmag.com
 

On April 12, 2016 Microsoft will no longer support SQL Server 2005, meaning anyone who is still running it will not get the updates and patches Microsoft released to strengthen the solution’s security and improve performance. read more

Interview Question of the Week #050 – Query to Retrieve Second Highest Salary of Employee

Publié le 20 décembre 2015 sur journey to sqlauthority
 

There are some questions which never gets old and I keep on seeing them again and again every time I participate in the interview to help hire qualified Developers and DBA. Here is another popular question which I often see. Question: Write a query to …

MySQL – Date and Time Related System Functions

Publié le 19 décembre 2015 sur journey to sqlauthority
 

MySQL supports lot of functions to get current date and time. The following are some of the system functions. There are two functions to get current date SELECT curdate(),current_date(); There are two functions to get current time SELECT curtime(),curr …

My New Gig: Enterprise Data & Analytics!

Publié le 18 décembre 2015 sur sqlblog.com
 

I’m excited to announce my next venture: Enterprise Data & Analytics ! My role is still Data Philosopher. My job is to help clients realize the potential of their enterprise data. “How will you do that, Andy?” I’m glad you a …

Cursor-Killing: Accessing Data in the Next Row

Publié le 18 décembre 2015 sur sqlservercentral.com
 

Cursors are considered by many to be the bane of good T-SQL. What are the best ways to avoid iterative T-SQL and to write queries that look and perform beautifully? This first part in an ongoing series of cursor-killing handles inter-row analysis.


Pages :