Sites anglophones

Free prototype tool to audit SQL Server permissions

Publié le 13 juillet 2017 sur

Redgate have just released SQL Census, a prototype tool from the Foundry division that makes auditing SQL Server user access permissions much easier. In this post Ally Parker shows how it works, tells us what’s up next in the tool’s development develop …

Power BI – Rename Table Column headings

Publié le 13 juillet 2017 sur

Trick to rename column headings on a Power BI Table visual

Heimdall Data Auto-Caching for SQL Server – No Changes to Application

Publié le 13 juillet 2017 sur journey to sqlauthority

I found a unique caching solution that accelerates SQL Server. Heimdall Data auto-caches and auto-invalidates, removing complex configuration. It requires zero changes to your application and database. Try out the best possible solution for auto-cachin …

New Online Course: The Fundamentals of Database Administration

Publié le 12 juillet 2017 sur

Remember that very first day when you officially became a Database Administrator? Remember how the Senior DBA sat you down and gave you clear, specific instructions on how to handle SQL Server? No? You don’t remember that? That’s because it …

SQL Server DBA On-Boarding Checklist

Publié le 12 juillet 2017 sur

How can we be sure that the new DBAs are productive a soon as possible? How can we use highly qualified contractors in the most effective way from day one?

Stairway to DAX and Power BI – Level 8: The DAX COUNT() and COUNTX() Functions

Publié le 12 juillet 2017 sur

As a part of his “Function / Iterator Pairs” mini-series, Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX COUNT() and COUNTX() functions, discussing similarities and differences. He the …

SQL Server Dump Analyzer

Publié le 12 juillet 2017 sur

Recently Microsoft released a preview version of the SQL Server Diagnostics extension to SSMS. You can read more about it here . I downloaded it from here and you can see the results below. If you install the extension while SSMS is up and running, you …

SQL SERVER – Unable to Start SQL When Service Account is Removed From Local Administrators Group. Why?

Publié le 12 juillet 2017 sur journey to sqlauthority

One of my clients wanted to secure their SQL Server. One of the rules was that wanted to avoid running SQL Server service with an account which is part of local “Administrators” group. They wanted to provide the minimal permissions needed f …

50ths… SQL Saturday and Life

Publié le 11 juillet 2017 sur

This week I will experience a couple of events associated to the number 50. SQL Saturday Atlanta The second will be my 50th SQL Saturday Event! (49th speaking, 1 attended in casual mode… 50th speaking Saturday will be in August at SQL Saturday L …

Free E-Books From Microsoft Again

Publié le 11 juillet 2017 sur

  The Director of Sales Excellence at Microsoft is once again giving away free E-Book downloads.  Apparently millions of them in fact on all sorts of topics and products.  Well not millions of different E-Books but millions of them were …

T-SQL Feature Request: Add RESET WHEN Clause to Reset Window Partition

Publié le 11 juillet 2017 sur

Window functions allow you to solve a wide variety of T-SQL querying tasks elegantly and efficiently. Still, as of SQL Server 2017, there are some tasks that are difficult to solve with efficient set-based solutions that could be handled easily and eff …

New 2-day Class: Performance Tuning By Example

Publié le 11 juillet 2017 sur

One of my most popular sessions is Watch Brent Tune Queries. I’ve updated it every year, tuning different queries, showing new tools like SentryOne’s Plan Explorer,, SSMS’s plan comparison, and SSMS 2017’s n …

Azure Data Lake Store encryption using Azure Key Vault for key management

Publié le 11 juillet 2017 sur

Case You want to create an encrypted Azure Data Lake Store (ADLS) with a master encryption key that is stored and managed in your own existing Azure Key Vault. Using this setup, which is showed in the diagram below, all data in your Data Lake Store wil …

Top 10 DevOps Operational Requirements

Publié le 11 juillet 2017 sur

One of the key tenets in DevOps is to involve the Operations team in the full software development lifecycle and, in particular, to ensure that operational requirements are incorporated into the design and build phases.

Batch SSIS pkg execution from Business Intelligence Development Studio

Publié le 11 juillet 2017 sur

The Execute Package Task and a second instance of Business Intelligence Development Studio can be a satisfactory method of background execution of SSIS packages in batch mode when you don’t have access to Integration Services.

Pages :