Sites anglophones

SQLblog is Moving to a New Hosting Provider

Publié le 14 juillet 2017 sur

After a long run on our current hosting provider, SQLblog will be moving to a new hosting provider. During this process, starting later this evening, SQLblog will be offline for a day or two while I migrate the site to the new hosting provider. Please …

Sliding Scale Parallelism: Why Stop At DOP?

Publié le 14 juillet 2017 sur

This is a thought experiment Just fair warning, you’re probably not going to learn anything new here. This also isn’t hidden in a CTP of SQL Server 2017, and as far as I know, it’s not a consideration outside of this post. Seriously, …

SQL Server 2017 Integration Services Cookbook

Publié le 14 juillet 2017 sur

I coauthored my 15th book Together with Christian Cote (lead author) and Matija Lah (coauthor) we publishes SQL Server 2017 Integration Services Cookbook. Of course, it is kind of early to say this is a definitive guide to SSIS 2017. More accurate name …

SQL SERVER – Setup Rule: Microsoft .NET Application Security. The computer cannot access the Internet

Publié le 14 juillet 2017 sur journey to sqlauthority

There are many rules in SQL Server setup which are checked to make sure that the user is not seeing failure at the end of the installation. Most of the rules are generally passed, but few of them are known to generate warnings. One of such rule is Micr …

SQL Saturday Katowice #664

Publié le 13 juillet 2017 sur

Hello SQL Fans!! It is time for you to join SQL Saturday in Katowice!!! More details here Cheers Damian 

What I Love About the Stack Overflow Database

Publié le 13 juillet 2017 sur

I’ve been using the Stack Overflow public database for my performance tuning demos for a few years now, and I just keep finding more reasons to love it. It’s got a few simple tables with a lot of data. The main ones are Users, Posts (questi …

Performance Myths: Oversizing string columns

Publié le 13 juillet 2017 sur

Aaron Bertrand shows a quick demo that illustrates why you should be very careful about oversizing varchar / nvarchar columns.

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 …

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 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?

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 …

Pages :