Sites anglophones

Changing Replication Passwords

Publié le 2 août 2016 sur

A how-to guide for configuring replication agents after a password change

Strengthening the Foundations of Software Architecture

Publié le 2 août 2016 sur

The term ‘Architecture’ seems to imply a plan that you can’t easily subsequently deviate from. It’s true that, if you abandon software architecture, you end up with a big ball of mud, but maybe the art of software is to make change much easier by plann …

SQL SERVER – Setting Firewall Settings With Azure SQL Server VMs

Publié le 2 août 2016 sur journey to sqlauthority

Recently I had a session around using SQL Server on Azure and during this session one of the questions was to access the SQL Server in a Hybrid Setup. This is a typical scenario wherein the developer was requesting to connect to the SQL Server running …

Announcing Biml Academy 2!

Publié le 1 août 2016 sur

Biml Academy 2 – Lessons 5-9 – will be 15-19 Aug 2016. Each 1-hour session will begin at 1:00 PM EDT and will be recorded. Join Cathrine Wilhelmsen ( blog ), BimlHero and Microsoft Data Platform MVP, Scott Currie (creator of Biml and Mist ) …

Dell DBA Days Prep: Using StackExchange Queries to Generate Workloads

Publié le 1 août 2016 sur

One of my favorite questions is, “How can I generate workloads to run against SQL Server for testing?” Step 1: get the database. This 100GB database has a relatively simple schema, just a few tables, real-world data d …

Introduction to Azure SQL Database Temporal Tables

Publié le 1 août 2016 sur

As announced on June 1, 2016, SQL Server 2016 has reached its general availability. This means that you finally have the option to implement some of its new features in the production environment. While we still have to wait for their full support in A …

How to Run Scheduled Jobs in Azure SQL Databases

Publié le 1 août 2016 sur

This article will help you to schedule jobs in Azure SQL.

SQL SERVER – Unable to Create Listener for AlwaysOn Availability Group in Azure via Template Deployment

Publié le 1 août 2016 sur journey to sqlauthority

Recently I was trying to help a customer who was deploying AlwaysOn Availability Group in Microsoft Azure via template deployment. The template was failing with below error StatusMessage { “status”: “Failed”, “error” …

SQL Professionals On the Road – Episode 1: Tim Ford and Others – Iceland SQLSaturday

Publié le 31 juillet 2016 sur

Last month I had the opportunity to be one of only 2 US speakers to present at Iceland’s first SQLSaturday. This article is about that experience and the travel experience of veteran Microsoft Data Platform professionals on the road. Oh, and we tossed …

Does Dropping Primary Key Drop Clustered Index on the Same Column? – Interview Question of the Week #082

Publié le 31 juillet 2016 sur journey to sqlauthority

Question: When we drop primary key on the column, does it automatically drop a clustered index on the same column (if created)? Answer: This is one of the most popular questions, whenever I ask this to any candidate, they usually give an answer in …

[Video] Office Hours 2016/07/27 (With Transcriptions)

Publié le 30 juillet 2016 sur

This week, Brent, Richie, Erik, and Tara discuss speeding up performance, how to make SSRS highly available, what to do with SSIS packages when making upgrades, Windows Core, and how to hide data from DBAs when they have SA access. Here’s the vid …

Life Lessons – Understanding Your Customer

Publié le 30 juillet 2016 sur journey to sqlauthority

A couple of weeks back, I wrote a blog around – Life Lessons – Are There Rules for Interacting With Customers. This has been just to write out what I had in mind and how I approached a customer in general. These are not rules written on sto …

How To Fix Forwarded Records

Publié le 29 juillet 2016 sur

Some of our clients have very high forwarded record counts and aren’t aware of it. Some of these clients are using Ola Hallengren‘s IndexOptimize stored procedure to maintain their indexes. This brought up a question of whether or not rebui …

Mag Instrument Upgrades Its ERP System with the HPE Superdome X and Microsoft SQL Server

Publié le 29 juillet 2016 sur

There’s nothing like real-world examples to illustrate a platform’s true capability to support enterprise-level production workloads. Flashlight maker Mag Instrument, for example, used HPE’s Superdome X and Microsoft SQL Server to mod …

Stairway to T-SQL: Beyond The Basics Level 9: Dynamic T-SQL Code

Publié le 29 juillet 2016 sur

There times when you need to write T-SQL code that creates specific T-SQL Code and executes it. When you do this you are creating dynamic T-SQL code. When writing dynamic T-SQL you need to understand how dynamic code opens the possibilities for a SQL i …

Pages :