Powershell script to find new servers in an AD domain
This is actually part of a process I am creating to automatically discover SQL Server instances in an Active Directory domain. So there...
2019-06-19 (first published: 2019-06-06)
1,351 reads
Blog Posts
What is a container anyway?
Recently there was a thread on Twitter which established that a lot of IT people didn’t know the difference between virtual machines and containers. |???????|| CONTAINERS || ARE NOT...
2019-06-19
135 reads
What permissions do temp stored procedures use?
In a performance tuning class I recently took with Brent Ozar (b/t) he mentioned temporary stored procedures and an interesting ... Continue reading
2019-06-19
105 reads
Achieving application consistent recovery points of SQL Server 2008 R2 with Azure Site Recovery in Azure
If you want to use ASR to replicate SQL Server 2008 R2 standalone or clustered instances, you will need to update the SQL Writer to 2012 or later. You...
2019-06-18
134 reads
Globally Distributed Azure Cosmos DB
Let’s use the Azure portal to build a globally distributed Cosmos DB. Before doing this, why would you ? what are the benefits? Regional based. By this I mean...
2019-06-18
61 reads
Implicit Conversion Fail
Implicit conversions are not uncommon in the computing world and can be viewed as kind of a fail-safe for when we don't quite follow decent practices when designing the...
2019-06-18 (first published: 2019-05-31)
428 reads
Trailing Spaces in SQL Server
Watch this week's video on YouTube
A long time ago I built an application that captured user input. One feature of the application was to compare the user's input against...
2019-06-18
8 reads
Trailing Spaces in SQL Server
Watch this week's video on YouTube
A long time ago I built an application that captured user input. One feature of the application was to compare the user's input against...
2019-06-18
23 reads
Trello For The User Group
I’m trying Trello this year to manage both SQLSaturday and our other events. Part of that is giving the whole team visibility of the work that remains to be...
2019-06-18
71 reads
What You Need to Know About Data Classifications in Azure SQL Data Warehouse
Data classifications in Azure SQL DW entered public preview in March 2019. They allow you to label columns in your data warehouse with their information type and sensitivity level....
2019-06-18 (first published: 2019-05-30)
423 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
Alamat kontak resmi BCA KCU SEMARANG | Telp: 0817825533
phone, Wa: 0817825533, Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah...
BCA KCP Gatot Subroto Barat TLP/WA 0821-697-7749
Jl. Gatot Subroto Barat No.334 Blok B, Padangsambian Kaja, Kec. Denpasar Bar., Kota Denpasar,...
BCA KCP Gatot Subroto Dps TLP/CS 0821•697•7749
Jl. Gatot Subroto Barat No.80 unit 8-9, Dangin Puri Kaja, Kec. Denpasar Utara, Kota...
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers