Google handoff to Site Reliability Engineering (SRE)

Part 1: https://cloudplatform.googleblog.com/2017/06/why-should-your-app-get-SRE-support-CRE-life-lessons.html

Part 2: https://cloudplatform.googleblog.com/2017/06/how-SREs-find-the-landmines-in-a-service-CRE-life-lessons.html

Part 3: https://cloudplatform.googleblog.com/2017/07/making-the-most-of-an-SRE-service-takeover-CRE-life-lessons.html

 

Posted in Uncategorized | Leave a comment

Linkdump: Business Intelligence

https://www.simple-talk.com/blogs/statistics-sql-simple-linear-regressions/

Dashboard Design Rules

Power BI Dashboard Design Video Course

A collection of graph/visual types compared in PDF:

http://www.sqlbi.com/wp-content/uploads/videotrainings/dashboarddesign/visuals-reference-may2017-A3.pdf

https://www.red-gate.com/simple-talk/sql/bi/deploying-securing-updating-power-bi-reports/

 

 

Posted in Uncategorized | Leave a comment

Linkdump: SQL Server T-SQL tips and tricks

SQL Server Row Count for all Tables in a Database

https://www.mssqltips.com/sqlservertip/2537/sql-server-row-count-for-all-tables-in-a-database/

One of several techniques posted by Dattatrey Sindo:

SELECT
QUOTENAME(SCHEMA_NAME(sOBJ.schema_id)) + ‘.’ + QUOTENAME(sOBJ.name) AS [TableName]
, SUM(sPTN.Rows) AS [RowCount]
FROM
sys.objects AS sOBJ
INNER JOIN sys.partitions AS sPTN
ON sOBJ.object_id = sPTN.object_id
WHERE
sOBJ.type = ‘U’
AND sOBJ.is_ms_shipped = 0x0
AND index_id < 2 — 0:Heap, 1:Clustered
GROUP BY
sOBJ.schema_id
, sOBJ.name
ORDER BY [TableName]
GO

Posted in Linkdump, SQL Server | Leave a comment

Linkdump: Docker, Puppet, SQL Server hosting

http://www.sqlservercentral.com/blogs/the-database-avenger/2017/06/13/orchestrating-sql-server-with-kubernetes/?utm_source=SSC&utm_medium=pubemail

http://www.sqlservercentral.com/blogs/the-dba-who-came-in-from-the-cold/2017/06/14/changing-default-location-for-docker-containers/?utm_source=SSC&utm_medium=pubemail

https://www.red-gate.com/simple-talk/sysadmin/containerization/overcoming-challenges-microservices-docker-containerisation/?utm_source=DBW&utm_medium=pubemail

 

 

Posted in Linkdump, SQL Server, System/DB Administration | Leave a comment

Onboarding tasks: SQL Server

https://www.mssqltips.com/sqlservertip/4871/sql-server-dba-onboarding-checklist/

 

Posted in Business, Linkdump, SQL Server | Leave a comment

Backup in SQL Server – advanced concepts/techniques

Introducing sp_AllNightLog: Log Shipping at Scale, Open Source

 

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/tail-log-backups-sql-server

http://www.sqlservercentral.com/articles/SQL+Server/158068/?utm_source=SSC&utm_medium=pubemail

 

Posted in Uncategorized | Leave a comment

How to Read the Transaction Log File

Whoa, nice.

How to Read the Transaction Log File

Have you ever wanted to be able to see the actual transactions that are contained in the transaction log file?  Well there is a way to read the transaction log file using an undocumented function.

http://www.databasejournal.com/features/mssql/how-to-read-the-transaction-log-file.html

 

Posted in Linkdump, SQL Server | Leave a comment

Kendra Little’s free SQL Server training webcasts

New Free Webcasts on Interviewing and Indexing

https://littlekendra.com/2017/06/29/new-free-webcasts-on-interviewing-and-indexing/

Posted in Linkdump, SQL Server, System/DB Administration | Leave a comment

LINQ basics

Basic LINQ Query Operations (C#)

https://docs.microsoft.com/en-us/dotnet/csharp/programming-guide/concepts/linq/basic-linq-query-operations

 

Posted in Linkdump, Programming | Leave a comment

Linkdump: Security- Web pages, Linux, Amazon Web Services

Web pages

https://www.owasp.org/index.php/Top_10_2010-Main

https://www.owasp.org/index.php/Top_10_2017-Top_10

Linux

Don’t believe these four myths about Linux security

AWS (Amazon Web Services)

https://cloudonaut.io/aws-security-primer/

https://cloudonaut.io/your-single-aws-account-is-a-serious-risk/

https://www.simple-talk.com/sql/database-administration/automating-synchronization-rds-sql-server-agent-jobs-multi-az-environment/

Posted in Linkdump, System/DB Administration | Leave a comment