Sites anglophones

The Mysterious Case of the Missing Default Value

Publié le 1 décembre 2015 sur

Sometimes things are not exactly how we think they are. Read the story of the missing default value and learn why.

SQL Server – 2016 – T-SQL Enhancement “Drop if Exists” clause

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

I was reading through some of the enhancements introduced with SQL Server 2016 and I stumbled upon an interesting addition. The T-SQL construct introduced has been something very common and on the pending request for years I suppose. So what are am I t …

What you should have read 🙂 during the weekend – weekly SQL Server blogs review part 8

Publié le 1 décembre 2015 sur

Hello! It is Monday so I am delivering you the new articles to read! Hope you will have a lot of fun reading all of them!     Author Title Link Raj Kumar Beniwal How to Import And Display Data From Web Page Using Power BI Desktop http:// …

Comprehensive Wait Stats Query for SQL 2005 – 2016

Publié le 30 novembre 2015 sur

Looking for a Microsoft SQL Server wait statistics query that works across all versions of SQL since 2005. This is the one. read more

Introduction to Storage Spaces Direct for SQL Server

Publié le 30 novembre 2015 sur

Glenn Berry introduces the exciting new feature in Windows Server 2016 called Storage Spaces Direct (S2D), which enables organizations to use multiple, clustered commodity file server nodes to build highly available, scalable storage systems with local …

Add new disks to a SQL Server Failover Cluster on Windows 2008

Publié le 30 novembre 2015 sur

This article shows the procedure to Add new disks to SQL Server failover cluster in windows 2008/2008R2. This article also covers how to add dependencies to a SQL Server cluster resource.

Leaving Linchpin People

Publié le 30 novembre 2015 sur

I’m sad and excited to announce I am no longer with Linchpin People. I’m sad because I will miss working with and leading the awesome team at Linchpin People . I’m excited to return to independent consulting as Andy Leonard Consulting …

SQL SERVER – Practical Tips to Reduce SQL Server Database Table Size – Experts Opinion

Publié le 30 novembre 2015 sur journey to sqlauthority

I am one of those fortunate people who has friends everywhere in the world. Syrovatchenko Sergey is one of my good friends who is an expert on SQL Server and works at Devart. When we met a few days ago in one of the event, we end up discussing about pr …

SSD Form Factor and interface

Publié le 29 novembre 2015 sur

There is a curious quiet from the enterprise storage community on form factor and interface direction for solid state storage, be it NAND Flash, Intel 3D XPoint or other. On the client-side, personal computing, both desktop and mobile, show clear direc …

Interview Question of the Week #047 – Logic To Find Weekdays Between Two Dates

Publié le 29 novembre 2015 sur journey to sqlauthority

I often enjoy seeing interview questions where the contestant has to write SQL Scripts. Here is another such example. Question: How to find weekdays between two dates? Answer: Here is a function which can be used to find weekdays between two dates. CRE …

SQL SERVER 2016 – Comparing Execution Plans

Publié le 28 novembre 2015 sur journey to sqlauthority

New tools bring new capabilities and sometimes these are ingrained deep into the product that we can easily miss them out. And SQL Server 2016 is no different. After installing the CTP, I was pleasantly surprised to see this addition to help our DBA …

Programmatically changing SQL Server linked tables in Microsoft Access

Publié le 27 novembre 2015 sur

Tim Wise explains how Microsoft Access provides a quick and easy way to create a simple front end for a SQL Server database by pointing linked tables to the SQL Server.

Your Usage of the Microsoft Data Platform

Publié le 27 novembre 2015 sur

Microsoft has been rapidly extending its data offering to what is now a comprehensive “data platform” intended to provide the building blocks for customers to build and extend more complex and “intelligent” applications. Redgate …

Stairway to SQLCLR Level 1: What is SQLCLR?

Publié le 27 novembre 2015 sur

The first step to using the SQLCLR begins with this overview of what is possible and what is not. Start your journey to decide if this is a tool you can use inside your SQL Server instance. How to find & fix SQL Server problems – get 26 free …

SQL SERVER – Installing and Getting Started With Semantic Search

Publié le 27 novembre 2015 sur journey to sqlauthority

After I wrote about the basics in the blog SQL SERVER – What is Semantics Search Inside SQL Server?, I had multiple requests to understand and get started with Sematic Search. So I thought to set the building blocks of working with the same. Wher …

Pages :