Sites anglophones

[Video] Office Hours 2018/5/16 (With Transcriptions)

Publié le 20 mai 2018 sur

This week, Brent, Erik, Tara, and Richie are back in action again to and are discussing sys.dm_db usage stats, Availability Group troubleshooting, ASYNC Network IO issue, reasons for using a contained database, whether you need to add more CPUs if faci …

How to Generate Fibonacci Series for the First 1000 Values? – Interview Question of the Week #174

Publié le 20 mai 2018 sur journey to sqlauthority

Question: How to Generate Fibonacci Series for the First 1000 Values? The reason, behind this question, is very simple, if you search online you will find the most of the answers only find the first 70 or maximum 80 values of the Fibonacci series. …

SQL SERVER – SQL Server Cluster Resource Doesn’t Come Online Randomly

Publié le 19 mai 2018 sur journey to sqlauthority

This was another interesting situation where client reported that their SQL Server Cluster resource, sometimes, fail to come online when they perform failover of SQL Server from one node to another. In this blog, we would learn how to fix ” SQL S …

Stuff People Tell Me Is The Default

Publié le 18 mai 2018 sur

Playing The Odds Assuming that life carries on as usual for a couple more weeks, I’ll have been a consultant here for three years. In that time, I’ve had some really interesting conversations with people, mostly about why things are the way …

Harnessing SQL Server Metadata- Disabling and Rebuilding Indexes

Publié le 18 mai 2018 sur

When doing bulk data changes it may be beneficial to disable indexes prior to starting the operation. Fortunately, SQL’s rich metadata makes this very easy to automate in a robust fashion.

Transaction Locking and Row Versioning Guide

Publié le 18 mai 2018 sur

This guide describes the locking and row versioning mechanisms the SQL Server Database Engine uses to ensure the physical integrity of each transaction and provides information on how applications can control transactions efficiently.

SQL SERVER – Impact of Transaction on the Free Log Space

Publié le 18 mai 2018 sur journey to sqlauthority

Earlier I wrote a blog post about SQL SERVER – How to Find Free Log Space in SQL Server? After reading this blog post, I received the following question from one of the users about the impact of the transaction on the free log space. Let us creat …

How to Create Deadlocks and Troubleshoot Them

Publié le 17 mai 2018 sur

Watch in awe and wonder as I create a deadlock, then use sp_BlitzLock after the fact to show you which queries and tables were involved: Here are the scripts to run in the left hand window:CREATE TABLE dbo.Lefty (Numbers INT PRIMARY KEY CLUSTERED); INS …

Welcome to Redgate tools for SQL Operations Studio

Publié le 17 mai 2018 sur

Built on top of Visual Studio Code, SQL Operations Studio is a free lightweight tool for modern database development and operations that runs on Windows, macOS and Linux. It’s been designed for developers without a deep knowledge of database admi …

Using SQL Server as a Source with for an Excel Application

Publié le 17 mai 2018 sur

I am presenting an MS Excel VBA project which automates the display of SQL Server data tables.

Artificially Intelligent – Text Sentiment Analysis

Publié le 17 mai 2018 sur

One of the truisms of the modern data-driven world is that the velocity and volume of data keeps increasing. We’re seeing more data generated each day than ever before in human history. And nowhere is this rapid growth more evident than in the wo …

SQL Server on Linux: What You Really Need to Know

Publié le 17 mai 2018 sur

SQL Server on Linux removes the barrier to entry for organizations that prefer Linux to Windows.

SQL SERVER – Reading Transaction Log to Identified Who Dropped a Table

Publié le 17 mai 2018 sur journey to sqlauthority

The other day I received a distress email from a user who wanted to find out who has dropped a table or column from their database. During the On Demand (55 minutes) consultation, not only I was able to help them with restoring their lost data but …

Quick Tips For Debugging Large Stored Procedures

Publié le 16 mai 2018 sur

Hell Here! Get Your Fresh Hell, Here! Let’s face it — as far as developer tools go, SSMS is pretty bad. Intellisense? The jokes write themselves. Don’t get me wrong, SSMS is a good management tool, but it’s not a good devel …

Calculating Employee Attrition with DAX – Part 2

Publié le 16 mai 2018 sur

In part 1, we described the requirements for calculating attrition and also demonstrated one method that doesn’t rely on writing DAX code at all. In the second part of this tip, we introduce alternative methods of creating a calculation in DAX to …

Pages :