Database Reliability Engineer- The new DBA?
The post Database Reliability Engineer- The new DBA? appeared first on SQLServerCentral.
Automate your Morning Checklist
Every morning as you sit down at your desk, perhaps before you’ve even got your first cup of coffee, there are certain tasks that you need to check in on. A lot can happen in your estate overnight and it pays to have a process in place to p …
[Video] Watch Brent Work on sp_Blitz
During the quarantines, I’m looking for new ways to help you level up for free. I decided to start live-streaming whenever I’m working on things I can share with you publicly. I wanted to add a new check to sp_Blitz, so I figured I’d …
Check Your Backup Compliance Against a Data Management Provider
As a database administrator, it’s your responsibility to ensure the customer data won’t get lost in case of a disaster, so you either provide your own backup strategy, use a third-party script, or hire a data management provider. With the first two opt …
Congrats. Y’all Raised $8,919 for Doctors Without Borders in March.
I hate posting things on April 1, but there’s no laughing here, only cheering. During our March quarantine sale, I donated 10% of all sales to Doctors Without Borders. I’m proud to announce that y’all raised $8,919 to provide lifesavi …
SQL v.Next Gets Native Python in SQL Server
The next version of SQL Server is in early preview and there is a new feature that is going to be very useful for large enterprises that want to run Big Data Clusters and perform additional data science tasks. Instead of embedding Python code in a stri …
Tracking Underlying Object Changes in Views
Views are used to encapsulate common queries for reuse by SQL Server database objects or applications. They also allow for customized permissions to be applied while avoiding granting access to the underlying objects. While this can be hugely beneficia …
What Does This Button Do? Wrong Answers Only.
One of my favorite memes is Wrong Answers Only, where you show something and people have to answer incorrectly, like this and this and this. So now it’s your turn: you’re in SSMS, you right-click on a database, and go into Tasks: What does …
Graphical analysis of SSRS report usage with Grafana
Introduction In the following article, we will describe a much more efficent way of showing the usage statisctics of our SQL Server Reporting Services hosted reports. References Most of the queries below have been addressed in another article, Obsoleti …
Delete Data from SQL Server Table in Batches
The post Delete Data from SQL Server Table in Batches appeared first on SQLServerCentral.
Announcing Quest Database Training Days: Free Live Training with Me, Janis, and Pinal
During the quarantines, I’m trying to find as many ways as possible to get y’all free training. Today & tomorrow are the last days that you’ve got free access to the recordings of my Fundamentals of Index Tuning and Fundamentals o …
Collections: Computed gaps for continuous numbers
Problem Finding the hole for continuous sequences of numbers could be a discouraging task even for advanced programmers. This article presents a new solution based on usage of geometry data type and on a unknown function (if not, maybe less used functi …
Streamline and Acclerate SQL Server Data Warehousing
The post Streamline and Acclerate SQL Server Data Warehousing appeared first on SQLServerCentral.
Making SQL Server Function Changes Backwards Compatible
The post Making SQL Server Function Changes Backwards Compatible appeared first on SQLServerCentral.
Tagging SQL Server Changes in SQL Monitor
The post Tagging SQL Server Changes in SQL Monitor appeared first on SQLServerCentral.