Information Measurement with SQL Server, Part 1: A Quick Review of the Hartley Function
By Steve Bolton
…………This long-delayed series of amateur self-tutorials has been in the works ever since I began writing my A...
2017-07-28
519 reads
Blog Posts
Power BI NFL Football Stats Comparisons and Analysis Report is now available!
For the past few years I’ve combined my love of professional football and analytics by releasing a series of Power...
2017-07-28
525 reads
PowerShell $env Variables
I was playing with containers the other day, reading a Simple Talk article on the topic, and noticed the code...
2017-07-28 (first published: 2017-07-17)
2,015 reads
Speaking at SQL Saturday Denver (#673)
Wow, I can hardly contain my excitement. I was selected to speak at SQL Saturday Denver on September 16, 2017. I’ll...
2017-07-28
318 reads
Using Test-DbaOptimizeForAdHoc
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
2017-07-28
464 reads
Azure Labs–Minor Cluster Issues for SQL Server Setup
During the process of building an Azure lab, I ran into a place where my cluster was not completely validated....
2017-07-27
531 reads
Default reports in SSMS
As DBAs our stock in trade is information and there is certainly an impressive amount available. The diagnostic views are...
2017-07-27 (first published: 2017-07-13)
2,629 reads
SQL Server 2017 – DMV – sys.dm_os_host_info
I always love to get my hands dirty with new features of SQL Server. I was exploring SQL Server on...
2017-07-27 (first published: 2017-07-14)
2,186 reads
Two Ways to Restore Database from MDF File in SQL Server
Introduction
In todays decade Relational database Management system became the necessity of the organizations whether they are small level or large level. In such context SQL Server is the best...
2017-07-27
30 reads
Happy Belated 150th Birthday Canada, and the Importance of Compliance, Especially Vulnerability Assessments
Assess your vulnerabilities before a system compromise brings it all down: just like what wasn't done early morning on Zhiggy's...
2017-07-26
798 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
Midjourney, Healthcare?
Comments posted to this topic are about the item Midjourney, Healthcare?
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers