Sites anglophones

SQL SERVER – Puzzle – Strange Behavior With Extra Comma in Create Table Statement

Publié le 30 janvier 2018 sur journey to sqlauthority

Today’s puzzle is very interesting and my favorite puzzle to ask right at the beginning of the presentation. This puzzle helps to break the ice between audience while people are still settling in the audience. Let us see my favorite puzzle of …

More live online training from Kimberly in March!

Publié le 29 janvier 2018 sur - paul randall

Due to the popularity of Kimberly’s delivery of her new IEVLT: Immersion Event on Very Large Tables: Optimizing Performance and Availability through Partitioning in January, and the fact that many of you told us that you didn …

Froid: How SQL Server vNext Might Fix the Scalar Functions Problem

Publié le 29 janvier 2018 sur

Scalar functions and multi-statement table-valued functions are notorious performance killers. They hide in execution plans, their cost is under-estimated, the row estimates are way off, they cause queries to go single-threaded, I could go on and on. T …

The top 7 business benefits of establishing DevOps in your organization

Publié le 29 janvier 2018 sur

Any change within an organization requires an investment of time, expertise and money. Therefore, it is natural that leaders should assess the potential of DevOps in terms of what it will deliver: Managers should ask the question: What is to be gained …

Sending table form HTML emails from a SQL Server database engine

Publié le 29 janvier 2018 sur

The solution which helps to smiplify delivery of a table content in the HTML form using Database mail

SQL SERVER – Nested Triggers – Trigger Calling Another Trigger Error

Publié le 29 janvier 2018 sur journey to sqlauthority

Recently I have received a very interesting question in an email. The user wanted to know how will trigger behave when there are nested triggers. In an email, he described a scenario where trigger called another trigger. I really liked the question and …

First Responder Kit Release: Sunday, Boring Sunday

Publié le 28 janvier 2018 sur

This is a modified limited release. After a few new feature releases, we’re achieving stasis. You can download the updated here. There are a couple points from the last release that I really need to emphasize: sp_BlitzC …

How to Drop All the User Created Statistics by SQL Server? – Interview Question of the Week #158

Publié le 28 janvier 2018 sur journey to sqlauthority

Question: How to Drop All the User Created Statistics by SQL Server? Answer: A very popular question I often see being discussed in various forums. SQL Server automatically creates the statistics when needed if you have enabled “auto create …

SQL SERVER – 2017 – Script to Clear Procedure Cache at Database Level

Publié le 27 janvier 2018 sur journey to sqlauthority

When my customer ask they want to clear the cache of the database, I always so NO. It is not necessary. However, I have come to the realization that customers are always right and sometimes even though I say no, they still want to do it. One way o …

Why I attend conferences and why I speak at conferences

Publié le 26 janvier 2018 sur

I recently published a new blog post on SQLBI.You can read it at this link:

New Speed Controls for Training Videos

Publié le 26 janvier 2018 sur

All of our training classes include Instant Replay, the ability to watch a recorded version of your training class as soon as you buy. This lets you start learning right away, prepping for the live class, and then you get to see an updated version afte …

How Can DevOps Concepts Provide Value in Digital Transformation Projects?

Publié le 26 janvier 2018 sur

For some of us, DevOps means startups, cloud, fast-moving social media applications and Extreme Programming (XP). What about large corporate IT initiatives, Digital Transformation projects, and business process re-engineering? Can DevOps be relevant an …

The Database DevOps Challenges SQL Clone Solves

Publié le 26 janvier 2018 sur

With its PowerShell integration, SQL Clone becomes an important component in a broader database DevOps toolchain – Tony Davis explains in detail.

SQL SERVER – Simple Script to Match Session ID to OS Thread ID

Publié le 26 janvier 2018 sur journey to sqlauthority

I often get asked a question about how actually Session ID of SQL Server is mapped to Operating System’s’ Thread ID. Well, the answer is very simple, here is the script which provides us three important details – SQL Session ID, OS Th …

Degree of Duplication

Publié le 25 janvier 2018 sur

The relational model was strongly based on sets. It wasn’t enough that a table had to have a key (originally a primary key, but later we realized all keys were keys). As Jim Gray put it in the early days of RDBMS, “We had no idea what we we …

Pages :