Sites anglophones

How to Remove Transparent Data Encryption From a Database

Publié le 14 août 2018 sur

There may be a time when you want to turn off transparent data encryption on one of your TDE enabled databases. In this tip, Greg Larsen shows you how simple it is to remove Transparent Data Encryption.

SQL SERVER – DBA Disruptors eCourse

Publié le 14 août 2018 sur journey to sqlauthority

Performance tuning is indeed very simple in the real world but many experts often project it as a very complex task. I often think it is because that expert would love to project that they are master of some complex art, which is not easily mastered. H …

Setting Up SQL Server: People Still Need Help

Publié le 13 août 2018 sur

I Like What’s Happening I wanna start off by saying that I like what Microsoft has been doing with the setup process — it made a lot of sense to add the tempdb configuration screen, and having a checkbox to turn on Instant File Initializati …

The conflict between data protection and DevOps

Publié le 13 août 2018 sur

Data breaches are the new normal – according to the Identity Theft Resource Center there were nearly 1,600 of them in 2017 in the US alone, exposing 179 million records. No wonder companies want to keep data confidential and protected. At the sam …

Why QUOTENAME is important

Publié le 13 août 2018 sur

Why good use of QUOTENAME can easily prevent injection and unexpected behaviour in Dynamic SQL.

Go Unit Tests: Tips from the Trenches

Publié le 13 août 2018 sur

In this article, Michael Sorens describes unit testing for applications written in Go. While focused on Go, many of his recommendations and techniques can be applied to other languages as well.

SQL SERVER – COUNT, FROM and a Query – Interesting Observation

Publié le 13 août 2018 sur journey to sqlauthority

In this blog post today we will see an interesting observation which is related to COUNT and FROM clause in a single query. During my recent Comprehensive Database Performance Health Check, this was brought to my attention by one of the attendees. When …

[Video] Office Hours 2018/8/8 (With Transcriptions)

Publié le 12 août 2018 sur

This week, Brent, Tara, Erik, and Richie discuss troubleshooting port blocking, page life expectancy issues, problems with turning off CPU schedulers, coordinating two jobs across servers, adding additional log files to an almost-full partition, tips f …

What is Lock Pages In Memory? – Interview Question of the Week #186

Publié le 12 août 2018 sur journey to sqlauthority

Question: What is Lock Pages In Memory? Answer: When enabled, it allows accounts to keep data in physical memory, instead of paging it to virtual memory on disk. In simple words, Lock Pages in Memory can help improve your system’s performance in …

Free Video Learning – Practical Real World Performance Tuning

Publié le 11 août 2018 sur journey to sqlauthority

Earlier I wrote a few blog post about my experience with Practical Real World Performance Tuning. I have so far presented the session 4 times and I had an amazing response to my training. When I am writing this one there are over 37 positive  …

The SQL Server Fill Factor Setting that Should Always Be Followed (and How to Do It)

Publié le 10 août 2018 sur

Most databases are created well before any real usage occurs, increasing the chances of an inaccurate SQL Server Fill Factor setting.

First Responder Kit Release: A Year From Now These Will All Stop Working On 2008 And 2008R2

Publié le 10 août 2018 sur

You think I’m kidding. Time bomb. Boom. Get your upgrade underwear on. You can download the updated here. sp_Blitz Improvements#1664 – We’re officially smart enough to not warn people that we’re r …

The First 3 Things I Look At on a SQL Server

Publié le 10 août 2018 sur

1. Are backups and CHECKDB being done? Before I step out on the wire, I want to know if there’s a safety net. If there’s a recoverability risk, I don’t stop here – I keep looking because the rest of the answers affect the safety …

Learning about FOR JSON

Publié le 10 août 2018 sur

Links and information about the FOR JSON clause in SQL Server 2016.

SQL SERVER – WMI Error 0x80041017 – Invalid Query Using WBEMTest

Publié le 10 août 2018 sur journey to sqlauthority

During my free time, I do provide assistance to the community. Sometimes via forums, sometimes by giving a free session to local user group related to SQL Server. In this blog, I would share the steps to fox WMI error 0x80041017, Invalid Query. In one …

Pages :