BI Architect Bill Pearson continues with the third of a subseries surrounding a group of MDX functions we can use to support analysis and reporting in a time / date context. In this Level, we will explore the LastPeriods() and ParallelPeriod() functions, and get hands-on practice with each in meeting sample business requirements.
There is a promotion for SQL Server 2012 customers that might be considering the cloud and worried about support.
In this article we look at how to generate random dates in SQL Server to build a sample dataset along with code and examples
In this article, we cover how to install SQL Server 2022.
I found this article to be an interesting look at how we might add ethics to AI systems in one area. As the article points out, "... today there is no broadly accepted AI ethics framework, or means to enforce it. Clearly, ethical AI is a broad topic ...". Glad someone is thinking, or many […]
Learn how you can make your visuals more interesting with the Infographic Designer Visual.
In this article, we examine how to read SQL Server data and parse it directly into a dataframe and perform operations on the data using Python and Pandas.
You can summarize data to get counts, averages, sums, and more using GROUP BY in T-SQL queries. Greg Larsen shows you how.
Today Grant wonders why we spend so much time trying to learn about query tuning.
Learn how to use golang to connect to a PostgreSQL database.
It is Friday, the queries are running, and nobody is watching the bill. That...
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
WhatsApp:0818-751-777 Jl. M.T. Haryono No.68, Tengah, Kec. Delta Pawan, Kabupaten Ketapang, Kalimantan Barat 78812...
WhatsApp:0818-751-777 Jl. Raya Utara Adiwerna No.304, 306, Pejagan, Adiwerna, Kec. Adiwerna, Kabupaten Tegal, Jawa...
WhatsApp:0818-751-777 Jl. Pangeran Diponegoro No.296, Brebes, Kec. Brebes, Kabupaten Brebes, Jawa Tengah 52212 (@bcakcpbrebes)
When running bcp on Linux, what is the field terminator?
See possible answers