Category: Sqlserver

Deciding Between Editions of SQL Server for Production

Clusterless availability group — Read on www.mssqltips.com/sqlservertip/5579/deciding-between-editions-of-sql-server-for-production/ Excellent article describing the basic differences of each edition of SQL Server

Read More

Storage Configuration Guidelines for SQL Server on Azure VM | SQL Database Engine Blog

This is the blog of the engineering team managing and developing the Database Engine for SQL Server and Azure SQL Database — Read on blogs.msdn.microsoft.com/sqlserverstorageengine/2018/09/25/storage-configuration-guidelines-for-sql-server-on-azure-vm/

Read More

Truth First, or Why You Should Mostly Implement Database First Designs – Java, SQL and jOOQ.

In this much overdue article, I will explain why I think that in almost all cases, you should implement a “database first” design in your application’s data models, rather than a “Java first” design (or whatever your client language is), the latter approach leading to a long road of pain and suffering, once your project……

Read More

SQL Server tablediff command line utility

One problem that DBAs often face is maintaining lookups tables across multiple servers or sites. These tables could either be replicated or manually updated, but in any case sometimes the data in these tables get out of synch. In a previous tip we talke — Read on www.mssqltips.com/sqlservertip/1073/sql-server-tablediff-command-line-utility/

Read More

SQL Cheat Sheet: Retrieving Column Description in SQL Server

In this section we’ll be offering periodical advice, tips and tricks for solving practical issues in data analysis. Subscribe to our blog (in the box to your right) or follow Sisense on LinkedIn to receive updates as they’re published. – by Sisense – Tags: mssql, sqlserver, t-sql – https://www.sisense.com/blog/sql-cheat-sheet-retrieving-column-description-sql-server/

Read More

Identify SQL Server databases that are no longer in use

I have just inherited a SQL Server database server with numerous databases on it and I need to know if all the databases are in use or if they are old and can be removed. What is the best way to find out if databases are still active on my SQL Server? – by Brady…

Read More

Identify SQL Server databases that are no longer in use:

I have just inherited a SQL Server database server with numerous databases on it and I need to know if all the databases are in use or if they are old and can be removed. What is the best way to find out if databases are still active on my SQL Server? – by Brady…

Read More