Many organizations are taking advantage of the benefits of cloud computing such as lower capital expenditures and increased agility, while still maintaining data in on-premises data stores. This paper describes best practices for security, networking, and component architecture for building a hybrid business intelligence (BI) environment by using a combination of Microsoft Office 365, Microsoft Azure, and on-premises data sources.
Windowing functions aren't just for analyzing numbers/dates. Using windows functions to analyze when a character field changes is a little know resource
We often need to import data into SQL Server from a file. Sometimes unwanted end of line characters are part of the source file and these can create issues when importing the data. One of the ways to avoid this issue is to use SQL Server Integration Services (SSIS), but it doesn't always make sense to use SSIS for simple operations. Rahul Mehta explains that he uses BULK INSERT sometimes faces issues with Line Feeds and Carriage Returns. In this post, Rahul shows some examples and explains how to fix the issue.
In this case study, see how database containers can help improve a QA process.
The steps required to create an Amazon Web Services EC2 instance and install the latest SQL Server version on the EC2.
Sometimes you know a query is out there, but it’s hard to find the exact query. In this post, Kendra Little gives example code to find queries using a specific index, or using an index hint.
Mistakes will still be made with a DevOps process, but the benefits outweigh the mistakes.
Learn how to enable trace flags to change the behavior of your SQL Server instance.
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
By way of background, a while back I did video called “My New Favourite...
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WA:08218154393 Jl. Asia Afrika No.122-124, Paledang, Kec. Lengkong, Kota Bandung, Jawa Barat 40261
WA:08218154393 Jalan Marsma R. Iswahyudi 05, Rukun Tetangga No.20, Sepinggan, Kecamatan Balikpapan Selatan, Kota...
I have this data in the dbo.Commission table in a SQL Server 2022 database.
salesperson commission Brian 12 Brian 16 Andy 7 Andy 14 Andy 21 Steve 20 Steve NULLAll the data is a varchar, and I decide to run this query to get the totals for each salesperson.
SELECT SalesPerson
, AVG(TRY_PARSE(Commission AS int)) AS TotalCommission
FROM commission
GROUP BY SalesPerson
GO
What average commission is calculated for Steve? See possible answers