Performance Tuning Using Free Tools, Part 2
Does the cost of running SQL Server often surprise you? The cost may come from buying on-premises hardware or paying Azure SQL bills. You can keep the cost under control by improving the efficiency of your databases. You can improve your databases usin …
A Database DevOps Workflow Using Redgate Deploy
The post A Database DevOps Workflow Using Redgate Deploy appeared first on SQLServerCentral.
Error Handling Quiz Week: Making a Turkey Sandwich with XACT_ABORT
CAN YOU BELIEVE THAT HOT MESS IN YESTERDAY’S POST?!? I know, right? You thought that by combining try/catch with a transaction, you’d get robust error handling. Instead, you ended up with half the tables populated, and a leftover open …
A Fond Farewell
If you haven’t guessed from the title, I’m writing this post because I am leaving SQLskills. This Friday, January 14th, is my last day, and I am currently a mess of emotions. I am leaving on the best terms possible, and it’s bec …
The Curious Case of… tracking page compression success rates
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working …
Error Handling Quiz Week: Combining Transactions And TRY/CATCH
In yesterday’s epic cliffhanger, you might have been shocked to discover that a plain ol’ transaction does not solve our problem – and in fact, it makes things worse. With yesterday’s code, we still got rows inserted into the Pa …
Creating a SQL Server Agent Job to Run Python Scripts in a Virtual Environment
The post Creating a SQL Server Agent Job to Run Python Scripts in a Virtual Environment appeared first on SQLServerCentral.
Automating Flyway Undos
The post Automating Flyway Undos appeared first on SQLServerCentral.
Error Handling Quiz Week: Will a Transaction Help?
In yesterday’s post, we tried a TRY/CATCH, and those of us who actually ran the demo scripts were disappointed. We found that a TRY/CATCH alone doesn’t fix it: we end up getting rows in the Parent table, but no rows in the Child table. It t …
Error Handling Quiz Week: Tryin’ TRY/CATCH
Let’s say we have two tables, Parent and Child, and we need to guarantee that they both get populated at once. We’ll write a single stored procedure to do both inserts:DROP TABLE IF EXISTS dbo.Parent; DROP TABLE IF EXISTS dbo.Child; CREATE …
Getting Started with Cloud-hosted Databases using Spawn
The post Getting Started with Cloud-hosted Databases using Spawn appeared first on SQLServerCentral.
How to filter DAX for paginated reports
The post How to filter DAX for paginated reports appeared first on SQLServerCentral.
The Changing Landscape of Information Management
Introduction In today’s world, data is considered the new gold. Every enterprise is in a rush to gather as much data as possible. Data is being monetized and taken care of more than ever. Enterprises are working hard to make sure they can capture …
Query control made easy
Overview As we all know, data security is a never-ending battle. Every day, we hear of new data breaches. It’s a hard problem, and there is no single solution, other than a defense in depth. Let’s look at one of those defenses for databases: query cont …
Analyze Live Salesforce Data in Infragistics Reveal
Infragistics Reveal is a data visualization solution that simplifies the way you add embedded analytics and visualizations to your apps. Reveal supports connecting to OData APIs, but many enterprise APIs are not built using the OData standard. By combi …