Business Analytics from Application Logs and SQL Server Database using Splunk
Introduction Splunk is a well-known log management tool. Splunk mines log from different machines in real-time and can be used to monitor, search, and analyze gathered data. It is a Big Data log management tool that can give insight from the unstructur …
SQL Server vs Oracle: Data Masking
The post SQL Server vs Oracle: Data Masking appeared first on SQLServerCentral.
Building a Database with Flyway
The post Building a Database with Flyway appeared first on SQLServerCentral.
How to Format Dates in SQL Server (Hint: Don’t Use FORMAT!)
Introduction First of all, I agree with most of the heavy hitters in saying that you should avoid formatting in both the “Data Layer” and the “Business Layer” of your applications and that it should only be done in the “Presentation Layer”. The two big …
[From the archives] 5 things to look for in a 3rd party database monitoring tool
The post [From the archives] 5 things to look for in a 3rd party database monitoring tool appeared first on SQLServerCentral.
[Video] Office Hours: Long Answers Edition
This time on Office Hours, I let a few questions piled up at https://pollgab.com/room/brento that required in-depth answers to really do ’em justice. In particular, there was a statistics question that needed demos. Here’s what we covered: …
Let’s Make September Our Free Community Tools Awareness Month.
Last week, I was reading a brand new article from a Microsoft employee about how you should directly query sys.dm_exec_requests in order to find out what’s running on your system. “Step 1: get a stone that looks round.” I lost my mind …
Increasing the Visibility of Database Changes in Flyway Development
The post Increasing the Visibility of Database Changes in Flyway Development appeared first on SQLServerCentral.
Tracking Configuration Changes Against a Baseline
One of the great things about SQL Server is that the platform has grown to include a number of configuration options and switches that allow a DBA to get the most performance from their instance that is possible. One of the downsides of the platform, h …
Identify and Correct a Large SQL Server Error Log
The post Identify and Correct a Large SQL Server Error Log appeared first on SQLServerCentral.
Who’s Hiring in the Database Community? August 2022 Edition
Is your company hiring for a database position as of August 2022? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must inc …
Swap Columns – SQL in Sixty Seconds #199
Today we will see a quick video on how to swap columns in SQL Server. It is a widespread request. Think of the scenario where you have a form with first name and last name. Now users have input the data in a different order than you expect. In this cas …
How to Get Data Using Python in Power BI
Introduction Get data from Python in Power BI is a possible. Python is one of the most popular programming languages. Several websites consider Python as the #1. Even the DBAs feel some pressure to learn Python. SQL Server included some features to int …
A day in the life of a DBA using SQL Monitor: in a 90 second video!
The post A day in the life of a DBA using SQL Monitor: in a 90 second video! appeared first on SQLServerCentral.
Running a Python Application as a Windows Service
The post Running a Python Application as a Windows Service appeared first on SQLServerCentral.