Sites anglophones

SQL SERVER – Database Mail Breaks with TLS 1.0 Disabled Discovery – Notes from the Field #128

Publié le 16 juin 2016 sur journey to sqlauthority

[Note from Pinal]: In this episode of the Notes from the Field series database expert Ryan Adams explains a very critical error related to Database Mail. Ryan is one guy who spends more time with real world issues with SQL Server th …

SSIS 2016 Administration: Create the SSIS Catalog

Publié le 15 juin 2016 sur

Creating an instance of the SSIS 2016 Catalog is identical to creating an SSIS Catalog in SQL Server 2012 or SQL Server 2014. Follow these steps to create an instance of the SSIS Catalog on SQL Server 2016. Open SQL Server Management Studio (SSMS) and …

Triage Quiz: Is Your SQL Server Safe?

Publié le 15 juin 2016 sur

Contrary to popular belief, we spend a lot of time with clients when we’re not blogging, answering questions in Office Hours, or working on new features for the download pack. Something we hear a lot is, “How do we compare to other clients? …

Row Level Security Part 3 – Disabling Row Level Security for DBAs and Database Owners

Publié le 15 juin 2016 sur

In the third part of his series on Row Level Security (RLS), Greg Larson shows how to disable RLS for database administrators, sysadmins, and database owners.

Introduction to U-SQL and Azure Data Lakes

Publié le 15 juin 2016 sur

An introductory guide to querying files in Azure Data Lakes using Microsoft’s U-SQL language.

SQL SERVER – Unable to Start SQL Agent – SQL Server Agent Terminated (Normally)

Publié le 15 juin 2016 sur journey to sqlauthority

Along with performance issues, I also provide consultancy in other break-fix issues like service not starting etc. These are not run of the mill, but on specific cases only. I always suggest my clients to search on my blog first and then contact me if …

SQL Server 2016: Availability Groups, Direct Seeding, and You.

Publié le 14 juin 2016 sur

One of my least favorite things about Availability Groups Well, really, this goes for Mirroring and Log Shipping, too. Don’t think you’re special just because you don’t have a half dozen patches and bug fixes per CU. Hah. Showed you! …

Many-to-many relationships in DAX and CROSSFILTER #dax #powerbi #powerpivot #ssas #tabular

Publié le 14 juin 2016 sur

I wrote many articles and white papers about implementing many-to-many relationships in Analysis Services – for both Multidimensional and Tabular models. For the latter, the same techniques are also useful in Power Pivot and Power BI. With th …

Azure Machine Learning – Your first experiment

Publié le 14 juin 2016 sur

In this chapter, we will show how to create a Machine Learning experiment from our Azure SQL Warehouse.

The Internals of WITH ENCRYPTION

Publié le 14 juin 2016 sur

Paul White discusses the internals of SQL Server’s WITH ENCRYPTION clause, and explains why it is not as safe as you might think.

Some recent posts

Publié le 14 juin 2016 sur

It’s T-SQL Tuesday, but this isn’t actually my post! Regular readers might remember that I posted about “Number of Rows Read” a while back, and in that post, I mentioned that SQL Sentry should consider having a warning in Plan E …

SQL SERVER to Oracle Numeric Datatype Mapping

Publié le 14 juin 2016 sur journey to sqlauthority

Getting into a consulting business has its own set of challenges that I cherish big time. Recently I was consulted by a product team that had some of the best guys in the market. I was surprised why they might need my services. But I had an open mind t …

SQL Interview Question: “How do you respond?”

Publié le 13 juin 2016 sur

Brent’s in class this week! So you get me instead. You can just pretend I’m Brent, or that you’re Brent, or that we’re both Brent, or even that we’re all just infinite recursive Brents within Brents. I don’t care. He …

PowerShell Desired State Configuration: Pull Mode

Publié le 13 juin 2016 sur

Automated configuration management is simpler with Desired State Configuration (DSC) and Push mode, but what is the best way to use DSC to automate deployments on your machines? ‘Push’ mode or ‘Pull’ mode? How can you reduce con …

Using IronPython to talk to SQL Server

Publié le 13 juin 2016 sur

IronPython is a Python implementation build on .NET. This article shows how you can use IronPython to access SQL Server Management Objects.

Pages :