Microsoft at the PASS Data Community Summit 2023
Microsoft will be presenting a number of sessions at the PASS Data Community Summit 2023. Read about their plans for the event and register to come if you can.
Microsoft will be presenting a number of sessions at the PASS Data Community Summit 2023. Read about their plans for the event and register to come if you can.
Today Steve has a few thoughts about some of the nightmare interview processes tech workers are going through.
This article shows how one can run a machine learning activity in an Azure Data Factory (ADF) pipeline.
In this article, we look at how to read data stored in a lake database using Azure Synapse Analytics to help reduce overall Azure costs.
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.
This comic was retweeted into my timeline on Twitter (I refuse to call it...
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday, possibly querying it,...
By Brian Kelley
Just as it's important to take care of our physical health (and I'm guilty...
My agency has been using the combo of on-premises SQL Server for the back...
Development Environment I am learning how to use pyodbc and accessing database in SQL...
We are seeing multiple frequent deadlocks occurring with the following extract of code, which...
I want to enable two trace flags, 4199 and 4137, for a single query. How should I do this:
-- A SELECT a.AddressID , a.AddressLine1 , a.AddressLine2 , a.City , a.StateProvinceID , a.PostalCode , p.FirstName , p.LastName FROM Person.Address a INNER JOIN person.Person AS p ON p.rowguid = a.rowguid WHERE City = 'SEATTLE' AND PostalCode = 98104 OPTION (QUERYTRACEON 4199, 4137); -- B SELECT a.AddressID , a.AddressLine1 , a.AddressLine2 , a.City , a.StateProvinceID , a.PostalCode , p.FirstName , p.LastName FROM Person.Address a INNER JOIN person.Person AS p ON p.rowguid = a.rowguid WHERE City = 'SEATTLE' AND PostalCode = 98104 OPTION (QUERYTRACEON 4199, QUERYTRACEON 4137); -- C SELECT a.AddressID , a.AddressLine1 , a.AddressLine2 , a.City , a.StateProvinceID , a.PostalCode , p.FirstName , p.LastName FROM Person.Address a INNER JOIN person.Person AS p ON p.rowguid = a.rowguid WHERE City = 'SEATTLE' AND PostalCode = 98104 OPTION (QUERYTRACEON 4199), (QUERYTRACEON 4137);See possible answers