Creating Azure Database for MySQL and using Azure Cloud Shell
After using Microsoft SQL Server for over 10 years going back to MySQL feels weird BUT with Azure it is...
2017-05-15
392 reads
Blog Posts
Monday Coffee 2017-05-15
After the latest cyber attack I’ve had a fun weekend making sure all my devices are fully up-to-date with the...
2017-05-15
381 reads
SQL Saturday Atlanta Precon – The Complete Primer to SQL Server Virtualization & Cloud
If you are attending this year’s SQL Saturday in Atlanta, GA, on July 15, I urge you to attend my preconference training session...
2017-05-15
382 reads
SQL Server 2017 – The operating system returned the error 21
Recently, I was exploring SQL Server 2017 CTP 2.0 using SQL Server Management Studio V17. Till the time, I was...
2017-05-15
4,660 reads
SQL Server 2017 sys.dm_os_enumerate_fixed_drives
In SQL Server 2017, you can use the new DMV sys.dm_os_enumerate_fixed_drives to identify free disk space. The DMV is replacement...
2017-05-15
1,548 reads
Trying GO with SQL Server
Not the batch separator, but the GO language.
I’m always interested in learning new things, and GO has been one of...
2017-05-15
1,124 reads
Video: How to Use SQL Server 2016 Live Query Statistics for Watching Live Query Execution
In this video, I show how to enable live query statistics in SQL Server 2016 in order to see execution...
2017-05-15 (first published: 2017-05-03)
1,268 reads
Why shouldn’t I shrink my database log file?
TL;DR: It’s pretty pointless and can cause performance issues.
Let’s start by asking why you might want to shrink your log....
2017-05-15
487 reads
Data Warehousing Explained
Why Warehouse
Data warehousing is the act of transforming application database into a format more suited for reporting and offloading it...
2017-05-14
284 reads
Friday Reading 2017-05-12
The weather this week in Dublin has been absolutely fantastic, please hold out for the weekend. Anyway, whilst I’ve been...
2017-05-12
393 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