T-SQL Tuesday #102: Giving Back
Last month we had the opportunity to discuss some of the most important tools for a data professional. I took...
2018-05-09
292 reads
Helper procedure to dynamically execute list of statements
I try to avoid dynamic SQL as much as possible and consider it as a necessary evil. However, in some...
2018-05-21 (first published: 2018-05-09)
2,511 reads
Running MySQL on a VSTS build agent
I had a requirement to run MySQL on a VSTS hosted build agent and then to be able to run...
2018-05-08
223 reads
Running MySQL on a VSTS build agent
I had a requirement to run MySQL on a VSTS hosted build agent and then to be able to run commands from outside of the container and this gave...
2018-05-08
11 reads
SQL Server Snapshot vs Read Committed Snapshot
For a quick introduction to transaction isolation levels see my previous post on them.
Once snapshot isolation is enabled on a...
2018-05-08
2,204 reads
T-SQL Tuesday: Giving back to the community
This month’s T-SQL Tuesday from Riley Major (b|t) asks us to figure out a way to give back to the...
2018-05-08
409 reads
#tsql2sday – Giving Back – Reprise
It’s TSQL Tuesday again! This month our host is Riley Major (b/t) and the subject is Giving Back. He’s given us...
2018-05-08
235 reads
Quick tip: Refresh IntelliSense cache in SSMS
If you work with multiple windows or make a change using SSMS to an object, sometimes IntelliSense does not reflect...
2018-05-08
287 reads
Day 8 Configuration- Command-line
Yesterday we discuss about different ways of options and configuring with environment variable which will place MySQL locate for values...
2018-05-08
231 reads
T-SQL Tuesday #102 – Giving Back
This month Rily Major (b | t) ask us to talk about how we are giving back to the community if...
2018-05-08
76 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
Alamat Kantor BCA KCU Galaxy Tlp:(08218154374)
WA CS 628218154374 Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec. Sukolilo, Surabaya,...
Alamat Kantor BCA KCU Malang Tlp:(08217555651)
WA CS 628217555651 Jl. Jenderal Basuki Rahmat No.70-74, Klojen, Kec. Klojen, Kota Malang, Jawa...
Alamat Kantor BCA KCU Rungkut Tlp:(0817825533)
WA CS 628217825533 Jl. Raya Kendangsari Industri No.2, Kendangsari, Kec. Tenggilis Mejoyo, Surabaya, Jawa...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers