Category Archives: SQL Server

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 … Continue reading

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    

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

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 … Continue reading

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

Phil Factor @ SimpleTalk: Statistics in SQL: Pearson’s Correlation

Statistics in SQL: Pearson’s Correlation The series so far: Statistics in SQL: Pearson’s Correlation Statistics in SQL: Kendall’s Tau Rank Correlation Statistics in SQL: Simple Linear Regressions Statistics in SQL: The Kruskal–Wallis Test

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

RedGate: VMWare monitoring in SQL Monitor

VMware monitoring in SQL Monitor  

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

Database unit testing resources

Not strictly a linkdump, but a list of resources for database unit testing. tSQLt, SQLunit, DBunit, dbForge

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

Linkdump: SQL Server security through ActiveDirectory Groups, ConnectionString encryption

I swear I have a post or linkdump on this. Log now, search later! Securing SQL Server using ActiveDirectory: https://www.mssqltips.com/sqlservertip/1831/using-windows-groups-for-sql-server-logins-as-a-best-practice/ https://serverfault.com/questions/457798/why-does-a-d-account-need-sql-server-login https://security.stackexchange.com/questions/98247/ad-user-vs-sql-user-for-sql-server-authentication https://dba.stackexchange.com/questions/12453/login-to-sql-server-using-windows-authentication Connection String encryption: https://msdn.microsoft.com/en-us/library/89211k9b(v=vs.110).aspx https://msdn.microsoft.com/en-us/library/ms254494(v=vs.110).aspx http://stackoverflow.com/questions/11637348/encrypt-connection-string-in-app-config https://msdn.microsoft.com/en-us/library/ff647398.aspx          

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

SQL Server linkdump: Create login, Relocate database and best practices, corruption repairs

https://www.google.com/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=sql+server2016+create+new+login&* https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/create-a-login http://www.quackit.com/sql_server/sql_server_2014/tutorial/sql_server_user_logins.cfm https://www.supremainc.com/en/node/618   https://www.google.com/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=moving+a+database+from+one+drive+to+another+detach+database&* http://dba.stackexchange.com/questions/52007/how-do-i-move-sql-server-database-files https://docs.microsoft.com/en-us/sql/relational-databases/databases/move-user-databases https://docs.microsoft.com/en-us/sql/relational-databases/databases/move-system-databases     https://www.google.com/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=ozar+how+to+requisition+drives+for+sql+server&* SQL Server 2005 Setup Checklist Part 2: After The Install https://www.sqlskills.com/blogs/paul/multiple-log-files-and-why-theyre-bad/     When should you put data and logs on the same drive?   SAN Storage Best … Continue reading

Posted in Linkdump, SQL Server | Leave a comment