Sites anglophones


SQL SERVER – Dynamic SQL and Global Temporary Tables

Publié le 20 juillet 2019 sur journey to sqlauthority
 

Recently I had a very interesting situation at my client where I had to visit in person for Comprehensive Database Performance Health Check. Most of my performance tuning engagements are online but there are clients who can’t share their applicat …

SQL SERVER – Upgrade Error: The Server Principal is Not Able to Access the Database “msdb” Under the Current Security Context

Publié le 19 juillet 2019 sur journey to sqlauthority
 

As soon as SQL 2008 and SQL 2008 R2 went out of support, few of my clients contacted me to help them in fixing an error occurred during the upgrade. In this blog, I would share one of the upgrade failures. The Upgrade Error messages shown in ERRORLOG w …

SQL Server Clustered Tables vs Heap Tables

Publié le 19 juillet 2019 sur sqlservercentral.com
 

The post SQL Server Clustered Tables vs Heap Tables appeared first on SQLServerCentral.

Running Linux SQL Server as a Container

Publié le 19 juillet 2019 sur sqlservercentral.com
 

The post Running Linux SQL Server as a Container appeared first on SQLServerCentral.

Diagnostic Information Queries for SQL Managed Instance

Publié le 18 juillet 2019 sur sqlskills.com - glen berry
 

I’ve put together an initial set of Diagnostic Information Queries for SQL Managed Instance. These were originally based on my SQL Server 2019 Diagnostic Information Queries, with any non-functional or non-relevant queries removed. I’ve rem …

SQL SERVER – SQL Agent Job and Backslash – Strange Behavior

Publié le 18 juillet 2019 sur journey to sqlauthority
 

Today, I am going to discuss a very interesting scenario which I encountered while working with one of the largest European financial technology organizations Comprehensive Database Performance Health Check earlier last week. I would be open with you t …

Using Attributes with Unity

Publié le 18 juillet 2019 sur sqlservercentral.com
 

The post Using Attributes with Unity appeared first on SQLServerCentral.

DBA Training Plan 2: Backups (And More Importantly, Restores)

Publié le 17 juillet 2019 sur brentozar.com
 

When I first started out as a SQL Server DBA, I thought things were going well as long as the backup jobs ran successfully. I’d go into SQL Server Agent every now and then, make sure they were still running, and … that was the end of it. I …

SQL SERVER – Enable or Disable Resource Governor

Publié le 17 juillet 2019 sur journey to sqlauthority
 

Just another day, I was involved with a client during a Comprehensive Database Performance Health Check and ended up at a very interesting situation. Our client was struggling with the memory issue and the server was running super slow. Eventually, we …

DBA Training Plan 1: Build a Server Inventory

Publié le 16 juillet 2019 sur brentozar.com
 

At your company, walk into the VP of Sales’s office and ask them how many salespeople they have. NO, I mean, don’t actually DO that, because he’s going to ask you why the sales app is so slow. But I mean, imagine if you COULD walk int …

SQL SERVER – Swap Column Values In Table

Publié le 16 juillet 2019 sur journey to sqlauthority
 

Some questions never got old and today’s we are going to discuss a similar question which was asked to me during Comprehensive Database Performance Health Check. The question was about how to swap column values in a table.Let us first create a ta …

Key findings from the State of SQL Server Monitoring

Publié le 16 juillet 2019 sur sqlservercentral.com
 

The post Key findings from the State of SQL Server Monitoring appeared first on SQLServerCentral.

SQL and T-SQL for Beginners in 229 minutes

Publié le 16 juillet 2019 sur sqlservercentral.com
 

Learning SQL is not difficult. However, you need to spend a few hours or a few days to learn the basics. On this site you can find a lot of interesting articles, but you need to know the basics of SQL or T-SQL. If you’re new to this site and some artic …

SQL Server and Excel Hierarchyid Example for Organization Charts

Publié le 16 juillet 2019 sur sqlservercentral.com
 

charts The post SQL Server and Excel Hierarchyid Example for Organization Charts appeared first on SQLServerCentral.

Glenn’s Tech Insights For July 15, 2019

Publié le 15 juillet 2019 sur sqlskills.com - glen berry
 

(Glenn’s Tech Insights… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally releva …


Pages :