Microsoft Build event announcements
Another Microsoft event and another bunch of exciting announcements. At the Microsoft Build event this week, the major announcements in the data...
2018-05-11
818 reads
SQL Server Database Snapshots
What Are They
Database snapshots are a readonly point in time version of a database. You can use them for things...
2018-05-11
2,261 reads
Reviewing the SQL Server ERROR log
The SQL Server ERROR log is the best source to understand what’s wrong with your SQL Server instance, think this...
2018-05-10
119 reads
DMV To List Foreign Keys With No Index
I was entrusted with a new database for a critical application that was having general performance issue and the CPU...
2018-05-10
1,569 reads
How To Audit Data Changes In SQL Server?
Scenario:
I was at a new client, with their previous and only DBA / DEVELOPER/ MASTER OF ALL of 8 years all...
2018-05-10
10,408 reads
Finding Tabs in SSMS–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-05-10
472 reads
Day 10 Option file
So far we have discussed various mays to configure MySQL, Environmental Variables, Global Variable, Session Variables, Status Variable and Server...
2018-05-10
215 reads
PASS Summit 2018 Pre-con: Digital Storytelling with Power BI
Mitchell Pearson, Brian Knight and myself will be presenting a full day pre-con as PASS Summit on Digital Storytelling with...
2018-05-10
744 reads
Creating SQL Server Containers for versions 2012-2017
I am working on my dbatools and dbachecks presentations for SQL Saturday Finland, SQLDays, SQL Saturday Cork and SQLGrillen I want...
2018-05-10
369 reads
Each session should be able to have its own temp table, but there can be problems.
You should be able to create a #temp in every session. That’s the idea, right? It’s one of the things...
2018-05-10
989 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