In talking with Microsoft customers, I have found that most are not aware that Microsoft has created industry clouds (see Microsoft Industry Clouds). So I wanted to use this...
2022-01-28 (first published: 2022-01-18)
154 reads
In the last post I wrote about what ScriptDOM is and why it is useful. From this post, I will explain how it can be put to use. What...
2022-01-28 (first published: 2022-01-27)
98 reads
Have you ever had to find the number of rows in a user table, and then wrote a little “SELECT COUNT(*) FROM tblWhatever” and hit execute…and waited…and waited…and waited...
2022-01-28
290 reads
This article will demonstrate the method to store comma-separated values into different columns using SQL Server(T-SQL) query.
2022-01-28
473 reads
Today's post describes SQL queries to get the following information about the processors of a SQL Server instance: 1. The total number of ph
2022-01-28
168 reads
This article will describe how to get a list of SQL Server agent jobs without notifications using T-SQL . Read more here
2022-01-28
155 reads
Learn how to change the Master Key encryption password for an SQL Server Integration Services Catalog (SSISDB) database in SQL Server.
2022-01-28
70 reads
There are many interesting questions related to date calculations. For example, I have seen the following questions Give a date, find the first Tuesday day of the previous week/month/quarter,...
2022-01-28
140 reads
I got a note this week from the organizers of VS Live. They let me know the March event in Las Vegas was being cancelled. That was disappointing to...
2022-01-28
4 reads
Heraflux Technologies was invited to co-present on an “Ask the Experts” webinar with Pavilion Data featuring Costa Hasapopulous, Pavilion Data’s Chief Field Technology Officer, and myself! RSVP for this...
2022-01-28
7 reads
By Steve Jones
ochisia – n. the fear that the role you once occupied in someone’s life...
Praise whatever deity you believe in, because it’s finally here, a tenant switcher for...
Yesterday, Microsoft released the highly anticipated Windows 11 ARM ISO image, marking a major...
With in the paginated report I am trying to display on each new page...
Hi All, I have plan to upgrade SSIS and SSRS from SQL Server 2016,...
When building statistics, there is the concept of density that refers to the duplicates in a table. How is this calculated?
See possible answers