Sites anglophones


New Classes: Dashboard in a Day, Database DevOps, tSQLt, SQL Server Internals, and Avoiding NOLOCK

Publié le 30 juillet 2018 sur brentozar.com
 

We’ve got a few new goodies, and they’re 50% off for a limited time! Dashboard in a Day – A hands-on workshop using Power BI to rapidly produce great looking interactive reports and dashboards. Your instructor, Microsoft MVP Steph Loc …

Common Entity Framework Problems: N + 1

Publié le 30 juillet 2018 sur brentozar.com
 

I wanna dance with common problems One of the most common issues that I’ve seen with Entity Framework isn’t technically an Entity Framework problem at all. The N + 1 problem is an anti-pattern that is a problem with ORMs in general, which m …

Building RESTful APIs using Node JS, Express JS, and MS SQL Server

Publié le 30 juillet 2018 sur sqlservercentral.com
 

This post covers the basic details that you need to know while developing a RESTful API using Node, Express and SQL Server.

Getting Started with Database Development Using SQL Provision

Publié le 30 juillet 2018 sur sqlservercentral.com
 

Steve Jones shows how a developer, who is a sysadmin on their own SQL Server instance, can migrate their existing development databases to clones, using SQL Provision. Using a simple PowerShell function, we have seen a repeatable process that is quick …

SQL SERVER – T-SQL Script: How to Search for Multiple Values in ERRORLOG?

Publié le 30 juillet 2018 sur journey to sqlauthority
 

There are many situations where we need to apply filters in ERRORLOG to look at meaningful data. In this blog, we would learn how to search for multiple values in the SQL Server ERRORLOG file. If you are new to SQL Server and don’t know what is E …

How to Check Status of Instant File Initialization? – Interview Question of the Week #184

Publié le 29 juillet 2018 sur journey to sqlauthority
 

Question: How to Check Status of Instant File Initialization? Answer: This is a follow-up question of the previous blog post which I shared earlier. Please read this blog post before reading this blog for complete information: How to Check If IFI …

[Video] Office Hours 2018/7/25 (With Transcriptions)

Publié le 28 juillet 2018 sur brentozar.com
 

This week, Erik and Richie discuss whether it’s relevant to specify data in logs in SQL cloud environment, licensing, using canary tables on Availability Groups, how Entity Framework limits tuning, reusing older databases, and more. Here’s …

SQL SERVER – How to Check If Instant File Initialization Enabled or Not?

Publié le 28 juillet 2018 sur journey to sqlauthority
 

The question such as this makes my day during the Comprehensive Database Performance Health Check. One of the DBA asked if there is an easy way to know if they have Instant File Initialization Enabled or Not for their server. Honestly, this is a v …

[Video] “Actual” Execution Plans Lie for Branching Queries

Publié le 27 juillet 2018 sur brentozar.com
 

In which I show why you can’t trust “actual” execution plans for branching stored procedures, and you’re better off using sp_BlitzCache to figure out what branches you need to tune: Demo code:CREATE TABLE dbo.TableA (ID INT); CR …

SQL Prompt code analysis: avoiding the old-style TOP clause

Publié le 27 juillet 2018 sur sqlservercentral.com
 

Phil Factor discusses SQL Prompt code analysis and the necessity for bracketed, or parenthesized, expressions.

Connect to Salesforce Data as a Linked Server

Publié le 27 juillet 2018 sur sqlservercentral.com
 

Use the TDS Remoting feature of the ODBC Driver to set up a linked server for Salesforce data.

SQL SERVER – Error 9002: The Transaction Log for Database ‘SQLDB’ is Full Due to ‘DATABASE_MIRRORING’

Publié le 27 juillet 2018 sur journey to sqlauthority
 

It is interesting to see in SQL Server that same error message is raised due to multiple reasons. One such error is 9002. In this blog, we would quickly learn about the cause of error 9002: The transaction log for database ‘SQLDB’ is full d …

Do I Have A Query Problem Or An Index Problem?

Publié le 26 juillet 2018 sur brentozar.com
 

Party Up When someone says “this query is slow”, and you can rule out contextual stuff like blocking, odd server load, or just an underpowered server, what’s the first thing you look at? There’s a lot of potential culprits, and …

Be Careful with Key Order in SQL Server Missing Index Recommendations

Publié le 26 juillet 2018 sur sqlservercentral.com
 

In this tip we look at the missing index recommendations that SQL Server automatically provides and why you should pay close attention to what is recommended and how you actually implement the new index.

Display Median Values

Publié le 26 juillet 2018 sur sqlservercentral.com
 

DO you know how to display median values from a Dataset? In this short article you will use windowing functions to do this


Pages :