Sites anglophones

Azure Data Lakes

Publié le 21 décembre 2015 sur

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 …


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

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

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

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.

SQL SERVER – Recompiling InMemory OLTP with SQL Server 2016

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

I wrote an intetresting trivia about InMemory OLTP code previously, SQL SERVER – How to take InMemory – OLTP FileGroup Offline?. Post this one of the reader was curious enough to ask me a counter question. He wrote back stating the recovery …

Master Data Services – SQL2016 CTP3.2(December) is Released

Publié le 17 décembre 2015 sur

  In SQL Server 2016 CTP3.2 release, MDS is introducing following features. Purge Soft Deleted Members You can now purge (permanently delete) all soft-deleted members in a model version. Deleting a member only deactivates, or soft-deletes, the mem …

Give Your T-SQL a Semicolonoscopy

Publié le 17 décembre 2015 sur

In theory, all of your T-SQL statements are supposed to end with a semicolon, like this: SELECT * FROM dbo.Posts; SELECT * FROM dbo.Comments; GO Why? Well, SQL Server 2005’s Books Online says: Many code examples use a semicolon (;) as a Tran …

SQL Server 2016 : In-Memory OLTP Enhancements

Publié le 17 décembre 2015 sur

Aaron Bertrand takes a look at the changes in store for In-Memory OLTP (the feature formerly known as « Hekaton »). New DLM Dashboard – free toolWhen your databases drift from their expected state, there’s a risk of deployment problems. New D …

Daily Database Backup Scripts

Publié le 17 décembre 2015 sur

Execute these stored procedures to backup all your database daily and your transaction logs several time daily. Save space by using the overwrite feature.

SQL SERVER – How to Create a Readable Secondary Server in SQL Server Standard – Notes from the Field #107

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

[Notes from Pinal]: The basic nature of human is greedy. When we get one thing which we desire the next thing. In the early world of SQL Server we got a secondary server as a backup or high availability. In earlier times the secondary server was not re …

Data Tales #5: The Case of the Rogue Index

Publié le 16 décembre 2015 sur

It can be painful to see performance problems caused by poor or inappropriate indexing choices without the ability to make strategic indexing changes. In some cases you can though… read more

Pages :