I love honeybees. This will be my seventh year as an amateur beekeeper, and aside from family or data, there are few other topics that I could easily spend an afternoon talking to you about. They’re amazing creatures. This past winter I had to move my beehives temporarily to the apiary of a friend. With […]
In this article, we develop the Power BI DAX formula for basket analysis. It is the technique used in retail industry for market based analysis.
How many monitors do you need? Steve notes that having multiple ones seems to be a standard these days for tech workers. Do more make you more productive? Answer the poll today.
Let’s start by defining a subset and why you would require a data subset? When dealing with the development, testing and releasing of new versions of an existing production database, developers like to use their existing production data.
Steve talks about certifications today, after watching a video that showcases the benefits of why they are good for your career.
Sometimes you need to reach outside a database and access data and objects from multiple databases, which raises some security issues and increases the complexity of data access. In this stairway level, you’ll learn about cross-database ownership chaining so that you can reach across database boundaries securely.
Learn about using filtered indexes for SQL Server tables and some of the potential issues you might be faced with when using a filtered index.
Learn how to query data in Azure Data Explorer using Python.
Are DBAs going to be responsible for financial accounting for cloud resources as a part of their job? Steve has a few thoughts today.
In my previous post, I showed how to borrow a snake draft concept from fantasy football, or a packing technique from the shipping industry, to distribute different portions of a workload to run in parallel.
This one is an oldie in my blog drafts, but a goodie! So, I...
Summer is here, and it's the perfect opportunity to enhance your SQL expertise with...
Let’s have devs look at their own query performance. Yes, please, sign me up...
Comments posted to this topic are about the item Using AI for the First...
Comments posted to this topic are about the item PowerBI premium capacity administration: dataset...
By Stewart "Arturius" Campbell
Comments posted to this topic are about the item Basic Always On Availability Groups...
I created this trigger in SQL Server 2022:
CREATE TRIGGER checksteve ON ALL SERVER FOR LOGON AS BEGIN IF ORIGINAL_LOGIN()= N'ARISTOTLE\Steve' PRINT 'Steve logged in' END; GOWhere can I view "Steve logged in"? See possible answers