Reading Trace Logs with Splunk Add-on for SQL Server

Hello fellow Splunkers! In this blog post, we will outline how to utilize the Splunk Add-on for Microsoft SQL Server to ingest the binary trace log data that is generated by SQL Server. 

In order to accomplish this objective, we must first establish a connection to the SQL Server instance using DB Connect. This of course involves creating an "Identity" that can authenticate to the database instance, and then creating a "Connection" via that Identity. This connection needs to be facilitated by a database driver, and one pitfall to watch out for here is to make sure to choose the...


Women Empowering Women: The Founder of Lucky Saidaty on Changing the Game for Women in the Middle East

March is Women's History Month; a time for recognizing and reflecting upon the achievements of trailblazing women across the globe. I had the honor of speaking with one such disruptor: Saphia Cadet, Founder and CEO of Lucky Saidaty. Lucky Saidaty is an online community that allows women in the Arab world to connect through its...


No Content Server Explorer for Mac OS? No Problem!

After years of owning a PC and taking my environment setup for granted, I landed with a Mac OS that has proven to be a bit of a challenge when it comes to spinning up the 11g JSK. Among the drawbacks is the lack of a Content Server Explorer (CS-Explorer) as the JSK stores it as an executable.

The lack of a Mac installer for the explorer within the JSK is not drastic. Technically, miracles can happen - or close enough - when you have an Intel processor and the help of a third-party tool. However, today I have decided to take a completely different route. Come to think of it, the...


Modern User Profile Management and GDPR

What does your business think about its customers’ privacy? Since the dawn of the internet, the answer to this question has varied from company to company. Some organizations have gone to great lengths to protect personal information, while others literally exist to aggregate and sell it to the highest bidder. All of this will change starting in May of this year.
 
Citizens of the European Union have sought a more transparent, responsible, and trustworthy attitude towards consumers from its businesses. This has ultimately led to the creation of Regulation 2016/679,...

Troubleshooting Tips for Splunk DB Connect 3

Hello, fellow Splunkers! In this post, we'll take a look at a few of the pitfalls to be aware of when using the quite powerful, but sometimes hard to troubleshoot, DB Connect (DBX) 3.1.1 application from Splunkbase. So let's jump right in, shall we?

NULL values for Timestamp

If a database table that you're importing (either rising column or batch mode) contains a column representing a timestamp, most likely you'll want to utilize that column as the timestamp of the event (database record) within Splunk, instead of using the index time as the timestamp. However, be careful! If...


Stay In Touch