Iterating Over Calculated Tables using Power Query
Problem Many of us are already aware of the looping methodologies in a programming language and their benefits. Looping helps us iterate over a set of items over and over again to obtain a final result. In this article, I’m going to demonstrate how to …
Database DevOps is gaining popularity
The post Database DevOps is gaining popularity appeared first on SQLServerCentral.
3D printing to help healthcare workers
You may not know that Tim and I are both into 3D printing in a big way. You’ll definitely know that there’s a big shortage of PPE (Personal Protective Equipment) right now across the world. Because of this, many people around the world …
Announcing Two Free Live Fundamentals Courses This Wednesday & Thursday
During the quarantines, I’m trying to keep you busy with free online training. Last week, I unveiled the new free Quest Database Training Days, and this week, I’ve got another one. I’m going to teach my Fundamentals classes live, free …
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 …