When it comes to migrating applications to Azure, there are a number of paths available. But if you’re migrating on-premises ... Continue reading
2020-03-25 (first published: 2020-03-17)
302 reads
This is one of several posts on modernizing T-SQL code with new features and functionality available in SQL Server. Last year, you finally retired the last of your SQL...
2020-03-17
131 reads
This is one of several posts on modernizing T-SQL code with new features and functionality available in SQL Server.
Last year, you finally retired the last of your SQL Server...
2020-03-17
19 reads
I’ve not done much BI work in my career, other than simple aggregates in reports. I’ve wanted to tackle projects, but I’ve rarely had a chance to spend time...
2020-03-16
230 reads
Dynamic Resource Scheduling (DRS) should be enabled for all VMware host clusters, especially those who run SQL Server. It provides for resource consumption load balancing functionality into a host...
2020-03-25 (first published: 2020-03-16)
364 reads
There are many ways to share the dashboards, reports, and datasets that you create in Power BI. Below I’ll compare all such options (there are twelve!). First make sure...
2020-03-16
107 reads
We’ve cancelled our upcoming Meetups in April and May due the loss of our venue (due to corona virus worries) though we would have probably cancelled them anyway. Our...
2020-03-16
21 reads
One reason a lot of people don’t like Extended Events is because the output is in XML. Let’s face it, XML is a pain in the bottom. However, there...
2020-03-24 (first published: 2020-03-16)
267 reads
The full message when connecting to your Azure SQL Database is: Reason: An instance-specific error occurred while establishing a connection to SQL Server. The public data endpoint on this...
2020-03-16
391 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2020-03-16
6 reads
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Referrals have never been more important in the job market. They’re no longer nice...
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
WhatsApp:0817781222 Jl. Gusti Hamzah No.85, RT.02/RW.01, Pendawan, Kec. Sambas, Kabupaten Sambas, Kalimantan Barat 79465
WhatsApp:0817781222 Jl. P Antasari No.21, Tlk. Lerong Ulu, Kec. Sungai Kunjang, Kota Samarinda, Kalimantan...
I have about 100 Tables that are all suffixed with _Modify. These tables record...
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers