Writing Dynamic and Random Tests Cases for Pester
I have written a module SQLDiagAPI for consuming the SQL Server Diagnostics API with PowerShell. I blogged about how I...
2017-07-06
456 reads
Blog Posts
Balanced Power Saving T-SQL script
We can easily spend tens of thousands of dollars on core licences for SQL Server, and then we go and...
2017-07-05
178 reads
Book Review: VMware vSphere 6.5 Host Resources Deep Dive
If you are actively managing VMware environments with workloads that have high performance needs (such as all of the virtualized...
2017-07-05
493 reads
Geo Location of Twitter messages in Power BI
[2017-June-25] There are several custom solutions that make Twitter messages analysis possible in Power BI. And with a recent addition of...
2017-07-05 (first published: 2017-06-25)
2,087 reads
Spell-checking dbatools with Visual Studio Code
Earlier this week I was working on adding a new feature to Update-DbaTools and while looking at another cmdlet to check syntax/conventions, I noticed an ugly typo in some...
2017-07-05
21 reads
SQL Server 2017+ How To Replace Multiple Characters In A Single Statement With TRANSLATE
The REPLACE function in SQL Server has until now been quite limited. SQL Server 2017 has introduced a new TRANSLATE...
2017-07-05
1,886 reads
SSoL–Exiting Root
I don’t think most of us need to know Linux, but if you end up managing a system, it’s good...
2017-07-05
596 reads
The Three A’s: Authentication
When I start talking with folks about security, one of the areas of confusion I often find has to do...
2017-07-05 (first published: 2017-06-26)
1,829 reads
When do Distribution Statistics Get Updated?
Statistics objects are important to us for allowing SQL to make good estimates of the row-counts involved in different parts...
2017-07-05
774 reads
Celebrate Your Independence with Free Tools
Been working on this blog post for a while, thought I'd share today an inventory of tools I use regularly...
2017-07-04
771 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Alamat Kontak Resmi BCA KCU DAGO Telp:Cs,0817781222
Wa:0817781222 Jl. Ir. H. Juanda No.118, Lebakgede, Kecamatan Coblong, Kota Bandung, Jawa Barat 40132
BCA KCU BEKASI Telp:Cs,0817781222
Wa:0817781222 Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel., Kota Bks, Jawa...
Alamat Kantor BCA KCU DAGO Telp:Cs,0817781222
Wa:0817781222 Jl. Ir. H. Juanda No.118, Lebakgede, Kecamatan Coblong, Kota Bandung, Jawa Barat 40132
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers