[Video] Office Hours 2018/5/16 (With Transcriptions)
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
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
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
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
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
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
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
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
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
I am presenting an MS Excel VBA project which automates the display of SQL Server data tables.
Artificially Intelligent – Text Sentiment Analysis
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
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
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
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
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 …