Sites anglophones


SQL SERVER – All the Features not Listed While Installing SQL Server

Publié le 2 juin 2018 sur journey to sqlauthority
 

I was trying to install SQL BI features for one of the assignments I had got. In the setup wizard when I reached the Features Page I got a surprise of my life. There were many features missing! I could not see features available while installing SQL Se …

Mysterious Forwarded Records

Publié le 1 juin 2018 sur brentozar.com
 

Thinking Of You When people think about Heaps and the problems they can cause, they don’t often think of temp tables and table variables as Heaps. Of course, without a clustered index, any table is a Heap. This isn’t an argument for or agai …

SQL SERVER – Always On Replica Disconnected After Changing SQL Server Service Account

Publié le 1 juin 2018 sur journey to sqlauthority
 

In my lab environment, I was testing a script to change service account and it worked fine. I had Always On configured on this SQL Server and soon I realized that after changing the SQL Server service account, the secondary replica went into a disconne …

Wanna Attend All My Classes for a Year?

Publié le 31 mai 2018 sur brentozar.com
 

Live Class Season Pass When I introduced my Live Class Season Pass, buyers got access to my entire new Mastering series for 2018. I wasn’t sure how buyers would react to the new class lineup – these classes are tough. They’re 3 d …

Automating a SQL Server Database Refresh

Publié le 31 mai 2018 sur sqlservercentral.com
 

In this tip we cover the basics of what needs to be done to setup a process to automate refreshing a dev or test environment with a recent database backup.

Using SQL Data Compare to Synchronize Custom Error Messages

Publié le 31 mai 2018 sur sqlservercentral.com
 

In this recent Redgate article Steve Jones provides a useful trick to Synchronize Custom Error Messages using SQL Data Compare

Solving the Target Principal Name is Incorrect

Publié le 31 mai 2018 sur sqlservercentral.com
 

One small point to note when we receive the below error while connecting SQL server: The target principal name is incorrect. Cannot generate sspi context

How to Enable Files & Folders Level Auditing in SQL Server? – Interview Question of the Week #176

Publié le 31 mai 2018 sur journey to sqlauthority
 

Question: How to Enable Files & Folders Level Auditing in SQL Server? Answer: Recently I was working with a client on a SQL startup issue. After spending a lot of time, we were able to find that many files were missing in Binn folder. Now, the …

How Many Kinds Of Joins Are There?

Publié le 30 mai 2018 sur brentozar.com
 

Quite So There are three in SQL Server, not counting the Adaptive Join which is just a placeholder for either Nested Loops or Hash Joins. If you look closely at each of those joins, you’ll see all sorts of interesting things pop up. Hopefully non …

Free eBook: Defensive Database Programming

Publié le 30 mai 2018 sur sqlservercentral.com
 

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of un …

PowerShell Day-to-Day Admin Tasks – Part 6: Real-Time IT Dashboard

Publié le 30 mai 2018 sur sqlservercentral.com
 

Creating a real-time IT dashboard is essential for IT professionals for managing their environments and to be proactive. A Few months ago, a great tool called ‘PowerShell Universal Dashboard’ or ‘PoshUD’ was officially released. …

SQL SERVER – Slow SQL Server 2016 Installation in Cluster: RunRemoteDiscoveryAction

Publié le 30 mai 2018 sur journey to sqlauthority
 

As a part of my AlwaysOn related consultancy, one of my clients was having challenges to install SQL Server 2016 in a clustered environment. In this blog, we would learn about the cause of Slow SQL Server 2016 Installation in Cluster. When I started SQ …

Behind Every Trivial Plan Is A Good Demo

Publié le 29 mai 2018 sur brentozar.com
 

A While Back I started this Q&A on Stack Exchange about ISNULL. It’s one of the most common client issues I see, and putting stuff like that out in a different community to get more opinions on it is valuable. Also, I’m saving up points …

TRY_CONVERT

Publié le 29 mai 2018 sur sqlservercentral.com
 

An introduction to the TRY_CONVERT function, introduced in SQL Server 2012.

Tables Without Clustered Indexes

Publié le 29 mai 2018 sur sqlservercentral.com
 

When databases are being designed and developed, your developers might have overlooked creating clustered indexes on some of your database tables. Having a useful clustered index on your tables will improve the performance of your queries. Here Greg La …


Pages :