[Video] Altering Datatypes With (Almost) No Downtime
Sometimes, your INT columns run out of space, and you need to alter them to be a larger datatype, like BIGINT. Usually, when you do this, you’re met with screams of agony from your end users because this will totally lock the table and rewrite th …
Create Custom Functions in Power Query
Introduction Often at times, you may come across situations where you need to calculate a column repeatedly multiple times in the same Power BI report or across multiple reports. Although you can use the calculated columns to some extent, these are not …
Try one of our new candidate screening tests at Kandio!
We’re excited to announce that we have a new partnership! We’ve been involved in a lot of recruiting processes for our clients and realized we could save everyone time and money by pre-screening candidates. To that end, we’ve teamed u …
What’s Your Favorite SQL Server Interview Question? Here’s Mine.
“Out of the stuff on your resume, what are you the proudest of, the most excited about? When I’m interviewing a candidate for one of my clients, I’ll usually start with this question to help understand the resume. See, recruiters seem …
A Data Science Approach in Product Analytics
A significant part of product development is A/B testing. Simply put, this is where companies and product managers test to see a new version of their product versus the older one to make sure it’s worth publishing their features to the entire use …
Getting Started with CQRS – Part 3
The post Getting Started with CQRS – Part 3 appeared first on SQLServerCentral.
Free Training Week: How I Use the First Responder Kit – sp_BlitzLock
This week, I’m giving away modules from my How I Use the First Responder Kit class. So far, we covered a server-wide health check with sp_Blitz, then a server-wide performance checkup with sp_BlitzFirst, then using sp_BlitzCache to find the …
How to Set Up Transactional Replication
How many of you hear the word replication and shudder? There are indeed a lot of moving parts to it, but it is a valuable tool, and it is worth learning how to use. In this article, I’ll show you how to set it up. For those of you who are new to …
Free Training Week: How I Use the First Responder Kit – sp_BlitzIndex
This week, I’m giving away modules from my How I Use the First Responder Kit class. So far, we covered a server-wide health check with sp_Blitz, then a server-wide performance checkup with sp_BlitzFirst, then using sp_BlitzCache to find the …
Helpful Unix Commands/Debugging made easy
Introduction As part of ETL (SSIS/DataStage) processing, data files are loaded into tables. There are times when data files received have issues, causing the ETL process to abort. The ETL (SSIS/DataStage) process on failure would give some idea on caus …
Solve SQL Server Agent Job Dependencies with Data Driven Solution
The post Solve SQL Server Agent Job Dependencies with Data Driven Solution appeared first on SQLServerCentral.
Take the 2020 State of Database Monitoring Survey
The post Take the 2020 State of Database Monitoring Survey appeared first on SQLServerCentral.
Free Training Week: How I Use the First Responder Kit – sp_BlitzCache
This week, I’m giving away modules from my How I Use the First Responder Kit class. So far, we covered a server-wide health check with sp_Blitz, then a server-wide performance checkup with sp_BlitzFirst. Today, we’re using sp_BlitzCach …
Advanced Performance Tuning for Microsoft SQL Server
The post Advanced Performance Tuning for Microsoft SQL Server appeared first on SQLServerCentral.
Codd’s Twelve Rules
Let me take you back to those thrilling days of yesteryear when the relational model and relational databases were the fads that all hip kids were getting into. Yes, we have fads in IT. Sometimes it’s a new programming language that will solve al …